#google-sheets #spreadsheets #spreadsheet #api-integration

Google Sheets

Google Sheets API integration with managed OAuth. Create spreadsheets, read and write cell values, manage sheets, append rows, create charts, and automate data operations. Use this skill when users want spreadsheet work done in Google Sheets.

Jay@hith3sh

Install

openclaw skills install @hith3sh/google-sheets-spreadsheets

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: Install	Step 2: Pair Account	Step 3: Connect Google Sheets
		App-specific connection GIF coming soon
Run the install command in OpenClaw	Sign in and approve the device	Open 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

Install the ClawLink plugin (see Install above).
Pair the plugin with clawlink_begin_pairing if it is not configured yet.
Open https://claw-link.dev/dashboard?add=google-sheets and connect Google Sheets.
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:

Direct the user to https://claw-link.dev/dashboard?add=google-sheets
After they confirm, call clawlink_list_integrations to verify
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

Tool	Description	Mode
`googlesheets_search_spreadsheets`	Search for spreadsheets by name, content, or date	Read
`googlesheets_get_spreadsheet_info`	Get spreadsheet metadata (ID, title, sheet properties)	Read
`googlesheets_get_sheet_names`	List all worksheet names in a spreadsheet	Read
`googlesheets_get_spreadsheet_by_data_filter`	Get spreadsheet filtered by data filters	Read

Reading Data

Tool	Description	Mode
`googlesheets_values_get`	Read values from a specific cell range	Read
`googlesheets_batch_get`	Retrieve data from multiple ranges in one call	Read
`googlesheets_lookup_spreadsheet_row`	Find a row by exact cell content match	Read
`googlesheets_aggregate_column_data`	Search rows by column value and perform math operations	Read
`googlesheets_spreadsheets_values_batch_get_by_data_filter`	Read ranges matching data filters	Read

Writing & Updating Data

Tool	Description	Mode
`googlesheets_values_update`	Set values in a cell range	Write
`googlesheets_update_values_batch`	Update multiple ranges in one call	Write
`googlesheets_spreadsheets_values_append`	Append new rows to a table	Write
`googlesheets_batch_update_values_by_data_filter`	Update values matching data filters	Write
`googlesheets_find_replace`	Find and replace text across a spreadsheet	Write
`googlesheets_format_cell`	Apply text and background formatting to cells	Write

Clearing Data

Tool	Description	Mode
`googlesheets_clear_values`	Clear cell content from a range (preserves formatting)	Write
`googlesheets_spreadsheets_values_batch_clear`	Clear multiple ranges at once	Write
`googlesheets_batch_clear_values_by_data_filter`	Clear ranges matching data filters	Write
`googlesheets_clear_basic_filter`	Remove the basic filter from a sheet	Write

Sheet Management

Tool	Description	Mode
`googlesheets_add_sheet`	Add a new sheet (GRID, OBJECT, or DATA_SOURCE type)	Write
`googlesheets_delete_sheet`	Delete a sheet from a spreadsheet	Write
`googlesheets_update_sheet_properties`	Rename, reposition, or change tab color of a sheet	Write
`googlesheets_update_spreadsheet_properties`	Update spreadsheet-level properties (title, locale, timezone)	Write

Row & Column Operations

Tool	Description	Mode
`googlesheets_create_spreadsheet_row`	Insert a new row at a specific index	Write
`googlesheets_create_spreadsheet_column`	Insert a new column in a spreadsheet	Write
`googlesheets_delete_dimension`	Delete rows or columns by range	Write
`googlesheets_insert_dimension`	Insert empty rows or columns at a location	Write
`googlesheets_append_dimension`	Append rows or columns to a sheet	Write
`googlesheets_update_dimension_properties`	Hide/unhide rows or columns, set row height/column width	Write
`googlesheets_auto_resize_dimensions`	Auto-fit column widths or row heights to content	Write

Smart Upsert

Tool	Description	Mode
`googlesheets_upsert_rows`	Update existing rows by key column, append new ones if not found	Write

Charts

Tool	Description	Mode
`googlesheets_create_chart`	Create a chart from a data range with configurable chart type	Write

Filtering & Validation

Tool	Description	Mode
`googlesheets_set_basic_filter`	Set or update a basic filter on a sheet	Write
`googlesheets_set_data_validation_rule`	Apply data validation rules or dropdowns to a range	Write
`googlesheets_get_conditional_format_rules`	List conditional formatting rules for a sheet	Read
`googlesheets_mutate_conditional_format_rules`	Add, update, delete, or reorder conditional format rules	Write
`googlesheets_get_data_validation_rules`	Extract data validation rules from a spreadsheet	Read

Spreadsheet Creation

Tool	Description	Mode
`googlesheets_create_google_sheet1`	Create a new spreadsheet, optionally in a specific Drive folder	Write

Copy & Transfer

Tool	Description	Mode
`googlesheets_spreadsheets_sheets_copy_to`	Copy a single sheet to another spreadsheet	Write

Metadata

Tool	Description	Mode
`googlesheets_search_developer_metadata`	Search for developer metadata in a spreadsheet	Read

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

Call clawlink_list_integrations to confirm Google Sheets is connected.
Call clawlink_list_tools --integration google-sheets to see the live catalog.
Treat the returned list as the source of truth. Do not guess or assume what tools exist.
If the user describes a capability but the exact tool is unclear, call clawlink_search_tools with a short query and integration google-sheets.
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                                   │
└─────────────────────────────────────────────────────────────┘

For unfamiliar tools, ambiguous requests, or any write action, call clawlink_describe_tool first.
Use the returned guidance, schema, whenToUse, askBefore, safeDefaults, examples, and followups to shape the call.
Prefer spreadsheet inspection and range reads before writes.
For updates, appends, clears, sheet creation or deletion, structural edits, formatting changes, or anything marked as requiring confirmation, call clawlink_preview_tool first.
Execute with clawlink_call_tool. Pass confirmation only after the preview matches the user's intent.
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 / Error	Meaning
Tool not found	The tool name does not exist in the current catalog. Verify with `clawlink_list_tools --integration google-sheets`.
Missing connection	Google Sheets is not connected. Direct the user to https://claw-link.dev/dashboard?add=google-sheets.
`SPREADSHEET_NOT_FOUND`	Spreadsheet does not exist. Check the spreadsheet_id.
`INVALID_ARGUMENT`	Invalid parameter or missing required field. Review the tool schema with `clawlink_describe_tool`.
Write rejected	User did not confirm a write action. Always confirm before executing writes.

Troubleshooting: Tools Not Visible

Check that the ClawLink plugin is installed:
bash
```
openclaw plugins list
```
If the plugin is installed but tools are missing, tell the user to send /new as a standalone message to reload the catalog.

If a fresh chat does not help, run:

bash

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

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

Troubleshooting: Invalid Tool Call

Ensure the integration slug is exactly google-sheets.
Use clawlink_describe_tool to verify parameter names and types before calling.
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

ClawLink Logo

Google Sheets

Install

Google Sheets

Setup in 3 Steps

How It Works

Install

Quick Start

Authentication

Getting Connected

Connection Management

List Connections

Verify Connection

Reconnect

Security & Permissions

Tool Reference

Spreadsheet Discovery

Reading Data

Writing & Updating Data

Clearing Data

Sheet Management

Row & Column Operations

Smart Upsert

Charts

Filtering & Validation

Spreadsheet Creation

Copy & Transfer

Metadata

Code Examples

Search for spreadsheets

Read a cell range

Update cell values

Append rows to a table

Upsert rows by key

Create a chart

Discovery Workflow

Execution Workflow

Notes

Error Handling

Troubleshooting: Tools Not Visible

Troubleshooting: Invalid Tool Call

Resources

Related Skills

Related skills