The Scenario
You're a business development rep and your manager dropped a sheet in Slack at 9 AM: 150 company names, each paired with a city. By end of day you need the verified Google Maps place ID, formatted address, phone number, and star rating for each. It's for a prospect enrichment push.
You have one other thing due by noon.
The bad version:
- Open Google Maps, type the first business name and city, click the listing in the results, note the address, find the phone number, look for the rating
- Switch back to the sheet, find the row, paste in the four data points
- Repeat 149 more times — and on row 23 realize the search returned the wrong franchise location, so now you have to go back and redo it
150 rows times four fields equals 600 individual copy-paste actions. That's the math before accounting for the disambiguation problem: half these businesses have multiple locations and you have to pick the right one.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that calls Google Maps Text Search for each row and writes the top result's details back inline.
For each business name and city in my Google Sheet, search Google Maps and fill in the place ID, formatted address, phone number, and rating in the adjacent columns
What You Get
- Column B gets the Google Maps place ID for the top result
- Column C gets the formatted address
- Column D gets the phone number (if listed on Maps)
- Column E gets the star rating
- Rows where Maps returns no confident match get a "No result" note rather than blank cells
What If the Data Is Not Quite Ready
Some entries have only a company name with no city — need to scope the search differently
For rows in my Google Sheet where column B (city) is blank, search Google Maps using only the company name in column A with no location filter. For rows where column B has a city, include it in the search. Write place ID, address, phone, and rating into columns C through F for all rows.
The dataset mixes company names with full street addresses — treat them differently
In my Google Sheet, column A holds either a business name or a full street address. If the value looks like an address (contains a number followed by a street name), use Google Maps geocoding to get the place details. If it looks like a business name, use Text Search. Write place ID, formatted address, phone, and rating into columns B through E.
Ratings below 3.5 should be flagged so the SDR can deprioritize them before outreach
Search Google Maps for each business name and city combination in my Google Sheet. Write place ID, address, phone, and rating into columns B through E. Add a flag in column F: "Deprioritize" if the rating is below 3.5, "Review" if it's between 3.5 and 4.0, and "Strong" if it's above 4.0.
Full enrichment chain: text search, place detail fetch, and qualification flag — one prompt
For each row in my Google Sheet with a company name in column A and city in column B: run a Google Maps text search, take the top result's place ID, fetch the full place details, and write the display name, formatted address, phone number, rating, total review count, and website URL into columns C through H. Flag in column I if review count is below 10 (low data confidence).
One pass — search, enrichment, and qualification scoring together.
Try It
Get the 7-day free trial of SheetXAI and open your prospect list — then ask SheetXAI to enrich every row against Google Maps in one shot. Once you have place IDs, see how to pull full business details from place IDs for hours, photos, and more.