Read, write, and format Google Sheets data — use your spreadsheets as a live AI-accessible data source.
Use with AI AssistantsMCP
Connect Claude, Cursor, or any MCP-compatible client — then call tools directly
① Add This MCP Server
Paste into your AI client config — then all its tools are available instantly.
{
"mcpServers": {
"google-sheets": {
"url": "https://mcp.aerostack.dev/s/aerostack/mcp-google-sheets",
"headers": {
"Authorization": "Bearer YOUR_AEROSTACK_TOKEN"
}
}
}
}Replace YOUR_AEROSTACK_TOKEN with your API token from the dashboard.
② Call a Tool
Ask your AI assistant to call a specific tool, or send raw JSON-RPC:
Natural Language Prompt
“Use the _ping tool to verify google sheets credentials by calling a lightweight read endpoint. used internally by aerostack to validate credentials”
Using a Workspace?
Add this MCP to your Workspace — your team shares one token, secrets are stored securely, and every AI agent in the workspace can call it without per-user setup.
Read, write, search, and format Google Sheets spreadsheets — give AI agents a live data layer backed by the world's most popular spreadsheet tool.
Google Sheets is used by millions of teams as a lightweight database, reporting tool, and operational hub. This MCP server gives your agents full access to the Sheets API v4: reading and writing cell ranges, appending rows, searching data, managing sheet tabs, applying formatting, and creating new spreadsheets — making Sheets a fully programmable data store for AI-driven workflows.
Live endpoint: https://mcp.aerostack.dev/s/aerostack/mcp-google-sheets
| Tool | Description |
|---|---|
| get_spreadsheet | Get spreadsheet metadata — title, sheet names, grid dimensions, named ranges |
| create_spreadsheet | Create a new spreadsheet with a title and optional initial sheet tabs |
| list_sheets | List all sheet tabs in a spreadsheet with IDs and indexes |
| read_range | Read cell values from a specific A1 notation range |
| read_multiple_ranges | Batch-read multiple ranges in a single API call |
| get_all_values | Read all values from an entire sheet tab |
| find_row | Search for rows where any cell contains a substring (case-insensitive) |
| write_range | Write a 2D array of values to a range, overwriting existing cells |
| append_rows | Append new rows after the last row with data |
| clear_range | Clear all values from a range without affecting formatting |
| update_cell | Update a single cell value or formula |
| batch_update_values | Update multiple ranges in one API call |
| add_sheet | Add a new sheet tab to an existing spreadsheet |
| delete_sheet | Permanently delete a sheet tab and all its data |
| rename_sheet | Rename a sheet tab |
| copy_sheet | Copy a sheet tab to another (or the same) spreadsheet |
| format_range | Apply bold text or background color to a cell range |
| auto_resize_columns | Auto-resize columns to fit their content |
| Variable | Required | Description | How to Get |
|---|---|---|---|
| GOOGLE_SHEETS_ACCESS_TOKEN | Yes | OAuth 2.0 access token with spreadsheets scope | Google Cloud Console → APIs → Sheets API → OAuth 2.0 credentials |
GOOGLE_SHEETS_ACCESS_TOKEN under Project → SecretsOnce added, every AI agent in your workspace can read and write Google Sheets automatically — no per-user setup needed.
"Append a new row to the Sales Pipeline sheet with today's date, Acme Corp, and $50,000 deal value"
"Search the Customers sheet for any row containing 'enterprise' and return the results"
"Create a new spreadsheet called 'Q1 Report' with tabs for Revenue, Expenses, and Summary"
curl -X POST https://mcp.aerostack.dev/s/aerostack/mcp-google-sheets \
-H 'Content-Type: application/json' \
-H 'X-Mcp-Secret-GOOGLE-SHEETS-ACCESS-TOKEN: your-token' \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"read_range","arguments":{"spreadsheet_id":"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms","range":"Sheet1!A1:D10"}}}'
MIT
Live Endpoint
https://mcp.aerostack.dev/s/aerostack/mcp-google-sheets
Sub-50ms globally · Zero cold start
@aerostack
Pre-built functions for the most common MCP tool patterns. Clone, extend, and deploy.
by @aerostack
Search, index, and manage documents in your Elasticsearch cluster — AI-native full-text search and analytics.
by @aerostack
Scrape web pages, crawl entire sites, extract structured data, and search the web — AI-native web data extraction for RAG pipelines.
by @aerostack
Manage Google Ads campaigns, ad groups, keywords, and budgets — automate your PPC advertising with AI.
by @aerostack
Manage CMS collections, publish content, and control site deployments in Webflow — AI-powered web publishing.
by @aerostack
Create, read, edit, and format Google Docs — paragraph styling, tables, images, comments, and real-time collaboration via Google Docs API.
by @aerostack
Create and manage Google Meet spaces, schedule meetings via Google Calendar, list participants, access recordings and transcripts.
Yes. Use read_range to fetch values, process them in Claude, then write_range or update_cell to push results back. batch_update_values handles bulk writes in a single API call to avoid quota limits.
find_row searches by column value and returns the matching row index. For large sheets this is far faster than reading all values with get_all_values and filtering in memory.
Yes. add_sheet creates a new sheet tab within an existing spreadsheet. You can then write_range into it immediately. rename_sheet and copy_sheet are also available for post-creation management.
format_range applies static cell formatting — background color, bold, font size, number format. Conditional formatting rules are not supported via this tool; use the Sheets UI for conditional rules.