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.

Functions
3
Sign-in
Not needed
Works with
MCP, HTTP, Node, Python

Connect

Just docs.google.com — Google Sheets

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_sheets
Every site

One 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/mcp
Set it up in your client

Both 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.

Read 3
  • findSpreadsheetsFinds public Google Sheets spreadsheets on docs.google.com/spreadsheets about a topic ("nfl schedule", "budget template") and returns each one's…

    Arguments

    NameTypeRequired
    querystringYes

    Returns SpreadsheetHit[]

    interface SpreadsheetHit {
      spreadsheetId: string;
      title: string;
      url: string;
    }

    HTTP endpoint

    POST https://api.bowmark.ai/v1/sites/google_sheets/findSpreadsheets

    Call it

    import { bowmark } from "@bowmark/web";
    
    const result = 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

    NameTypeRequired
    spreadsheetstringYes

    Returns SpreadsheetTabs

    interface SheetTab {
      name: string;
      gid: string;
    }
    
    interface SpreadsheetTabs {
      spreadsheetId: string;
      title: string;
      sheets: SheetTab[];
    }

    HTTP endpoint

    POST https://api.bowmark.ai/v1/sites/google_sheets/listSheets

    Call it

    import { bowmark } from "@bowmark/web";
    
    const result = 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

    NameTypeRequired
    spreadsheetstring
    A Google Sheets URL or its bare spreadsheet id.
    Yes
    sheetstring
    The tab NAME, as listSheets returns it.
    No
    rangestring
    A1 notation, e.g. "A1:C10" or "B:D".
    No

    Returns SheetValues

    interface 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/readSheet

    Call it

    import { bowmark } from "@bowmark/web";
    
    const result = await bowmark.providers.google_sheets.readSheet({
      spreadsheet: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
      range: "A1:F5"
    });

Use it from code