list_sheets
Navigate tabs
How to use it
list_sheets is exposed by the MCP Google Sheets MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the list_sheets tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install MCP Google Sheets
uvx mcp-google-sheets@latestOther tools in MCP Google Sheets (39)
(integer): Number of empty rows to insert.
(array of arrays): 2D array of values to write. Example: [[1, 2, 3], ["a", "b", "c"]].
(string): Desired sheet/tab name in the destination spreadsheet.
(string): Destination spreadsheet ID (from its URL).
(optional string): Google Drive folder ID to search in. Get from its URL. If omitted, uses the configured default folder or searches 'My Drive'.
Read from spreadsheets
(optional boolean, default False): If True, returns full grid data including formatting and metadata (much larger). If False, returns values only (more efficient).
Find spreadsheets
(array of objects): Each object needs spreadsheetid, sheet, and range. Example: [{"spreadsheetid": "abc", "sheet": "Sheet1", "range": "A1:B2"}, ...].
(optional string): A1 notation (e.g., 'A1:C10', 'Sheet1!B2:D'). If omitted, reads the whole sheet/tab specified by sheet.
(object): Dictionary mapping range strings (A1 notation) to 2D arrays of values. Example: { "A1:B2": [[1, 2], [3, 4]], "D5": [["Hello"]] }.
(array of objects): [{"emailaddress": "user@example.com", "role": "writer"}, ...]. Roles: reader, commenter, writer.
(optional integer, default 5): How many rows (including header) to preview. Example: 5.
(optional boolean, default True): Send email notifications to recipients.
(string): Name of the sheet/tab (e.g., "Sheet1").
(string): The spreadsheet ID (from its URL).
(string): The spreadsheet ID (from its URL).
(array of strings): IDs of the spreadsheets (from their URLs).
(string): Source sheet/tab name (e.g., "Sheet1").
(string): Source spreadsheet ID (from its URL).
(optional integer, default 0): 0-based column index to start inserting. If omitted, defaults to 0 (inserts at the beginning).
(optional integer, default 0): 0-based row index to start inserting rows. If omitted, defaults to 0 (inserts at the beginning).
(string): The desired title for the spreadsheet. Example: "Quarterly Report Q4".
Write to spreadsheets