Google Sheets MCP Server by xing5: Setup for Claude, Cursor and Other Apps

• Lists the spreadsheets in your Drive folder

  Returns the id and title of each spreadsheet in the shared Drive folder, or in My Drive if you set no folder.

  Try: “List every spreadsheet in my AI Managed Sheets folder.”

  Network · list_spreadsheets

• Finds spreadsheets by name or content

  Searches Google Drive for spreadsheets whose name or content matches your words, up to 100 results.

  Try: “Find my spreadsheets that mention "Q3 budget".”

  Network · search_spreadsheets

• Lists Drive folders

  Shows the folders inside a parent folder, or in the root of My Drive, with their ids.

  Try: “Show the folders in my Drive root.”

  Network · list_folders

• Lists the tabs in a spreadsheet

  Returns the names of all tabs in one spreadsheet so the assistant can pick the right one.

  Try: “What tabs does the Sales Report spreadsheet have?”

  Network · list_sheets

• Reads cells from a tab

  Reads a range such as A1:C10, or a whole tab, as values. It can return full grid data with formatting, which is much larger.

  Try: “Read A1 to E10 from Sheet1 of Quarterly Sales Report.”

  Network · get_sheet_data

• Reads formulas from a tab

  Returns the formulas in a range as a grid, not the calculated values.

  Try: “Show me the formulas in column D of the Budget tab.”

  Network · get_sheet_formulas

• Reads several ranges in one call

  Takes a list of spreadsheet, tab and range triples and returns each result, with an error note for any that failed.

  Try: “Pull B2:B10 from Sales and C2:C10 from Inventory in one go.”

  Network · get_multiple_sheet_data

• Previews several spreadsheets

  Returns the title, tab names, headers and the first few rows of each spreadsheet you list.

  Try: “Give me a quick summary of the Sales Data and Inventory Count spreadsheets.”

  Network · get_multiple_spreadsheet_summary

• Finds cells that contain a word

  Searches one tab or every tab for cells containing your text and returns each match with its cell address and value.

  Try: “Find every cell containing "overdue" in the Invoices spreadsheet.”

  Network · find_in_spreadsheet

• Makes a new spreadsheet

  Creates an empty spreadsheet with your title, in the folder you name or the configured default folder.

  Try: “Create a spreadsheet called Quarterly Sales Report Q3.”

  Write · create_spreadsheet

• Adds a tab

  Adds a new tab with the name you give to an existing spreadsheet.

  Try: “Add a tab named Summary to the Project Tasks spreadsheet.”

  Write · create_sheet

• Writes values into a range

  Writes a grid of values into a range. It overwrites whatever was in those cells.

  Try: “Set B2 on the Tasks tab to "In Progress".”

  Write · update_cells

• Writes to several ranges at once

  Updates many ranges of one tab in a single call, each range given its own grid of values.

  Try: “Fill A1:B2 with the monthly totals and D5 with "Done".”

  Write · batch_update_cells

• Inserts empty rows

  Inserts a number of blank rows at a row position you pick. The default position is the top of the tab.

  Try: “Insert 3 blank rows at row 10 of the Log tab.”

  Write · add_rows

• Inserts empty columns

  Inserts a number of blank columns at a column position you pick. The default is the left edge.

  Try: “Add 2 empty columns after column C on Sheet1.”

  Write · add_columns

• Copies a tab into another spreadsheet

  Duplicates a tab from one spreadsheet to another and gives the copy the name you choose.

  Try: “Copy the Template tab from Master into the Q4 spreadsheet.”

  Write · copy_sheet

• Renames a tab

  Changes the name of an existing tab.

  Try: “Rename Sheet1 to Transactions in the Ledger spreadsheet.”

  Write · rename_sheet

• Adds a chart from a range

  Builds a column, bar, line, area, pie, scatter, combo or histogram chart from a range, with optional title, axis labels, position and size.

  Try: “Add a column chart of monthly revenue from A1:B13 in the Sales Report.”

  Write · add_chart

• Shares a spreadsheet with people

  Gives the email addresses you list reader, commenter or writer access, and emails them unless you turn notifications off.

  Try: “Share the Team Vacation Schedule with team@example.com as a reader, without notifications.”

  Write · share_spreadsheet

• Runs raw Sheets batch requests

  Sends any list of Google Sheets batchUpdate requests, which includes deleting rows, columns and conditional-format rules as well as formatting and adding tabs.

  Try: “Delete rows 5 to 10 on Sheet1 of the Log spreadsheet.”

  Delete · batch_update

Watch out for

• It can delete rows and columns

  batch_update accepts any Sheets request, including deleting rows, columns and rules, and is flagged destructive. Use filtering to leave it out, and keep copies of important sheets. github.com

• It asks Google for full Drive access

  The server requests the whole Drive and Sheets scopes. A service account only sees what you share with it, so share one folder, not your whole Drive. github.com

• It can share files by email

  share_spreadsheet gives people reader, commenter or writer access and emails them by default. Leave it out of your enabled tools if you do not want the assistant sharing files. github.com

• update_cells overwrites existing data

  Writes replace whatever is in the target cells with no undo from the server. Ask the assistant to confirm the range first. github.com

• SSE mode listens on every network interface with no sign-in

  With --transport sse the server binds to 0.0.0.0 on port 8000 unless you set HOST or FASTMCP_HOST, and the README's Docker example sets HOST=0.0.0.0. Anyone on your network could then call the tools with your Google credentials. Keep the default stdio mode, or bind to 127.0.0.1. github.com

• Reads cost context

  With all tools on, the README says they use about 13,000 tokens before you type anything. Filtering to the tools you need cuts that. github.com

Security advisories