# How to connect Google Sheets to Grok Bot (no API keys) > Connect Google Sheets to Grok Bot with ClawLink in one click — 40 tools your AI agent can call from chat via hosted OAuth. No API keys, no manual setup. Web version: https://claw-link.dev/grokbot/google-sheets Grok Bot runs on its own cloud computer, so most Google Sheets guides send you to register an OAuth app and paste keys into a sandbox that resets. ClawLink gives Grok Bot a more practical Google Sheets setup: it runs one CLI command, you approve once in the browser, and Grok Bot can call real Google Sheets actions from chat with no auth, token refresh, or tool wiring to build yourself. **Start here — paste this into Grok Bot to set up ClawLink:** > Set up ClawLink for me and tell me when it's ready. > 1. Pair this machine. It prints an approval link, so show me the link and stop, don't wait: `npx -y @useclawlink/cli login` > 2. I'll approve it in my browser, then reply "approved". > 3. When I say approved, connect the app: `npx -y @useclawlink/cli connect google-sheets` > 4. Then run `npx -y @useclawlink/cli whoami` and tell me whether ClawLink is ready. ## Setup It takes three steps to connect Grok Bot to Google Sheets. 1. **Pair from the terminal** — ask Grok Bot to run `npx -y @useclawlink/cli login` and approve the link it prints. 2. **Connect Google Sheets** — `npx -y @useclawlink/cli connect google-sheets`, then approve in the browser. 3. **Use it from chat** — ask Grok Bot in plain English. **The same CLI works from any agent with shell access:** ```bash npx -y @useclawlink/cli login # sign in via browser — no API key to paste npx -y @useclawlink/cli connect google-sheets # connect Google Sheets (browser OAuth) npx -y @useclawlink/cli actions google-sheets # list available actions npx -y @useclawlink/cli run google-sheets --input '' # execute (add --confirm for writes) ``` ### Install by command The prompt above does all of this. By hand, it is two commands Grok Bot runs in its own terminal, and one browser approval: ```bash npx -y @useclawlink/cli login # prints an approval link, approve it in your browser npx -y @useclawlink/cli connect google-sheets ``` Pair once and it sticks: the key is written to ~/.clawlink/credentials.json inside Grok Bot's sandbox, so it survives between sessions. Prefer native tools over shell commands? Add `https://claw-link.dev/api/mcp` as a custom connector at grok.com/connectors and approve the ClawLink sign-in. Same account, no CLI. Verify the connection by asking Grok Bot: > Use Google Sheets to googlesheets add sheet and walk me through the result in plain English. ### Using a different agent? The CLI above is not specific to Grok Bot. Claude Code, Cursor, Codex, or any agent that can run a shell command pairs with the same ClawLink account the same way: ```bash npx -y @useclawlink/cli login ``` `login` opens the same browser approval and stores a credential locally. Once Google Sheets is connected in the dashboard, that agent calls the same 40 Google Sheets tools over MCP. Full setup for MCP clients and shell agents: [connect apps to any AI agent](https://claw-link.dev/learn/connect-apps-to-any-ai-agent). ## Google Sheets MCP for Grok Bot Looking for a Google Sheets MCP server for Grok Bot? ClawLink connects Google Sheets to Grok Bot and exposes 40 Google Sheets tools your agent can call over [MCP](https://claw-link.dev/learn/what-is-an-mcp-server), with [hosted auth](https://claw-link.dev/learn/oauth-for-ai-agents) and nothing to run or maintain yourself. Using a different agent? The [OpenClaw Google Sheets integration](https://claw-link.dev/openclaw/google-sheets) and the [Hermes Google Sheets integration](https://claw-link.dev/hermes/google-sheets) connect the same ClawLink account the same way. ## What the Grok Bot Google Sheets integration can do 40 Google Sheets tools are ready for Grok Bot once the account is connected. The 30 below are the ones people reach for most; your agent can call all 40. ### 30 of 40 Google Sheets tools for Grok Bot | Tool | What it does | |---|---| | **Add sheet** `googlesheets_add_sheet` | Add a new sheet to a spreadsheet | | **Aggregate column data** `googlesheets_aggregate_column_data` | Aggregate column data by matching and computing | | **Batch get** `googlesheets_batch_get` | Retrieve data from multiple cell ranges | | **Clear values** `googlesheets_clear_values` | Clear cell content from a range | | **Create chart** `googlesheets_create_chart` | Create a chart in a Google Sheet | | **Create google sheet1** `googlesheets_create_google_sheet1` | Create a new Google Spreadsheet | | **Create spreadsheet column** `googlesheets_create_spreadsheet_column` | Create a new column in a Google Sheet | | **Create spreadsheet row** `googlesheets_create_spreadsheet_row` | Insert a new row into a Google Sheet | | **Find replace** `googlesheets_find_replace` | Find and replace text across cells | | **Format cell** `googlesheets_format_cell` | Apply text and background formatting to cells | | **Get data validation rules** `googlesheets_get_data_validation_rules` | Get data validation rules from a spreadsheet | | **Get sheet names** `googlesheets_get_sheet_names` | List all worksheet names in a spreadsheet | | **Get spreadsheet info** `googlesheets_get_spreadsheet_info` | Get metadata for a Google Spreadsheet | | **Lookup spreadsheet row** `googlesheets_lookup_spreadsheet_row` | Find a row by exact cell content match | | **Search spreadsheets** `googlesheets_search_spreadsheets` | Search for Google Spreadsheets by name or content | | **Set data validation rule** `googlesheets_set_data_validation_rule` | Set data validation rules or dropdowns on a range | | **Spreadsheets sheets copy to** `googlesheets_spreadsheets_sheets_copy_to` | Copy a sheet to another spreadsheet | | **Spreadsheets values append** `googlesheets_spreadsheets_values_append` | Append values to the end of a Google Sheet | | **Spreadsheets values batch clear** `googlesheets_spreadsheets_values_batch_clear` | Clear values from multiple ranges at once | | **Update sheet properties** `googlesheets_update_sheet_properties` | Update sheet tab properties like name or color | | **Update spreadsheet properties** `googlesheets_update_spreadsheet_properties` | Update spreadsheet-level properties like title or locale | | **Update values batch** `googlesheets_update_values_batch` | Update values in multiple ranges at once | | **Upsert rows** `googlesheets_upsert_rows` | Upsert rows by key column, appending or updating | | **Values get** `googlesheets_values_get` | Read values from a range in a Google Sheet | | **Values update** `googlesheets_values_update` | Update values in a range of a Google Sheet | | **Get conditional format rules** `googlesheets_get_conditional_format_rules` | List conditional formatting rules for each sheet (or a selected sheet) in a normalized | | **Get spreadsheet by data filter** `googlesheets_get_spreadsheet_by_data_filter` | Returns the spreadsheet at the given ID, filtered by the specified data filters | | **Search developer metadata** `googlesheets_search_developer_metadata` | Search for developer metadata in a spreadsheet | | **Spreadsheets values batch get by data filter** `googlesheets_spreadsheets_values_batch_get_by_data_filter` | Return one or more ranges of values from a spreadsheet that match the specified data filters | | **Append dimension** `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 the result in plain English. **Googlesheets Aggregate Column Data** > Use Google Sheets to googlesheets aggregate column data and walk me through the result in plain English. **Googlesheets Batch Get** > Use Google Sheets to googlesheets batch get and walk me through the result in plain English. **Googlesheets Clear Values** > Use Google Sheets to googlesheets clear values and walk me through the result in plain English. ## ClawLink vs. building it yourself The alternative to ClawLink is usually manual OAuth app setup plus your own token handling, permission troubleshooting, and tool plumbing for Grok Bot. That is fine if you want to build and maintain the integration yourself. Most teams just want Google Sheets working from chat. | | Manual | ClawLink | |---|---|---| | **Connection flow** | Register a Google Sheets app, configure redirect URLs, manage consent details, and reconnect users when auth settings drift. | Users connect Google Sheets through the hosted browser flow and ClawLink keeps the token lifecycle out of your app code. | | **Ongoing maintenance** | You own refresh logic, permission debugging, environment config, and every provider-specific edge case for Google Sheets. | ClawLink handles the repetitive integration plumbing so your team can focus on the workflow instead of the infrastructure. | | **Agent usability** | You still need to expose the right Google Sheets actions to the runtime in a format your agent can reliably use. | 40 tools for Google Sheets are already exposed through ClawLink, so the agent can read and act from chat immediately. | ## ClawLink vs. Composio Composio also exposes Google Sheets to AI agents. It is developer infrastructure: Python and TypeScript SDKs, an MCP server, and a catalog past 1,000 apps, aimed at teams shipping agent products. ClawLink is built for Grok Bot users instead. You install the plugin once, connect Google Sheets in the browser, and the 40 tools above work from chat. There is no SDK, no config file, and no API key handling. Choosing between them? Read the full [Composio alternatives](https://claw-link.dev/hub/composio-alternatives) comparison. ### Grok Bot says it cannot add ClawLink as an MCP server Grok Bot only attaches MCP servers that are reachable over the public internet, so a local stdio server is refused. You do not need one. Ask Grok Bot to run `npx -y @useclawlink/cli login` in its terminal instead. The CLI is a shell command, not an MCP server. If you would rather have native tools, add `https://claw-link.dev/api/mcp` as a custom connector at grok.com/connectors and approve the ClawLink sign-in. ### Connection succeeds but no tools appear Reconnect Google Sheets from the dashboard, then start a fresh chat if the runtime still has the old tool catalog loaded. ### "Tool schema not loaded yet" error when calling Google Sheets tools Google Sheets tool schemas load on demand the first time a tool runs and are cached after that, so this error usually clears on its own: wait a few seconds and retry the same request. If every Google Sheets call keeps failing with it in a fresh chat, reconnect from the dashboard, and contact support if it still persists — that pattern points to a configuration problem on our side, not something you can fix by reconnecting again. ### Google Sheets returns 403 or "permission denied" on one action while others work Two usual causes. The connected account may not have access to the specific workspace, inbox, store, or project in the request — check that first. If access looks right, the agent may have sent a placeholder value (like "YOUR_ID" or an example id from documentation) instead of a real one: ask it to run a list or search tool first, then retry the action with a real id from those results. Most failures at this stage are one of these two, not ClawLink bugs. ### OAuth finished in the browser but the account is still missing Try reconnecting Google Sheets and complete the consent flow in the same browser session. Partial OAuth approvals or switching accounts mid-flow can leave the connection incomplete. ### Is there a Grok Bot Google Sheets integration? Yes. ClawLink is the fastest way to connect Grok Bot to Google Sheets: link your Google Sheets account once in the browser and Grok Bot can call the Google Sheets API through 40 ready-made tools — no custom code or token handling. ### How do I connect Google Sheets to Grok Bot with ClawLink? Ask Grok Bot to run `npx -y @useclawlink/cli login` in its terminal and approve the link it prints, then `npx -y @useclawlink/cli connect google-sheets` to authorize Google Sheets. Grok Bot calls the tools from the next message, and the pairing persists in its sandbox, so this is a one-time step: no config files or API keys to manage. ### How long does it take to connect Google Sheets to Grok Bot? About two minutes. Sign in, click Connect next to Google Sheets in the dashboard, authenticate, and Grok Bot can use it from the next chat message. ### Why use ClawLink instead of wiring Google Sheets up myself? The alternative to ClawLink is usually manual OAuth app setup plus your own token handling, permission troubleshooting, and tool plumbing for Grok Bot. That is fine if you want to build and maintain the integration yourself. Most teams just want Google Sheets working from chat. ### Grok Bot says it cannot add ClawLink as an MCP server Grok Bot only attaches MCP servers that are reachable over the public internet, so a local stdio server is refused. You do not need one. Ask Grok Bot to run `npx -y @useclawlink/cli login` in its terminal instead. The CLI is a shell command, not an MCP server. If you would rather have native tools, add `https://claw-link.dev/api/mcp` as a custom connector at grok.com/connectors and approve the ClawLink sign-in. ## Related - [Connect Google Super](https://claw-link.dev/grokbot/google-super) — Unified access to multiple Google services in one integration - [Grok Bot Google Drive integration](https://claw-link.dev/grokbot/google-drive) — Upload, search, and manage files - [Grok Bot Google Analytics integration](https://claw-link.dev/grokbot/google-analytics) — Connect Google Analytics properties through hosted Google OAuth