InstaMaps
Workflows / Geocoded address list

Geocoded address list from Gmail to Google Sheets

Latitude, longitude and how sure the match is, for every address. Ask your AI in plain English: it reads Gmail, InstaMaps does the location work, and the results land in Google Sheets.

Gmail
InstaMapsInstaMaps
Geocoded address list
Google Sheets
Works inClaudeChatGPTCopilotGemini
Add InstaMaps to your AI →
Free connector · sign in with Google · about a minute

The prompt

Find this week's emails in my Gmail labelled "Orders" and pull out each delivery address, add the latitude, longitude and how sure the match is for every address, and put the results in a new tab of this Google Sheet: <link to a sheet>.

Replace the parts in <angle brackets>.

What comes back

  • Latitude and longitude
  • A confidence (high, medium or low) with the reason, such as "postcode centre"
  • The county or council
  • Anything that can't be placed or answered comes back with the reason. Nothing is dropped.

Set it up

Geocoded address 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.

  1. In Claude, open Settings, then Connectors, and choose "Add custom connector".
  2. Name it InstaMaps and paste https://get-instamaps.com/mcp. Click Add.
  3. Click Connect and continue with Google. You land back in Claude, ready to ask.
  4. Add the Google Drive, Gmail or Google Calendar connector from the same Connectors page when the chain uses them.
  5. Paste the prompt above.
Claude's own guide ↗

Before you start

Reading Gmail

Connect your AI tool's Gmail connector and label the emails you want read. The addresses pass through the chat, so keep it to a few hundred at a time.

Writing to Google Sheets

InstaMaps writes to the sheet itself: share it with the address the answer gives you, as Editor. It adds new dated columns or a new tab, and never overwrites a cell.

Run it on a schedule

Every Monday at 8am: find this week's emails in my Gmail labelled "Orders" and pull out each delivery address, add the latitude, longitude and how sure the match is for every address, and put the results in a new tab of this Google Sheet: <link to a sheet>.

  • Claude. Scheduled tasks run a prompt hourly, daily, on weekdays or weekly, with the connectors you've added. They need a paid plan (Pro, Max, Team or Enterprise), and on Pro and Max they run in the cloud, so your computer can be off.
  • ChatGPT. ChatGPT has scheduled tasks, but OpenAI doesn't yet say whether they can use a custom connector. Run the prompt by hand until it does.
  • Microsoft Copilot and Teams. Copilot Studio agents can run on a schedule with a Recurrence trigger. The run uses the agent author's sign-ins.
  • Gemini. Google doesn't yet say whether scheduled actions can use a custom app. Run the prompt by hand until it does.

Good to know

  • Strongest in the US and Great Britain. Rows that can't be placed come back with the reason, never dropped.
  • The connector is free: 5,000 tool calls a day per person, and a whole sheet read by link counts as one call.
  • Rather do it without an AI? Use the free tool on our site.

Related workflows

Geocoded address list in Google SheetsGeocoded address list from Google Sheets to a Google Drive fileGeocoded address list from a Google Drive file to Google SheetsGeocoded address list in Google Drive fileGeocoded address list from Gmail to a Google Drive fileRadius filter from Gmail to Google Sheets