Google Apps40 toolsBrowser login (OAuth), no API keys
Google Sheets integration for AI agents
Read and write spreadsheet data
Use it from your agent
One ClawLink account serves every agent you run. Pick the guide for yours, or connect Google Sheets once and call the same tools from all of them.
Google Sheets for OpenClawInstall, pair, connect, first prompt
Google Sheets for Hermes AgentInstall, pair, connect, first prompt
Google Sheets for Grok BotInstall, pair, connect, first promptMCPClaude Code, Cursor, any MCP clientCLI login or the remote MCP serverDeeper comparison, failure modes and setup details: Google Sheets for AI agents, in depth.
Setup
Connect Google Sheets through ClawLink's hosted setup to read and write spreadsheet data, manage sheets, create formulas, and automate spreadsheet workflows.
- Auth: Browser login (OAuth), no API keys. The credential stays on the ClawLink server; your agent holds only a ClawLink key you can revoke.
- Where: the ClawLink dashboard, or ask your agent to connect it.
What your agent can do
Google Sheets exposes 40 tools through ClawLink. The 30 most used are listed here; your agent sees all of them.
| Tool | What it does | Kind |
|---|---|---|
googlesheets_add_sheet | Add a new sheet to a spreadsheet | Read |
googlesheets_aggregate_column_data | Aggregate column data by matching and computing | Read |
googlesheets_batch_get | Retrieve data from multiple cell ranges | Read |
googlesheets_clear_values | Clear cell content from a range | Read |
googlesheets_create_chart | Create a chart in a Google Sheet | Read |
googlesheets_create_google_sheet1 | Create a new Google Spreadsheet | Read |
googlesheets_create_spreadsheet_column | Create a new column in a Google Sheet | Read |
googlesheets_create_spreadsheet_row | Insert a new row into a Google Sheet | Read |
googlesheets_find_replace | Find and replace text across cells | Read |
googlesheets_format_cell | Apply text and background formatting to cells | Read |
googlesheets_get_data_validation_rules | Get data validation rules from a spreadsheet | Read |
googlesheets_get_sheet_names | List all worksheet names in a spreadsheet | Read |
googlesheets_get_spreadsheet_info | Get metadata for a Google Spreadsheet | Read |
googlesheets_lookup_spreadsheet_row | Find a row by exact cell content match | Read |
googlesheets_search_spreadsheets | Search for Google Spreadsheets by name or content | Read |
googlesheets_set_data_validation_rule | Set data validation rules or dropdowns on a range | Read |
googlesheets_spreadsheets_sheets_copy_to | Copy a sheet to another spreadsheet | Read |
googlesheets_spreadsheets_values_append | Append values to the end of a Google Sheet | Read |
googlesheets_spreadsheets_values_batch_clear | Clear values from multiple ranges at once | Read |
googlesheets_update_sheet_properties | Update sheet tab properties like name or color | Read |
googlesheets_update_spreadsheet_properties | Update spreadsheet-level properties like title or locale | Read |
googlesheets_update_values_batch | Update values in multiple ranges at once | Read |
googlesheets_upsert_rows | Upsert rows by key column, appending or updating | Read |
googlesheets_values_get | Read values from a range in a Google Sheet | Read |
googlesheets_values_update | Update values in a range of a Google Sheet | Read |
googlesheets_get_conditional_format_rules | List conditional formatting rules for each sheet (or a selected sheet) in a normalized | Read |
googlesheets_get_spreadsheet_by_data_filter | Returns the spreadsheet at the given ID, filtered by the specified data filters | Read |
googlesheets_search_developer_metadata | Search for developer metadata in a spreadsheet | Read |
googlesheets_spreadsheets_values_batch_get_by_data_filter | Return one or more ranges of values from a spreadsheet that match the specified data filters | Read |
googlesheets_append_dimension | Append new rows or columns to a sheet, increasing its size | Read |
