MCP Google Sheets

add_rows

batch_update

batch_update_cells

copy_sheet

count

(integer): Number of empty rows to insert.

create_sheet

create_spreadsheet

data

(array of arrays): 2D array of values to write. Example: [[1, 2, 3], ["a", "b", "c"]].

dst_sheet

(string): Desired sheet/tab name in the destination spreadsheet.

dst_spreadsheet

(string): Destination spreadsheet ID (from its URL).

find_in_spreadsheet

folder_id

(optional string): Google Drive folder ID to search in. Get from its URL. If omitted, uses the configured default folder or searches 'My Drive'.

get_multiple_sheet_data

get_multiple_spreadsheet_summary

get_sheet_data

Read from spreadsheets

get_sheet_formulas

include_grid_data

(optional boolean, default False): If True, returns full grid data including formatting and metadata (much larger). If False, returns values only (more efficient).

list_folders

list_sheets

Navigate tabs

list_spreadsheets

Find spreadsheets

queries

(array of objects): Each object needs spreadsheetid, sheet, and range. Example: [{"spreadsheetid": "abc", "sheet": "Sheet1", "range": "A1:B2"}, ...].

range

(optional string): A1 notation (e.g., 'A1:C10', 'Sheet1!B2:D'). If omitted, reads the whole sheet/tab specified by sheet.

ranges

(object): Dictionary mapping range strings (A1 notation) to 2D arrays of values. Example: { "A1:B2": [[1, 2], [3, 4]], "D5": [["Hello"]] }.

recipients

(array of objects): [{"emailaddress": "user@example.com", "role": "writer"}, ...]. Roles: reader, commenter, writer.

rename_sheet

rows_to_fetch

(optional integer, default 5): How many rows (including header) to preview. Example: 5.

search_spreadsheets

send_notification

(optional boolean, default True): Send email notifications to recipients.

share_spreadsheet

sheet

(string): Name of the sheet/tab (e.g., "Sheet1").

spreadsheet

(string): The spreadsheet ID (from its URL).

spreadsheet_id

(string): The spreadsheet ID (from its URL).

spreadsheet_ids

(array of strings): IDs of the spreadsheets (from their URLs).

src_sheet

(string): Source sheet/tab name (e.g., "Sheet1").

src_spreadsheet

(string): Source spreadsheet ID (from its URL).

start_column

(optional integer, default 0): 0-based column index to start inserting. If omitted, defaults to 0 (inserts at the beginning).

start_row

(optional integer, default 0): 0-based row index to start inserting rows. If omitted, defaults to 0 (inserts at the beginning).

title

(string): The desired title for the spreadsheet. Example: "Quarterly Report Q4".

update_cells

Write to spreadsheets