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 @agentcn/eve/google-sheets
Copy

Composition

Copyagent/
├── agent.ts             # Agent definition (model + config)
├── instructions.md      # Read-before-write analysis instructions
└── 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. Edit agent/agent.ts.