Googlesheets
Overview
SLUG: GOOGLESHEETS
Description
Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps
Authentication Details
OAuth2
Connecting to Googlesheets
Create an auth config
Use the dashboard to create an auth config for the Googlesheets toolkit. This allows you to connect multiple Googlesheets accounts to Composio for agents to use.
Create and Get auth config ID
Click “Create Googlesheets Auth Config”. After creation, copy the displayed ID starting with ac_
. This is your auth config ID. This is not a sensitive ID — you can save it in environment variables or a database.
This ID will be used to create connections to the toolkit for a given user.
Connect Your Account
Using OAuth2
Tools
Executing tools
To prototype you can execute some tools to see the responses and working on the Googlesheets toolkit’s playground
OpenAI (Python)
Anthropic (TypeScript)
Google (Python)
Vercel (TypeScript)
Tool List
GOOGLESHEETS_ADD_SHEET
Tool Name: Add Sheet to Spreadsheet
Description
Action Parameters
Action Response
GOOGLESHEETS_APPEND_DIMENSION
Tool Name: Append Dimension
Description
Action Parameters
Action Response
GOOGLESHEETS_BATCH_UPDATE
Tool Name: Batch update spreadsheet
Description
Action Parameters
Action Response
GOOGLESHEETS_CLEAR_BASIC_FILTER
Tool Name: Clear Basic Filter
Description
Action Parameters
Action Response
GOOGLESHEETS_DELETE_DIMENSION
Tool Name: Delete Dimension (Rows/Columns)
Description
Action Parameters
Action Response
GOOGLESHEETS_DELETE_SHEET
Tool Name: Delete Sheet
Description
Action Parameters
Action Response
GOOGLESHEETS_GET_SPREADSHEET_BY_DATA_FILTER
Tool Name: Get Spreadsheet by Data Filter
Description
Action Parameters
Action Response
GOOGLESHEETS_GET_SPREADSHEET_INFO
Tool Name: Get spreadsheet info
Description
Action Parameters
Action Response
GOOGLESHEETS_INSERT_DIMENSION
Tool Name: Insert Dimension in Google Sheet
Description
Action Parameters
Action Response
GOOGLESHEETS_SEARCH_DEVELOPER_METADATA
Tool Name: Search Developer Metadata
Description
Action Parameters
Action Response
GOOGLESHEETS_SET_BASIC_FILTER
Tool Name: Set Basic Filter
Description
Action Parameters
Action Response
GOOGLESHEETS_SPREADSHEETS_SHEETS_COPY_TO
Tool Name: Copy Sheet to Another Spreadsheet
Description
Action Parameters
Action Response
GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND
Tool Name: Append Values to Spreadsheet
Description
Action Parameters
Action Response
GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR
Tool Name: Batch Clear Spreadsheet Values
Description
Action Parameters
Action Response
GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR_BY_DATA_FILTER
Tool Name: Batch Clear Values By Data Filter
Description
Action Parameters
Action Response
GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_GET_BY_DATA_FILTER
Tool Name: Batch Get Spreadsheet Values by Data Filter
Description
Action Parameters
Action Response
GOOGLESHEETS_UPDATE_SHEET_PROPERTIES
Tool Name: Update Sheet Properties
Description
Action Parameters
Action Response
GOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIES
Tool Name: Update Spreadsheet Properties
Description
Action Parameters
Action Response
GOOGLESHEETS_AGGREGATE_COLUMN_DATA
Tool Name: Aggregate Column Data
Description
Action Parameters
Action Response
GOOGLESHEETS_BATCH_GET
Tool Name: Batch get spreadsheet
Description
Action Parameters
Action Response
GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER
Tool Name: Batch Update Values by Data Filter
Description
Action Parameters
Action Response
GOOGLESHEETS_CLEAR_VALUES
Tool Name: Clear spreadsheet values
Description
Action Parameters
Action Response
GOOGLESHEETS_CREATE_CHART
Tool Name: Create Chart in Google Sheets
Description
Action Parameters
Action Response
GOOGLESHEETS_CREATE_GOOGLE_SHEET1
Tool Name: Create a Google Sheet
Description
Action Parameters
Action Response
GOOGLESHEETS_CREATE_SPREADSHEET_COLUMN
Tool Name: Create spreadsheet column
Description
Action Parameters
Action Response
GOOGLESHEETS_CREATE_SPREADSHEET_ROW
Tool Name: Create spreadsheet row
Description
Action Parameters
Action Response
GOOGLESHEETS_EXECUTE_SQL
Tool Name: Execute SQL on Spreadsheet
Description
Action Parameters
Action Response
GOOGLESHEETS_FIND_WORKSHEET_BY_TITLE
Tool Name: Find worksheet by title
Description
Action Parameters
Action Response
GOOGLESHEETS_FORMAT_CELL
Tool Name: Format cell
Description
Action Parameters
Action Response
GOOGLESHEETS_GET_SHEET_NAMES
Tool Name: Get sheet names
Description
Action Parameters
Action Response
GOOGLESHEETS_GET_TABLE_SCHEMA
Tool Name: Get Table Schema
Description
Action Parameters
Action Response
GOOGLESHEETS_LIST_TABLES
Tool Name: List Tables in Spreadsheet
Description
Action Parameters
Action Response
GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW
Tool Name: Look up spreadsheet row
Description
Action Parameters
Action Response
GOOGLESHEETS_QUERY_TABLE
Tool Name: Query Spreadsheet Table
Description
Action Parameters
Action Response
GOOGLESHEETS_SEARCH_SPREADSHEETS
Tool Name: Search Spreadsheets
Description
Action Parameters
Action Response
GOOGLESHEETS_SHEET_FROM_JSON
Tool Name: Create sheet from JSON
Description
Action Parameters
Action Response