clawlink-hq Google Sheets
Use Google Sheets from your AI agent through ClawLink — browser login, no API key to paste, no config to edit. Connect Google Sheets once and the agent can read and act on it. Works in any agent that can run shell commands (Claude Code, Cursor, Codex, Cline, and more).
Setup
Run these once — the agent can run them for you:
npx @useclawlink/cli login # opens browser → approve (mints + stores a key)
npx @useclawlink/cli connect google-sheets # opens browser → authorize Google Sheets
No API key to create or paste — login stores the credential at ~/.clawlink/credentials.json.
Using Google Sheets
npx @useclawlink/cli actions google-sheets "<what you want to do>" # find an action
npx @useclawlink/cli describe google-sheets <action-id> # see its inputs (before writes)
npx @useclawlink/cli run google-sheets <action-id> --input '<json>' # execute
Reads first; confirm with the user before any write.
Available actions
| Action | Description |
|---|---|
googlesheets_create_google_sheet1 |
Create a new Google Spreadsheet |
googlesheets_get_spreadsheet_info |
Get metadata for a Google Spreadsheet |
googlesheets_get_sheet_names |
List all worksheet names in a spreadsheet |
googlesheets_values_get |
Read values from a range in a Google Sheet |
googlesheets_values_update |
Update values in a range of a Google Sheet |
googlesheets_spreadsheets_values_append |
Append values to the end of a Google Sheet |
googlesheets_update_values_batch |
Update values in multiple ranges at once |
googlesheets_batch_get |
Retrieve data from multiple cell ranges |
googlesheets_clear_values |
Clear cell content from a range |
googlesheets_spreadsheets_values_batch_clear |
Clear values from multiple ranges at once |
googlesheets_create_spreadsheet_row |
Insert a new row into a Google Sheet |
googlesheets_create_spreadsheet_column |
Create a new column in a Google Sheet |
googlesheets_add_sheet |
Add a new sheet to a spreadsheet |
googlesheets_delete_sheet |
Delete a sheet from a spreadsheet |
googlesheets_delete_dimension |
Delete rows or columns from a sheet |
googlesheets_lookup_spreadsheet_row |
Find a row by exact cell content match |
googlesheets_upsert_rows |
Upsert rows by key column, appending or updating |
googlesheets_search_spreadsheets |
Search for Google Spreadsheets by name or content |
googlesheets_find_replace |
Find and replace text across cells |
googlesheets_format_cell |
Apply text and background formatting to cells |
googlesheets_set_data_validation_rule |
Set data validation rules or dropdowns on a range |
googlesheets_get_data_validation_rules |
Get data validation rules from a spreadsheet |
googlesheets_create_chart |
Create a chart in a Google Sheet |
googlesheets_spreadsheets_sheets_copy_to |
Copy a sheet to another spreadsheet |
googlesheets_aggregate_column_data |
Aggregate column data by matching and computing |
googlesheets_update_sheet_properties |
Update sheet tab properties like name or color |
googlesheets_update_spreadsheet_properties |
Update spreadsheet-level properties like title or locale |
Notes
- No API key for Google Sheets itself — ClawLink holds the OAuth token; the agent only holds your ClawLink credential.
- Not connected yet, or access expired? Re-run
npx @useclawlink/cli connect google-sheets. - The action list above is a snapshot;
npx @useclawlink/cli actions google-sheetsis always current.
Resources
- ClawLink: https://claw-link.dev
- Docs: https://docs.claw-link.dev
- CLI: https://www.npmjs.com/package/@useclawlink/cli
Powered by ClawLink — connect 90+ apps to any AI agent.