InstaMaps
Workflows / Census tract and zone check

Census tract and zone check from Google Sheets to a Google Drive file

Census tract, HUBZone, Opportunity Zone and FEMA flood zone for every US address; flood zone for England. Ask your AI in plain English: it reads Google Sheets, InstaMaps does the location work, and the results land in a Google Drive file.

Google Sheets
InstaMapsInstaMaps
Census tract and zone check
Google Drive file
Works inClaudeChatGPTCopilotGemini
Add InstaMaps to your AI →
Free connector · sign in with Google · about a minute

The prompt

Using the rows in this Google Sheet: <link to your sheet>, add the census tract, HUBZone, Opportunity Zone and FEMA flood zone for each address, and save the results to my Google Drive as a CSV file called "Census tracts and zones".

Replace the parts in <angle brackets>.

What comes back

  • The census tract (the FFIEC-style 11-digit code)
  • HUBZone and Opportunity Zone: yes or no
  • The FEMA flood zone (England flood zone for UK rows)
  • Anything that can't be placed or answered comes back with the reason. Nothing is dropped.

Set it up

Census tract and zone check 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 Google Sheets

Share 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 a Google Drive file

Your AI tool's Google Drive connector saves the file.

Good to know

  • US facts for US addresses, England facts for English ones. Each answer says which official dataset it came from.
  • 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

Census tract and zone check in Google SheetsCensus tract and zone check from a Google Drive file to Google SheetsCensus tract and zone check in Google Drive fileGeocoded address list from Google Sheets to a Google Drive fileMileage log from Google Sheets to a Google Drive fileDriver routes from Google Sheets to a Google Drive file