Google Sheets#

Access Google Sheets via the Google Sheets API with managed OAuth authentication. Create spreadsheets, read and write cell values, manage sheets, append rows, create charts, and automate data operations.

This skill uses ClawLink for hosted connection flows and credentials so you do not need to configure Google Sheets API access yourself.

Setup in 3 Steps#

Step 1: InstallStep 2: Pair AccountStep 3: Connect Google Sheets_App-specific connection GIF coming soon_Run the install command in OpenClawSign in and approve the deviceOpen the dashboard and connect Google Sheets

How It Works#

text

┌─────────────────┐     ┌──────────────┐     ┌──────────────────┐
│   OpenClaw      │────▶│   ClawLink   │────▶│  Google Sheets   │
│   (User Chat)   │     │   (OAuth)    │     │   (Sheets API)   │
└─────────────────┘     └──────────────┘     └──────────────────┘
         │                       │                       │
         │  1. Install Plugin    │                       │
         │  2. Pair Device       │                       │
         │  3. Connect Sheets    │                       │
         │                       │  4. Secure Token       │
         │                       │  5. Proxy Requests    │
         │                       │                       │
         ▼                       ▼                       ▼
   ┌──────────┐           ┌──────────┐           ┌──────────┐
   │  SKILL   │           │ Dashboard│           │  Google  │
   │  File    │           │ Auth     │           │  Sheets  │
   └──────────┘           └──────────┘           └──────────┘

Install#

Install the verified ClawLink plugin from ClawHub. After the user confirms, complete the full setup so ClawLink tools are visible in the next OpenClaw chat.

bash

openclaw plugins install clawhub:clawlink-plugin
openclaw config set tools.alsoAllow '["clawlink-plugin"]' --strict-json
openclaw gateway restart

Then tell the user: "OpenClaw has been restarted. Send /new as a standalone message to start a fresh chat, then ask for Google Sheets again."

Quick Start#

bash

# Search for spreadsheets
clawlink_call_tool --tool "googlesheets_search_spreadsheets" --params '{"query": "budget"}'

# Get spreadsheet info
clawlink_call_tool --tool "googlesheets_get_spreadsheet_info" --params '{"spreadsheet_id": "YOUR_SPREADSHEET_ID"}'

# Get sheet names
clawlink_call_tool --tool "googlesheets_get_sheet_names" --params '{"spreadsheet_id": "YOUR_SPREADSHEET_ID"}'

Authentication#

All Google Sheets tool calls are authenticated automatically by ClawLink using the user's connected Google account.

No API key is required in chat. ClawLink stores the OAuth token securely and injects it into every Google Sheets API request on the user's behalf.

Getting Connected#

1. Install the ClawLink plugin (see Install above).
2. Pair the plugin with clawlink_begin_pairing if it is not configured yet.
3. Open https://claw-link.dev/dashboard?add=google-sheets and connect Google Sheets.
4. Call clawlink_list_integrations to verify the connection is active.

Connection Management#

List Connections#

bash

clawlink_list_integrations

Response: Returns all connected integrations. Look for google-sheets in the list.

Verify Connection#

bash

clawlink_list_tools --integration google-sheets

Response: Returns the live tool catalog for Google Sheets.

Reconnect#

If Google Sheets tools are missing or the connection shows an error:

1. Direct the user to https://claw-link.dev/dashboard?add=google-sheets
2. After they confirm, call clawlink_list_integrations to verify
3. Then call clawlink_list_tools --integration google-sheets

Security & Permissions#

• Access is scoped to spreadsheets within the connected Google account's Drive.
• All write operations require explicit user confirmation. Before executing any create, update, or delete call, confirm the target resource and intended effect with the user.
• Destructive actions (delete sheet, clear values, delete dimension) are marked as high-impact and must be confirmed.
• Batch operations affect multiple cells and should be previewed before execution.

Tool Reference#

Spreadsheet Discovery#

ToolDescriptionModegooglesheets_search_spreadsheetsSearch for spreadsheets by name, content, or dateReadgooglesheets_get_spreadsheet_infoGet spreadsheet metadata (ID, title, sheet properties)Readgooglesheets_get_sheet_namesList all worksheet names in a spreadsheetReadgooglesheets_get_spreadsheet_by_data_filterGet spreadsheet filtered by data filtersRead

Reading Data#

ToolDescriptionModegooglesheets_values_getRead values from a specific cell rangeReadgooglesheets_batch_getRetrieve data from multiple ranges in one callReadgooglesheets_lookup_spreadsheet_rowFind a row by exact cell content matchReadgooglesheets_aggregate_column_dataSearch rows by column value and perform math operationsReadgooglesheets_spreadsheets_values_batch_get_by_data_filterRead ranges matching data filtersRead

Writing & Updating Data#

ToolDescriptionModegooglesheets_values_updateSet values in a cell rangeWritegooglesheets_update_values_batchUpdate multiple ranges in one callWritegooglesheets_spreadsheets_values_appendAppend new rows to a tableWritegooglesheets_batch_update_values_by_data_filterUpdate values matching data filtersWritegooglesheets_find_replaceFind and replace text across a spreadsheetWritegooglesheets_format_cellApply text and background formatting to cellsWrite

Clearing Data#

ToolDescriptionModegooglesheets_clear_valuesClear cell content from a range (preserves formatting)Writegooglesheets_spreadsheets_values_batch_clearClear multiple ranges at onceWritegooglesheets_batch_clear_values_by_data_filterClear ranges matching data filtersWritegooglesheets_clear_basic_filterRemove the basic filter from a sheetWrite

Sheet Management#

ToolDescriptionModegooglesheets_add_sheetAdd a new sheet (GRID, OBJECT, or DATA_SOURCE type)Writegooglesheets_delete_sheetDelete a sheet from a spreadsheetWritegooglesheets_update_sheet_propertiesRename, reposition, or change tab color of a sheetWritegooglesheets_update_spreadsheet_propertiesUpdate spreadsheet-level properties (title, locale, timezone)Write

Row & Column Operations#

ToolDescriptionModegooglesheets_create_spreadsheet_rowInsert a new row at a specific indexWritegooglesheets_create_spreadsheet_columnInsert a new column in a spreadsheetWritegooglesheets_delete_dimensionDelete rows or columns by rangeWritegooglesheets_insert_dimensionInsert empty rows or columns at a locationWritegooglesheets_append_dimensionAppend rows or columns to a sheetWritegooglesheets_update_dimension_propertiesHide/unhide rows or columns, set row height/column widthWritegooglesheets_auto_resize_dimensionsAuto-fit column widths or row heights to contentWrite

Smart Upsert#

ToolDescriptionModegooglesheets_upsert_rowsUpdate existing rows by key column, append new ones if not foundWrite

Charts#

ToolDescriptionModegooglesheets_create_chartCreate a chart from a data range with configurable chart typeWrite

Filtering & Validation#

ToolDescriptionModegooglesheets_set_basic_filterSet or update a basic filter on a sheetWritegooglesheets_set_data_validation_ruleApply data validation rules or dropdowns to a rangeWritegooglesheets_get_conditional_format_rulesList conditional formatting rules for a sheetReadgooglesheets_mutate_conditional_format_rulesAdd, update, delete, or reorder conditional format rulesWritegooglesheets_get_data_validation_rulesExtract data validation rules from a spreadsheetRead

Spreadsheet Creation#

ToolDescriptionModegooglesheets_create_google_sheet1Create a new spreadsheet, optionally in a specific Drive folderWrite

Copy & Transfer#

ToolDescriptionModegooglesheets_spreadsheets_sheets_copy_toCopy a single sheet to another spreadsheetWrite

Metadata#

ToolDescriptionModegooglesheets_search_developer_metadataSearch for developer metadata in a spreadsheetRead

Code Examples#

Search for spreadsheets#

bash

clawlink_call_tool --tool "googlesheets_search_spreadsheets" \
  --params '{
    "query": "budget tracker"
  }'

Read a cell range#

bash

clawlink_call_tool --tool "googlesheets_values_get" \
  --params '{
    "spreadsheet_id": "YOUR_SPREADSHEET_ID",
    "range": "Sheet1!A1:C10"
  }'

Update cell values#

bash

clawlink_call_tool --tool "googlesheets_values_update" \
  --params '{
    "spreadsheet_id": "YOUR_SPREADSHEET_ID",
    "range": "Sheet1!A1:B2",
    "values": [["Product", "Revenue"], ["Widget", 1500]]
  }'

Append rows to a table#

bash

clawlink_call_tool --tool "googlesheets_spreadsheets_values_append" \
  --params '{
    "spreadsheet_id": "YOUR_SPREADSHEET_ID",
    "range": "Sheet1!A:C",
    "values": [["New Item", "Description", 100]]
  }'

Upsert rows by key#

bash

clawlink_call_tool --tool "googlesheets_upsert_rows" \
  --params '{
    "spreadsheet_id": "YOUR_SPREADSHEET_ID",
    "sheet": "Sheet1",
    "key_column": "Email",
    "headers": ["Email", "Phone", "Status"],
    "data": [["john@example.com", "555-0101", "Active"]]
  }'

Create a chart#

bash

clawlink_call_tool --tool "googlesheets_create_chart" \
  --params '{
    "spreadsheet_id": "YOUR_SPREADSHEET_ID",
    "sheet_id": 0,
    "chart_type": "BAR",
    "data_range": "A1:B5",
    "title": "Monthly Revenue"
  }'

Discovery Workflow#

1. Call clawlink_list_integrations to confirm Google Sheets is connected.
2. Call clawlink_list_tools --integration google-sheets to see the live catalog.
3. Treat the returned list as the source of truth. Do not guess or assume what tools exist.
4. If the user describes a capability but the exact tool is unclear, call clawlink_search_tools with a short query and integration google-sheets.
5. If no Google Sheets tools appear, direct the user to https://claw-link.dev/dashboard?add=google-sheets.

Execution Workflow#

text

┌─────────────────────────────────────────────────────────────┐
│  READ OPERATIONS (Safe)                                     │
│  search → get → read → call                                 │
│                                                             │
│  Example: List sheets → Read range → Show results          │
└─────────────────────────────────────────────────────────────┘
                              │
                              ▼
┌─────────────────────────────────────────────────────────────┐
│  WRITE OPERATIONS (Require Confirmation)                    │
│  describe → preview → confirm → call                        │
│                                                             │
│  Example: Describe tool → Preview changes → User approves    │
│           → Execute update                                   │
└─────────────────────────────────────────────────────────────┘

1. For unfamiliar tools, ambiguous requests, or any write action, call clawlink_describe_tool first.
2. Use the returned guidance, schema, whenToUse, askBefore, safeDefaults, examples, and followups to shape the call.
3. Prefer spreadsheet inspection and range reads before writes.
4. For updates, appends, clears, sheet creation or deletion, structural edits, formatting changes, or anything marked as requiring confirmation, call clawlink_preview_tool first.
5. Execute with clawlink_call_tool. Pass confirmation only after the preview matches the user's intent.
6. If the tool call fails, report the real error. Do not invent results or restate the failure as a missing capability unless the live catalog supports that conclusion.

Notes#

• Spreadsheet IDs are the long ID string in the spreadsheet URL.
• Sheet IDs can be numeric (for existing sheets) or referenced by name.
• Use null in value arrays to skip updating specific cells.
• Blank cells should use "" (empty string).
• Range addresses use A1 notation (e.g., Sheet1!A1:C10).
• upsert_rows auto-adds missing columns and performs partial column updates.
• Sheet names must be unique within a spreadsheet.
• find_replace is useful for fixing formula errors or bulk text updates.
• Avoid creating sheets in parallel — the index field can cause conflicts.

Error Handling#

Status / ErrorMeaningTool not foundThe tool name does not exist in the current catalog. Verify with clawlink_list_tools --integration google-sheets.Missing connectionGoogle Sheets is not connected. Direct the user to https://claw-link.dev/dashboard?add=google-sheets.SPREADSHEET_NOT_FOUNDSpreadsheet does not exist. Check the spreadsheet_id.INVALID_ARGUMENTInvalid parameter or missing required field. Review the tool schema with clawlink_describe_tool.Write rejectedUser did not confirm a write action. Always confirm before executing writes.

Troubleshooting: Tools Not Visible#

1. Check that the ClawLink plugin is installed: bash

   openclaw plugins list
   
   

2. If the plugin is installed but tools are missing, tell the user to send /new as a standalone message to reload the catalog.

3. If a fresh chat does not help, run: bash

   openclaw config set tools.alsoAllow '["clawlink-plugin"]' --strict-json
   openclaw gateway restart
   
   

4. After restart, tell the user to send /new again and retry.

Troubleshooting: Invalid Tool Call#

1. Ensure the integration slug is exactly google-sheets.
2. Use clawlink_describe_tool to verify parameter names and types before calling.
3. For write operations, always call clawlink_preview_tool first.

Resources#

• Google Sheets API Overview
• Values Resource
• Spreadsheets Resource
• ClawLink: https://claw-link.dev/?utm_source=clawhub&utm_medium=referral&utm_content=google-sheets-spreadsheets
• ClawLink Docs: https://docs.claw-link.dev/openclaw
• ClawLink Verification: https://claw-link.dev/verify

Related Skills#

• Microsoft Excel — For Excel workbook operations via Microsoft Graph
• Google Drive — For file management and Drive-level operations

---

Powered by ClawLink — an integration hub for OpenClaw