ClawLink
TL;DR
| Question | Answer |
|---|---|
| What does it do? | Your agent finds your sheet by name, reads its rows and lists every row with a missing email address, so you know what to fix before you send anything. |
| Who is it for? | Anyone who keeps leads, orders or contacts in Google Sheets. |
| What do I connect? | Google Sheets, once, with its own sign-in. ClawLink never sees your password. |
| What does it cost? | About 2 tool calls on your plan. Starter includes 1,000 a month. |
| Does it work? | googlesheets_search_spreadsheets succeeded on 93.9% of 114 calls on ClawLink in the last 30 days. |
| Which agents? | OpenClaw, Hermes, Claude, Codex, ChatGPT and any MCP client connected to ClawLink. |
How do you try it?
- Set up ClawLink once. Add it to your agent from the install page, then connect Google Sheets.
- Send this prompt to your agent. Click the card to copy it.
It works the same in OpenClaw, Hermes, Claude and Codex.
How does the agent do it?
The agent makes 2 calls through ClawLink. You do not pick the tools: the agent finds them by searching ClawLink, reads their input schema and runs them.
| Step | Tool | What it does | Calls in 30 days |
|---|---|---|---|
| 1 | googlesheets_search_spreadsheets | Finds the spreadsheet by name. | 114 (93.9% ok) |
| 2 | googlesheets_batch_get | Reads the cell values of one or more ranges. | 904 (99.3% ok) |
How often does this work on ClawLink?
We do not publish a sample run for this job: its output is somebody's own Google Sheets. Instead, here is how the same tools performed for every ClawLink user from 2026-09-03 to 2026-10-03. A call counts as failed only when it reached Google Sheets and came back with an error.
| Tool | Calls | Users | Succeeded | Average time |
|---|---|---|---|---|
googlesheets_search_spreadsheets | 114 | 28 | 93.9% | 2.9 s |
googlesheets_batch_get | 904 | 15 | 99.3% | 2.3 s |
How do you write the prompt?
- Name the sheet and the column. "The Leads sheet, column Email" removes guessing.
- Ask for row numbers. So you can jump to each row in the sheet.
- Check more than one field. "Missing email or phone" works in the same run.
What can go wrong?
- Header row. If the first row is not a header, say so, or the agent skips a real row.
- Several tabs. A spreadsheet can have many tabs. Name the tab.
- Large sheets. Tens of thousands of rows need reading in parts. Ask the agent to page through.
How does this compare with other ways to do it?
| Option | How it works | Cost | Best for |
|---|---|---|---|
| ClawLink + your agent | One prompt, a list of incomplete rows | 2 tool calls on your plan | Checking a list before using it |
| Filter in Sheets | Filter by blank | Free | One column, one time |
| Apps Script | A script | Free, your time | A rule you run forever |
Frequently asked questions
Can the agent fill in the gaps?
It can write values with the Sheets update tools if you give it the data. This prompt only reads.
Does it work with Excel files?
Not this tool. Connect Microsoft Excel for files in OneDrive.
Does ClawLink keep my sheet?
No.
What does it cost?
Two tool calls, plus one per extra range.
Can it check every week?
Yes, ask your agent to schedule it.