The Scenario
You're the franchise development manager for a regional restaurant group. The board approved 12 new locations in Q3. Before lease negotiations begin, you need verified data — current Google ratings, confirmed phone numbers, and accurate street addresses — for 200 existing competitor locations in your target markets.
Someone on your team pulled together a list of business names and cities in columns A and B. Now you need Google Maps data for each one in columns C, D, and E. The franchise committee meets in 10 days.
The bad version:
- Open Google Maps. Type the first business name and city. Find the listing — there are sometimes 3 businesses with the same name in the same city. Pick the right one. Copy the address. Go back to the sheet. Paste it into column C. Find the phone number on the Maps listing. Paste it into column D. Note the star rating. Paste into column E. Next row.
- After 40 rows, you realize you've been copying the rating for the parent brand instead of the individual location on 6 of them. The parent brand has 4.5 stars; the location you actually looked at has 3.2. Two very different signals for site selection.
- You ask an intern to help. They move fast and misalign a few rows. Now you're not sure which ratings belong to which locations and you'd have to re-verify anyway.
Two hundred locations at 4 minutes each is 13 hours of data entry. That's not site selection work. That's a spreadsheet maintenance tax.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads business names from column A and cities from column B, queries Composio Search's Google Maps tool for each pair, and writes verified addresses, phone numbers, and star ratings into columns C, D, and E.
Look up each business name and city from columns A and B on Google Maps and fill in the full address into column C, phone number into column D, and star rating into column E.
Two hundred locations, three verified fields each, in one pass.
What You Get
- Column C: Full street address for the specific location
- Column D: Phone number as listed on Google Maps
- Column E: Current star rating (rounded to one decimal)
- Rows where no Maps match is found are flagged 'Not Found' in column C
- Results match the specific location, not the brand's aggregate rating
What If the Data Is Not Quite Ready
Some business names are too common and need a street address hint to disambiguate
"Starbucks, Seattle" returns 40 results. You have partial addresses in column F to help narrow the match.
Look up each business from columns A and B on Google Maps. If the result is ambiguous, use the partial address in column F to find the specific location. Write the confirmed full address into column C, phone into column D, and rating into column E.
You want to verify whether each location is currently operational
Some of the competitor locations on your list may have closed since the data was compiled.
For every location in my sheet, check Google Maps to confirm if the business is currently operational and write 'Open', 'Permanently Closed', or 'Not Found' into column F.
You want to add the Google Maps URL for the field team to verify
Look up each business from columns A and B on Google Maps and write the full address into column C, phone into column D, star rating into column E, and the direct Google Maps URL for the listing into column F.
Kill chain: verify, flag closures, flag low-rated locations, add Maps links
Look up each business name and city from columns A and B on Google Maps. Write full address into column C, phone into column D, star rating into column E, and Google Maps URL into column F. Mark any location showing as permanently closed with 'Closed' in column G. Flag any location with a rating below 3.5 with 'Low Rating' in column H.
One prompt verifies every location, surfaces closures, and flags the sites your field team will want to investigate.
Try It
Get the 7-day free trial of SheetXAI and open your location research sheet. Ask it to verify addresses, phone numbers, and ratings from Google Maps for every row in your business list. See also: Research Travel Venues Into a Google Sheet With Composio Search TripAdvisor or the Composio Search hub.