Skip to main content
Welcome to the Google Sheets integration docs. Once you connect your Google account to Reasoning Stack, your AI agents and workflows can use the following tools to create, edit, and manage spreadsheets programmatically.
Before accessing any Google Sheets tools, connect your Google account via the App Connection page. Without this, tool calls will fail due to missing authorization.

​
Google Sheets Tool Categories

​
Spreadsheet Creation & Structure

Create new spreadsheets, sheets, and manage their structure.
  • GOOGLESHEETS_CREATE_GOOGLE_SHEET1 – Create a new Google Sheet.
  • GOOGLESHEETS_ADD_SHEET – Add a new sheet to a spreadsheet.
  • GOOGLESHEETS_DELETE_SHEET – Delete a sheet from a spreadsheet.
  • GOOGLESHEETS_UPDATE_SHEET_PROPERTIES – Update properties of a sheet.
  • GOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIES – Update properties of a spreadsheet.
  • GOOGLESHEETS_SPREADSHEETS_SHEETS_COPY_TO – Copy a sheet to another spreadsheet.
  • GOOGLESHEETS_FIND_WORKSHEET_BY_TITLE – Find a worksheet by its title.
  • GOOGLESHEETS_GET_SHEET_NAMES – Get the names of all sheets in a spreadsheet.

​
Rows, Columns & Dimensions

Manage rows, columns, and dimensions in your sheets.
  • GOOGLESHEETS_CREATE_SPREADSHEET_ROW – Create a new row in a spreadsheet.
  • GOOGLESHEETS_CREATE_SPREADSHEET_COLUMN – Create a new column in a spreadsheet.
  • GOOGLESHEETS_INSERT_DIMENSION – Insert a row or column.
  • GOOGLESHEETS_APPEND_DIMENSION – Append a row or column.
  • GOOGLESHEETS_DELETE_DIMENSION – Delete a row or column.

​
Values & Data Manipulation

Read, write, and manipulate cell values.
  • GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND – Append values to a sheet.
  • GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER – Batch update values using a data filter.
  • GOOGLESHEETS_CLEAR_VALUES – Clear values from a range.
  • GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR – Batch clear values from multiple ranges.
  • GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR_BY_DATA_FILTER – Batch clear values using a data filter.
  • GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_GET_BY_DATA_FILTER – Batch get values using a data filter.
  • GOOGLESHEETS_BATCH_GET – Batch get values from a spreadsheet.
  • GOOGLESHEETS_BATCH_UPDATE – Batch update spreadsheet data.
  • GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW – Lookup a row in a spreadsheet.

​
Filters & Metadata

Work with filters and metadata for advanced data management.
  • GOOGLESHEETS_SET_BASIC_FILTER – Set a basic filter on a sheet.
  • GOOGLESHEETS_CLEAR_BASIC_FILTER – Clear a basic filter from a sheet.
  • GOOGLESHEETS_SEARCH_DEVELOPER_METADATA – Search for developer metadata in a spreadsheet.

​
Formatting

Format cells and aggregate data.
  • GOOGLESHEETS_FORMAT_CELL – Format a cell in a spreadsheet.
  • GOOGLESHEETS_AGGREGATE_COLUMN_DATA – Aggregate data in a column.
Retrieve and search for spreadsheets and their data.
  • GOOGLESHEETS_GET_SPREADSHEET_INFO – Get information about a spreadsheet.
  • GOOGLESHEETS_GET_SPREADSHEET_BY_DATA_FILTER – Retrieve a spreadsheet using a data filter.
  • GOOGLESHEETS_SEARCH_SPREADSHEETS – Search for spreadsheets.
  • GOOGLESHEETS_SHEET_FROM_JSON – Create a sheet from JSON data.

​
Usage Notes

  • Handle spreadsheet, sheet, and range IDs carefully to avoid errors.
  • Use batch and filter tools for efficient data processing.
  • Combine formatting, aggregation, and search tools for advanced spreadsheet automation.
Automate reporting, data analysis, and spreadsheet management by combining multiple Google Sheets tools in your workflows.