The Scenario
You're a business development rep and your manager dropped a workbook 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 workbook, 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 Excel workbook that calls Google Maps Text Search for each row and writes the top result's details back inline.
Take the 200 business queries in column A of my Excel sheet and run a Google Maps text search for each one, writing the top result's name, address, rating, and place ID into columns B through E
What You Get
- Column B gets the display name of the top Google Maps result
- Column C gets the formatted address
- Column D gets the star rating
- Column E gets the Google Maps place ID
- 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 Excel workbook where the City column is blank, search Google Maps using only the company name with no location filter. For rows where City has a value, 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 Excel workbook, 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 Excel workbook. 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 Excel workbook 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 workbook — 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.