# Connect Google Sheets to your AI agent

> Yes — ClawLink is a hosted Google Sheets MCP server. 40 tools your agent can call from chat, with one-click hosted OAuth and nothing to run locally.

Web version: https://claw-link.dev/hub/google-sheets

ClawLink hosts a managed Google Sheets MCP server that exposes 40 tools to your AI agent. You connect Google Sheets in one click, and your agent can read, create, and update Google Sheets data from chat without you building or running a local MCP server.

## Quick facts

- 40 tools callable from chat
- One-click hosted OAuth
- Works with OpenClaw, Hermes, Claude Code, Cursor, Codex, and any MCP client
- No local server or config files

## Overview

The usual path is: build auth, handle token refresh, wire up the tools. With ClawLink you connect Google Sheets once and start using the real actions from the agent.

## Setup

Google Sheets uses OAuth. You connect it in the browser: click Connect, sign in, approve. ClawLink stores the token and refreshes it on its own. You never touch a key or wire up a redirect URL.

Authentication: hosted OAuth

## What you can do

- **Read and write from chat** — Query, create, and update Google Sheets items the moment a question comes up. No export step.
- **Go from insight to action** — The agent reads Google Sheets, sums up what matters, and helps you decide the next step.
- **Keep analysis close to the work** — Turning Google Sheets data into a follow-up task happens inside one flow.

## Google Sheets tools

40 Google Sheets tools, ready the moment you connect.

- `googlesheets_add_sheet` — Add a new sheet to a spreadsheet
- `googlesheets_aggregate_column_data` — Aggregate column data by matching and computing
- `googlesheets_batch_get` — Retrieve data from multiple cell ranges
- `googlesheets_clear_values` — Clear cell content from a range
- `googlesheets_create_chart` — Create a chart in a Google Sheet
- `googlesheets_create_google_sheet1` — Create a new Google Spreadsheet
- `googlesheets_create_spreadsheet_column` — Create a new column in a Google Sheet
- `googlesheets_create_spreadsheet_row` — Insert a new row into a Google Sheet
- `googlesheets_find_replace` — Find and replace text across cells
- `googlesheets_format_cell` — Apply text and background formatting to cells
- `googlesheets_get_data_validation_rules` — Get data validation rules from a spreadsheet
- `googlesheets_get_sheet_names` — List all worksheet names in a spreadsheet
- `googlesheets_get_spreadsheet_info` — Get metadata for a Google Spreadsheet
- `googlesheets_lookup_spreadsheet_row` — Find a row by exact cell content match
- `googlesheets_search_spreadsheets` — Search for Google Spreadsheets by name or content
- `googlesheets_set_data_validation_rule` — Set data validation rules or dropdowns on a range
- `googlesheets_spreadsheets_sheets_copy_to` — Copy a sheet to another spreadsheet
- `googlesheets_spreadsheets_values_append` — Append values to the end of a Google Sheet
- `googlesheets_spreadsheets_values_batch_clear` — Clear values from multiple ranges at once
- `googlesheets_update_sheet_properties` — Update sheet tab properties like name or color
- `googlesheets_update_spreadsheet_properties` — Update spreadsheet-level properties like title or locale
- `googlesheets_update_values_batch` — Update values in multiple ranges at once
- `googlesheets_upsert_rows` — Upsert rows by key column, appending or updating
- `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_get_conditional_format_rules` — List conditional formatting rules for each sheet (or a selected sheet) in a normalized
- `googlesheets_get_spreadsheet_by_data_filter` — Returns the spreadsheet at the given ID, filtered by the specified data filters
- `googlesheets_search_developer_metadata` — Search for developer metadata in a spreadsheet
- `googlesheets_spreadsheets_values_batch_get_by_data_filter` — Return one or more ranges of values from a spreadsheet that match the specified data filters
- `googlesheets_append_dimension` — Append new rows or columns to a sheet, increasing its size

## Example prompts

- **Googlesheets add sheet:** Use Google Sheets to googlesheets add sheet and walk me through it.
- **Googlesheets aggregate column data:** Use Google Sheets to googlesheets aggregate column data and walk me through it.
- **Googlesheets batch get:** Use Google Sheets to googlesheets batch get and walk me through it.
- **Googlesheets clear values:** Use Google Sheets to googlesheets clear values and walk me through it.

## ClawLink vs. building it yourself

| | Manual | ClawLink |
|---|---|---|
| Connection | Build it yourself. You register a developer app with Google Sheets, set up redirect URLs, handle the consent screen, store and refresh access tokens, and redo the wiring when scopes change. | Hosted hosted OAuth. Connect once in the browser. ClawLink owns the lifecycle. |
| Maintenance | Token refresh, permission debugging, env config, every edge case. All yours. | ClawLink handles the plumbing. You focus on the workflow. |
| Time to first call | Days to weeks. Auth, storage, tool wiring, testing. Then the agent can act. | About two minutes from sign-up to the agent calling Google Sheets. |

## FAQ

### How do I connect Google Sheets to my AI agent?

Install ClawLink, open the dashboard, click Connect next to Google Sheets, and finish the hosted OAuth flow. Your agent can call Google Sheets from the next message. Two minutes, total.

### Is there a Google Sheets MCP server I can use?

Yes. ClawLink exposes Google Sheets as 40 tools your agent calls through a hosted MCP-compatible runtime. You don't run a local server or edit a config file. The tools are there the moment you connect.

### Do I need Google Sheets API credentials?

No separate API key. You sign in to Google Sheets through the normal OAuth flow and ClawLink handles the token after that.

### How much does it cost?

Your first integration is free, plus a 7-day trial of the full catalog. Paid plans unlock the rest of the library.

### Can I set this up from the terminal instead of the dashboard?

Yes. Run npx -y @useclawlink/cli login, then npx -y @useclawlink/cli connect google-sheets. The first opens a browser to sign in to ClawLink. The second opens a browser to authorize Google Sheets. No API keys to create. Works with OpenClaw, Hermes, Claude Code, Cursor, Codex, and any agent that runs shell commands.