// MCP TOOL REFERENCE

MCP GOOGLE SHEETS TOOLS

13 tools from the Mcp Google Sheets MCP Server, categorised by risk level.

// ALL 13 MCP GOOGLE SHEETS TOOLS

READ 4 tools

Read listSheets Lists all the sheets present in the spreadsheet. Accepts spreadsheet id as input argument Read listSpreadsheets Returns a list of all the spreadsheets present within the current context. Returns the spreadsheet data in ... Read sheetData Returns the data present in the specified sheet, in the given range. If the range is not provided, it gives... Read spreadsheetInfo Gives info about the spreadsheet. Accepts spreadsheetId as an argument.

WRITE 9 tools

Write addColumns Adds the specified number of columns to the specified sheet. Accepts spreadsheetId, sheetname, count of col... Write addRows Adds the specified number of rows to the specified sheet. Accepts spreadsheetId, sheetname, count of rows t... Write batchUpdate Updates a range of values using the batchUpdate function of google sheets. The ranges are provided along wi... Write copySheet Copies the contents of the source sheet to destination sheet. Accepts srcSpreadsheet, srcSheet, dstSpreadsh... Write create Creates a spreadsheet by taking the new sheet Write createSheet Creates a new sheet in the spreadsheet provided as an argument. Accepts spreadsheet id and name of the shee... Write renameSheet Renames the provided sheet. Accepts spreadsheet id, old name and new name of the sheet as input arguments Write shareSpreadsheet Shares the provided spreadsheet to the recipients provided as an argument. Accepts recipients as an array o... Write updateCells Updates the values present in the cells specified in the given range for the provided sheet. Accepts spread...

// FAQ

How many tools does the Mcp Google Sheets MCP server have? +

The Mcp Google Sheets MCP server exposes 13 tools across 2 categories: Read, Write.

How do I enforce policies on Mcp Google Sheets tools? +

Route the Mcp Google Sheets server through the PolicyLayer gateway. Define allow, deny, or approval rules per tool in the dashboard; they are enforced on every call before it reaches the server.

What risk categories do Mcp Google Sheets tools fall into? +

Mcp Google Sheets tools are categorised as Read (4), Write (9). Each category has a recommended default policy.

Enforce policy on every Mcp Google Sheets tool call.

Start from Mcp Google Sheets, add the rest of your stack, and see everything your agents can call. Then put policy on all of it.

CHECK YOUR STACK →

Free to start. No card required.

43,000+ MCP servers and 220,000+ tools scanned and risk-classified.