Google Sheets — Spreadsheet Automation & Data Pipelines

The Backbone of Lightweight Data Workflows

Google Sheets is the world's most accessible spreadsheet platform, and with the MCP server your AI agent can treat any sheet as a live database. Read ranges, append rows, update cells, run formulas, and format data — all through natural language commands. It's the fastest way to build data pipelines without writing a single line of code.

• Read & Write Ranges: Fetch any cell range as structured data, or append and update rows in real time. Perfect for logs, CRMs, and trackers.
• Formula Execution: Let your agent insert and evaluate formulas, build calculated columns, and auto-fill summaries without manual editing.
• Formatting & Validation: Apply number formats, conditional formatting, and data validation rules to keep spreadsheets clean and consistent.
• Data Pipelines: Pipe data between Sheets and other skills — scrape a webpage, summarize it, and log the result into a sheet automatically.

Configuration

"mcpServers": {
  "google-sheets": {
    "command": "npx",
    "args": ["-y", "@mcp/google-sheets-server"],
    "env": {
      "GOOGLE_CLIENT_ID": "your-client-id",
      "GOOGLE_CLIENT_SECRET": "your-client-secret",
      "GOOGLE_REFRESH_TOKEN": "your-refresh-token"
    }
  }
}

Create a Google Cloud OAuth credential and enable the Sheets API to obtain your client ID, secret, and refresh token.

Top Prompts

1. "Read the 'Sales' sheet, summarize this month's revenue by region, and email me the report."
2. "Every time I add a row to the 'Leads' sheet, enrich it with company info and update the status column."
3. "Create a new sheet called 'Weekly Report' with headers and pre-fill it with last week's data."
4. "Monitor the 'Errors' sheet — when a new row with severity 'critical' appears, alert me on Telegram immediately."