Returns metadata about a spreadsheet: title, sheet names, IDs, and dimensions.

Returns the structural schema of a sheet tab: column names, dropdown options, checkboxes, data types (date/number/currency), formula-protected fields, and instructional notes. Use this before write operations to understand column constraints.

Creates a new sheet tab in the spreadsheet.

Renames a sheet tab. Identify the sheet by sheet_id or old_title.

Reads cell values from a range in A1 notation (e.g. 'Sheet1!A1:D10' or 'Sheet1' for the entire tab).

Searches a sheet tab for rows whose cell value matches query and returns each match with its 1-based sheet row index (feed straight into update_row / delete_rows). Restrict to one column by 1-based column index OR by column_header name (resolved via header_row); omit both to search every column. Matches the raw unformatted value (numbers/dates by their underlying value, not displayed text). The header_row is treated as headers and excluded from matches.

Appends rows to the bottom of a sheet tab.

Inserts empty columns into a sheet tab at a position, or appends them at the right edge.

Overwrites cells in a single row, left to right, starting at start_column (default column A). Only the cells covered by values are written — cells outside that span are left untouched, so you can update specific columns without rewriting the whole row.

Permanently deletes a contiguous block of rows from a sheet tab, shifting the rows below upward. Deletes count rows (default 1) starting at the 1-based start_row. Destructive — cannot be undone via the API.