googlesheets

name	googlesheets
description	Interact with Google Sheets via Composio. Pre-authenticated — execute actions directly without OAuth. CRITICAL: Always use COMPOSIO_GOOGLEDRIVE_ACCOUNT_ID (not the sheets-native account).

Google Sheets Skill

CRITICAL: Account ID

Always use COMPOSIO_GOOGLEDRIVE_ACCOUNT_ID for ALL Google Sheets actions. The sheets-native account has a broken token. This is handled automatically by composio_action.

Core actions (most common)

Action	What it does
GOOGLESHEETS_CREATE_GOOGLE_SHEET1	Create a new spreadsheet (title)
GOOGLESHEETS_BATCH_GET	Read ranges (spreadsheet_id, ranges as list)
GOOGLESHEETS_BATCH_UPDATE	Write to ranges
GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND	Append rows
GOOGLESHEETS_CREATE_SPREADSHEET_ROW	Insert a row
GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW	Find a row
GOOGLESHEETS_UPSERT_ROWS	Insert or update rows
GOOGLESHEETS_CLEAR_VALUES	Clear a range
GOOGLESHEETS_ADD_SHEET	Add a new tab
GOOGLESHEETS_GET_SHEET_NAMES	List all tabs
GOOGLESHEETS_FORMAT_CELL	Format cells
GOOGLESHEETS_CREATE_CHART	Create a chart
GOOGLESHEETS_FIND_REPLACE	Find & replace text
GOOGLESHEETS_EXECUTE_SQL	SQL-like query on data
GOOGLESHEETS_GET_SPREADSHEET_INFO	Get spreadsheet metadata

More actions (discover on demand)

Use composio_get_schema("GOOGLESHEETS_<ACTION>") to get parameters for any action.

Additional actions available: SEARCH_SPREADSHEETS, DELETE_SHEET, FIND_WORKSHEET_BY_TITLE, UPDATE_SHEET_PROPERTIES, VALUES_GET, VALUES_UPDATE, UPDATE_VALUES_BATCH, CREATE_SPREADSHEET_COLUMN, SHEET_FROM_JSON, AGGREGATE_COLUMN_DATA, QUERY_TABLE, LIST_TABLES, GET_TABLE_SCHEMA, SET_BASIC_FILTER, CLEAR_BASIC_FILTER, SET_DATA_VALIDATION_RULE, AUTO_RESIZE_DIMENSIONS, INSERT_DIMENSION, DELETE_DIMENSION, UPDATE_DIMENSION_PROPERTIES, APPEND_DIMENSION, GET_CONDITIONAL_FORMAT_RULES, MUTATE_CONDITIONAL_FORMAT_RULES, SEARCH_DEVELOPER_METADATA, UPDATE_SPREADSHEET_PROPERTIES, SPREADSHEETS_SHEETS_COPY_TO, GET_BATCH_VALUES, BATCH_CLEAR_VALUES_BY_DATA_FILTER, BATCH_UPDATE_VALUES_BY_DATA_FILTER, SPREADSHEETS_VALUES_BATCH_CLEAR, SPREADSHEETS_VALUES_BATCH_GET_BY_DATA_FILTER, GET_SPREADSHEET_BY_DATA_FILTER, GET_DATA_VALIDATION_RULES

(All prefixed with GOOGLESHEETS_)

Key rules

• Finding spreadsheet_id: Use GOOGLEDRIVE_LIST_FILES with query="mimeType='application/vnd.google-apps.spreadsheet'" — or extract from URL
• ranges must be a list: ["Sheet1!A1:Z100"] — NOT a string
• Get a real spreadsheet_id before calling read/write actions
• To discover parameters: composio_get_schema("GOOGLESHEETS_BATCH_GET")