Cuiar
Sign inDownload

Check and complete business addresses in a sheet

Each business address checked on the map, with the postcode, the coordinates and a status for each row.

  • You start it: When you start it
Use in CuiarRun from your AI agent

What it does

The task

Open the sheet sheet url. Each row is a business location, such as a store, a supplier, a site or a venue. For each address, search Google Maps and check that the place is at that address. Fill in new columns: street, city, postcode, country, latitude and longitude. Add a Status column with Confirmed, Corrected, Moved or Not found, and a note for each correction. Do not change the original columns, and skip each row that is the home address of a person.

  • It works in Google Maps and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
  • It runs once, when you start it.

What you give it

BlankWhat to giveExample
sheet urlThe Google Sheet with business addresseshttps://docs.google.com/spreadsheets/d/1Ad6sLp9Fv/edit

What you get back

An example run with the example values above. Your run uses your own data.

Addresses checked: 318 store locations

Confirmed: 271

Corrected: 29 (for example, postcode 1012 AB changed to 1012 AH, or a wrong street number)

Moved: 8 (Google Maps shows the place at a new address)

Not found: 10

New columns: street, city, postcode, country, latitude, longitude

Original columns not changed

Run it in Cuiar

  1. 01

    Open it

    Click Use in Cuiar on this page. The side panel opens with the task in the composer.

  2. 02

    Fill in the blank

    Type sheet url. Tab moves to the next blank.

  3. 03

    Run it

    Run sends it to the agent. Follow each step in the panel, and stop it at any time.

From the terminal

cuiar exec "Open the sheet https://docs.google.com/spreadsheets/d/1Ad6sLp9Fv/edit. Each row is a business location, such as a store, a supplier, a site or a venue. For each address, search Google Maps and check that the place is at that address. Fill in new columns: street, city, postcode, country, latitude and longitude. Add a Status column with Confirmed, Corrected, Moved or Not found, and a note for each correction. Do not change the original columns, and skip each row that is the home address of a person."

Run it from your AI agent

Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call run_task yourself.

1. Add Cuiar to Claude Code

claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp

2. Ask your agent

Use the Cuiar tool run_task to run my "Check and complete business addresses in a sheet" template with sheet url = https://docs.google.com/spreadsheets/d/1Ad6sLp9Fv/edit.

Setup for other agents: AI agents.

The tool call

{
  "name": "run_task",
  "arguments": {
    "task": "Open the sheet https://docs.google.com/spreadsheets/d/1Ad6sLp9Fv/edit. Each row is a business location, such as a store, a supplier, a site or a venue. For each address, search Google Maps and check that the place is at that address. Fill in new columns: street, city, postcode, country, latitude and longitude. Add a Status column with Confirmed, Corrected, Moved or Not found, and a note for each correction. Do not change the original columns, and skip each row that is the home address of a person."
  }
}

Related templates

All data templates

  • Data

    List local businesses with their contacts

    Name, address, phone, website, rating and e-mail for each business.

    You start it: When you start it
    • Google Maps
    • Google Sheets

  • Finance

    Build a mileage log from your calendar

    Each business trip with its date, purpose, route and distance, and the total claim at your rate.

    You start it: When you start it
    • Google Calendar
    • Google Maps
    • Google Sheets

  • PersonalAsks first

    Ask local tradespeople for quotes

    Well-rated local businesses get one clear quote request each, after you approve the list and the text.

    You start it: When you start it
    • Google Maps
    • Yelp
    • Any web form
    • +1 more: Google Sheets

  • Personal

    Compare schools near my home

    Walking time, inspection grade, results, places and admission rules for each school, in one sheet.

    You start it: When you start it
    • Any government site
    • Google Maps
    • Google Sheets

  • Personal

    Shortlist apartments to rent in a sheet

    Listings that meet your rules, with the full monthly cost, the commute and the red flags for each.

    You start it: When you start it
    • Zillow
    • Any website
    • Google Maps
    • +1 more: Google Sheets

  • Data

    Turn a list on a website into a sheet

    Each item from each page, one row for each, with no duplicates.

    You start it: When you start it
    • Any website
    • Google Sheets