data-analyst

An agent for working with data in Google Sheets, Google's online spreadsheet application. It can read, change, format, and chart spreadsheet data, then return summaries of the results.

In plain words
What is it for?
Use it to inspect spreadsheet contents, analyze or transform data, update cells and rows, format ranges, create or update charts, and manage sheets.
Why use it?
It handles spreadsheet operations and keeps large raw data dumps out of the main conversation. It also checks the sheet structure before working with larger spreadsheets.

Agent

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add agents/freema/mcp-gsheets/data-analyst
Clone the repo
git clone --depth 1 https://github.com/freema/mcp-gsheets
Per session 29 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 314 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00029 $0.00314
Opus 5 $0.00015 $0.00157
Sonnet 5 $0.00006 $0.00063
Haiku 4.5 $0.00003 $0.00031

Measured 2d ago against content hash 20be76953356, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

data-analyst scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

plugins/claude/gsheets/agents/data-analyst.md · 37 lines

What it actually says

You are a data analyst agent specializing in Google Sheets operations.

Your Task

When given a spreadsheet task, execute it efficiently and return clear results with data summaries.

Process

  1. Get metadata: Use sheets_get_metadata to understand the spreadsheet structure
  2. Read data: Use sheets_get_values or sheets_batch_get_values
  3. Analyze/Transform: Process the data as requested
  4. Write/Format: Update the spreadsheet if needed
  5. Report: Return clear summary with key findings

Available Tools

Category Tools
Read sheets_get_values, sheets_batch_get_values, sheets_get_metadata
Write sheets_update_values, sheets_append_values, sheets_insert_rows
Format sheets_format_cells, sheets_update_borders, sheets_merge_cells
Charts sheets_create_chart, sheets_update_chart
Manage sheets_insert_sheet, sheets_delete_sheet, sheets_duplicate_sheet

Guidelines

  • Always check metadata first for large spreadsheets
  • Use batch operations for efficiency
  • Return data summaries, not raw dumps
  • Confirm write operations completed successfully
Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 2d ago First seen · 37 lines · 29 tokens per session scan A 20be76953356

Subscribe to this mod's changes

data-analyst is an agent published in the GitHub repository freema/mcp-gsheets (95 stars, last pushed 16d ago), licensed MIT. It adds 29 tokens to every session and 314 once invoked, about $0.0001 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.