The Scenario
You're a local SEO consultant. A client just handed you a citation audit template — an Excel workbook — with 80 location rows, each pre-populated with a Google Maps place ID. The template has empty columns waiting for opening hours, current star rating, total review count, phone number, and website URL.
This is the third time you've done this audit this month.
The bad version:
- Take the first place ID, paste it into a Maps URL pattern to open the listing
- Manually copy the phone, the website, the hours for each day, the rating, and the review count into the workbook
- Repeat 79 more times — and realize halfway through that your client's template wants hours formatted as "Mon: 9am–5pm" but Maps shows "Monday: 9:00 AM – 5:00 PM"
80 locations, six fields each, formatting inconsistencies to resolve. This is the kind of audit that used to take a full day.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. Give it the column with place IDs, tell it what to write back, and it calls the Google Maps Place Details API for every row.
Look up the Google Maps place details for every place ID in my Excel sheet and populate columns for display name, address, rating, total reviews, and whether the place is currently open
What You Get
- Display name column fills for each place ID
- Address column fills with the formatted address
- Rating column fills with the current star rating
- Total reviews column fills with the review count
- An "Open now" column shows whether the location is currently open at time of the audit
- Rows where the place ID is invalid or the listing has been removed get flagged
What If the Data Is Not Quite Ready
The template needs hours broken out by day into separate columns
For each place ID in the PlaceID column of my Excel workbook, fetch the Google Maps place details. Write the business name into the Name column, rating into the Rating column, and then write Monday hours into the Mon column, Tuesday into Tue, and so on through Sunday. If a day is marked "Closed," write "Closed." If hours are unavailable, write "N/A."
Some place IDs are outdated — the listings may have moved or closed
Fetch Google Maps place details for each place ID in the PlaceID column of my Excel workbook. If the API returns "NOT_FOUND" or the business_status is "CLOSED_PERMANENTLY," write "Listing removed" in the Name column and leave the other columns blank. For valid results, write name, address, phone, website, and rating.
The client wants to know which locations are currently open at time of audit
For each place ID in my Excel workbook, fetch the Google Maps place details and write the business name, rating, phone, and website into the appropriate columns. In the Status column, write "Currently open" or "Currently closed" based on the current_opening_hours status, and include the next opening time if the location is closed.
Full citation audit: details fetch, opening-hours normalization, rating tier, and gap detection in one pass
For each place ID in my Excel workbook, fetch all Google Maps place details. Write name, address, phone, website, rating, review count, and opening hours. In a Tier column, classify rating as "Strong" (≥4.5), "Average" (3.5–4.4), or "Needs work" (<3.5). In a Gaps column, flag "Missing phone" or "Missing website" if those fields are absent.
Combined in one prompt — no intermediate steps.
Try It
Get the 7-day free trial of SheetXAI and open your citation audit workbook — ask SheetXAI to pull the full details for every place ID in one pass. To get place IDs in the first place, see how to text search business names against Google Maps.