Google Sheets

List all spreadsheets accessible to the user. Use this to populate spreadsheet dropdowns.

List all sheets within a spreadsheet. Use this to populate sheet dropdowns after selecting a spreadsheet.

Get column headers from a sheet. Use this to populate column dropdowns for mapping.

Get metadata about a spreadsheet.

Create a new spreadsheet.

Get rows from a sheet. First row is treated as headers by default.

Append a new row to the end of a sheet. Select spreadsheet and sheet first, then map values to each column.

Update an existing row by row number or by matching a key column value.

Append a new row or update existing if key column matches.

Delete a row from a sheet.

Clear all data from a sheet (keeps headers optionally).

Get value of a specific cell.

Update a specific cell value.

Get values from a range of cells.

Update values in a range of cells.

Create a new sheet in an existing spreadsheet.

Delete a sheet from a spreadsheet.

Rename a sheet.

Copy a sheet to another spreadsheet.

Find rows matching search criteria with advanced filtering. Supports single filter (column/value/operator) or multiple filters with AND/OR logic.