InstaMaps
Workflows / Official records check

Official records check from a Google Drive file to Google Sheets

For UK addresses: the food hygiene rating, CQC rating, or the nearest A&E and the NHS trust running it. Ask your AI in plain English: it reads a Google Drive file, InstaMaps does the location work, and the results land in Google Sheets.

Google Drive file
InstaMapsInstaMaps
Official records check
Google Sheets
Works inClaudeChatGPTCopilotGemini
Add InstaMaps to your AI →
Free connector · sign in with Google · about a minute

The prompt

Using the rows in this CSV or Excel file in my Google Drive: <link to the file>, add the food hygiene rating of the business at each 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

  • The official record at each address, with its rating and date
  • Or the nearest registered place, such as an A&E
  • Anything that can't be placed or answered comes back with the reason. Nothing is dropped.

Set it up

Official records 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. Paste the prompt above.
Claude's own guide ↗

Before you start

Reading a Google Drive file

Share the file with InstaMaps, or set it to "anyone with the link can view". InstaMaps reads it straight from Drive.

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.

Good to know

  • UK registers (CQC, NHS, Food Standards Agency). Not available for US addresses.
  • The connector is free: 5,000 tool calls a day per person, and a whole sheet read by link counts as one call.

Related workflows

Official records check in Google SheetsOfficial records check from Google Sheets to a Google Drive fileOfficial records check in Google Drive fileGeocoded address list from a Google Drive file to Google SheetsRadius filter from a Google Drive file to Google SheetsMileage log from a Google Drive file to Google Sheets