data
(array of arrays): 2D array of values to write. Example: [[1, 2, 3], ["a", "b", "c"]].
How to use it
data is exposed by the MCP Google Sheets MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the data 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.
(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).
Navigate tabs
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