Answer about your list from Google Sheets to Gmail
A plain-English question answered across the whole list, with the reading shown. Ask your AI in plain English: it reads Google Sheets, InstaMaps does the location work, and the results land in Gmail.
Google Sheets
InstaMapsAnswer about your list
Gmail
Claude
ChatGPT
Copilot
GeminiThe prompt
Using the rows in this Google Sheet: <link to your sheet>, answer this: how many of our open jobs are in Leeds, and which are the five oldest?, and email me (<your email>) the answer.
Replace the parts in <angle brackets>.What comes back
- The answer, with how the question was read
- The rows behind it
- Anything that can't be placed or answered comes back with the reason. Nothing is dropped.
Set it up
Answer about your list in Claude
Every plan, including Free. On Free, InstaMaps uses your one custom connector; Google Drive, Gmail and Google Calendar are directory connectors and don't count against it.
- In Claude, open Settings, then Connectors, and choose "Add custom connector".
- Name it InstaMaps and paste https://get-instamaps.com/mcp. Click Add.
- Click Connect and continue with Google. You land back in Claude, ready to ask.
- Add the Google Drive, Gmail or Google Calendar connector from the same Connectors page when the chain uses them.
- Paste the prompt above.
Before you start
Reading Google SheetsShare the sheet with InstaMaps, or set it to "anyone with the link can view". InstaMaps reads it straight from Google, so a sheet of thousands of rows is one call, and nothing passes through the chat.
Writing to GmailYour AI tool's Gmail connector sends it. Ask for a draft instead if you'd rather check it first.
Good to know
- Works on the whole list, however long, because InstaMaps reads it directly.
- The connector is free: 5,000 tool calls a day per person, and a whole sheet read by link counts as one call.
