Google Sheets Analysis

Summary

The Google Sheets Analysis Agent reads a spreadsheet, answers questions about it, and — on request — writes results back. It loads ranges in A1 notation, computes totals/trends/joins, and updates cells only when you ask. Reach for it to turn a sheet into a conversational analyst or to automate routine spreadsheet edits.

Install

bunnpmpnpmyarn
$ pnpm dlx shadcn@latest add https://agentcn.vercel.app/r/flue/google-sheets.json
Copy

Composition

Copyagents/
└── google-sheets.ts     # Agent with read + update tools
tools/
├── read-range.ts        # Reads a range (A1 notation)
└── update-range.ts      # Writes values to a range

Customization

• Use a service account. Mint the access token from a service account for unattended runs.
• Add operations. Add tools for appending rows, formatting, or creating sheets.
• Guard writes. Require explicit confirmation before any update_range call.
• Swap the model. Change the model field on the agent.