docs.google.com — Google Sheets MCP server for AI agents
Let Claude, ChatGPT or your own agent read docs.google.com — Google Sheets: 3 typed functions through one MCP server. No docs.google.com — Google Sheets API key needed.
- Site
- docs.google.com
- Functions
- 3
- Sign-in
- Not needed
- Works with
- MCP, HTTP, Node, Python
Connect
An MCP server for docs.google.com — Google Sheets alone, with one tool per function. Paste it into Claude, ChatGPT, Cursor or any MCP client as a remote server.
https://api.bowmark.ai/mcp/site/google_sheetsOne MCP server for docs.google.com — Google Sheets and every other site Bowmark covers. Your agent looks up what it needs and calls it.
https://api.bowmark.ai/mcpSet it up in your clientBoth need a Bowmark API key. The quickstart gets you one and a first result in a few minutes.
Functions
Open a function to see its arguments, what it returns and how to call it.
findSpreadsheetsFinds public Google Sheets spreadsheets on docs.google.com/spreadsheets about a topic ("nfl schedule", "budget template") and returns each one's…Arguments
Name Type Required querystringYes Returns
SpreadsheetHit[]interface SpreadsheetHit { spreadsheetId: string; title: string; url: string; }HTTP endpoint
POST https://api.bowmark.ai/v1/sites/google_sheets/findSpreadsheetsCall it
import { bowmark } from "@bowmark/web"; const result = await bowmark.providers.google_sheets.findSpreadsheets("nfl schedule");import asyncio from bowmark_web import bowmark result = asyncio.run(bowmark.providers.google_sheets.findSpreadsheets("nfl schedule"))curl -X POST https://api.bowmark.ai/v1/sites/google_sheets/findSpreadsheets \ -H "Authorization: Bearer $BOWMARK_API_KEY" \ -H "Content-Type: application/json" \ -d '{"query":"nfl schedule"}'// The body of a run: the MCP run tool, or POST /v1/run return await bowmark.providers.google_sheets.findSpreadsheets("nfl schedule");listSheetsLists the tabs (sheets) of a public or link-shared Google Sheets spreadsheet on docs.google.com.Arguments
Name Type Required spreadsheetstringYes Returns
SpreadsheetTabsinterface SheetTab { name: string; gid: string; } interface SpreadsheetTabs { spreadsheetId: string; title: string; sheets: SheetTab[]; }HTTP endpoint
POST https://api.bowmark.ai/v1/sites/google_sheets/listSheetsCall it
import { bowmark } from "@bowmark/web"; const result = await bowmark.providers.google_sheets.listSheets("1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms");import asyncio from bowmark_web import bowmark result = asyncio.run(bowmark.providers.google_sheets.listSheets("1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"))curl -X POST https://api.bowmark.ai/v1/sites/google_sheets/listSheets \ -H "Authorization: Bearer $BOWMARK_API_KEY" \ -H "Content-Type: application/json" \ -d '{"spreadsheet":"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"}'// The body of a run: the MCP run tool, or POST /v1/run return await bowmark.providers.google_sheets.listSheets("1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms");readSheetReads the cell values from a public or link-shared Google Sheets spreadsheet on docs.google.com as a header row plus rows of strings.Arguments
Name Type Required spreadsheetstringA Google Sheets URL or its bare spreadsheet id.Yes sheetstringThe tab NAME, as listSheets returns it.No rangestringA1 notation, e.g. "A1:C10" or "B:D".No Returns
SheetValuesinterface SheetValues { spreadsheetId: string; sheet: string | null; range: string | null; /** The first row of the returned block. */ headers: string[]; rows: string[][]; }HTTP endpoint
POST https://api.bowmark.ai/v1/sites/google_sheets/readSheetCall it
import { bowmark } from "@bowmark/web"; const result = await bowmark.providers.google_sheets.readSheet({ spreadsheet: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms", range: "A1:F5" });import asyncio from bowmark_web import bowmark result = asyncio.run(bowmark.providers.google_sheets.readSheet({ "spreadsheet": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms", "range": "A1:F5" }))curl -X POST https://api.bowmark.ai/v1/sites/google_sheets/readSheet \ -H "Authorization: Bearer $BOWMARK_API_KEY" \ -H "Content-Type: application/json" \ -d '{"args":{"spreadsheet":"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms","range":"A1:F5"}}'// The body of a run: the MCP run tool, or POST /v1/run return await bowmark.providers.google_sheets.readSheet({ spreadsheet: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms", range: "A1:F5" });
Use it from code
- Node
npm i @bowmark/web - Python
pip install bowmark-web - HTTP
POST /v1/sites/google_sheets/<function> - OpenAPI
/v1/sites/google_sheets/openapi.json