spreadsheet

(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).

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).

(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