Google Sheets MCP server for AI agents
Create spreadsheets, read and write cell ranges, append rows and manage tabs in Google Sheets.
- Auth
- OAuth 2.0 (sign in with the app)
- Tools
- 8
- Triggers
- 0
- Category
- Spreadsheets
Tools and triggers
Create a spreadsheet
GOOGLESHEETS_CREATE_SPREADSHEET
Creates a new spreadsheet in the user's Drive and returns its id and URL.
Get spreadsheet metadata
GOOGLESHEETS_GET_SPREADSHEET
Returns a spreadsheet's title and its tabs (names, ids, row and column counts) without cell data.read-only
Read a range of cells
GOOGLESHEETS_GET_VALUES
Reads the values of an A1 range as rows.read-only
Read several ranges
GOOGLESHEETS_BATCH_GET_VALUES
Reads several A1 ranges of one spreadsheet in a single call.read-only
Write values to a range
GOOGLESHEETS_UPDATE_VALUES
Writes rows of values starting at the top-left cell of the range, overwriting what is there.destructive
Append rows
GOOGLESHEETS_APPEND_VALUES
Adds rows after the last row of the table found in the range, e.g. `Sheet1` or `Sheet1!A:D`.
Clear ranges
GOOGLESHEETS_BATCH_CLEAR_VALUES
Removes the values (not the formatting) from one or more A1 ranges.destructive
Add a tab
GOOGLESHEETS_ADD_SHEET
Adds a new tab (sheet) to an existing spreadsheet.
Connect via MCP
Create an MCP server for Google Sheets in the dashboard, then add its URL to your client. This is the Claude Code command; the client guide has the others.
claude mcp add --transport http googlesheets \
"https://www.prompt-tm.com/mcp/<server id>?user_id=<your user>" \
--header "x-api-key: ptm_…"Connect via REST
Run a tool with one request. The response is { data, error, successful, log_id } for every tool.
curl -X POST https://www.prompt-tm.com/api/v3/tools/execute/GOOGLESHEETS_CREATE_SPREADSHEET \
-H "x-api-key: $PROMPT_TM_KEY" -H "content-type: application/json" \
-d '{ "user_id": "alice", "arguments": {} }'