The Scenario
You're a local SEO consultant. A client just handed you a citation audit template 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 spreadsheet
- 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 Google Sheet. 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.
For each place ID in column A of my Google Sheet, fetch the place details from Google Maps and write the business name, formatted address, phone, website, opening hours, and current rating into the next columns
What You Get
- Column B: display name
- Column C: formatted address
- Column D: phone number
- Column E: website URL
- Column F: opening hours as a structured list (e.g., Mon: 9:00 AM – 5:00 PM)
- Column G: current star rating
- Rows where the place ID is invalid or the listing has been removed get flagged in column H
What If the Data Is Not Quite Ready
The template needs hours broken out by day into separate columns
For each place ID in column A of my Google Sheet, fetch the Google Maps place details. Write the business name into column B, rating into column C, and then write Monday hours into column D, Tuesday into column E, Wednesday into column F, and so on through Sunday in column J. 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 column A of my Google Sheet. If the API returns "NOT_FOUND" or the business_status is "CLOSED_PERMANENTLY," write "Listing removed" in column B and leave the other columns blank. For valid results, write name, address, phone, website, and rating into columns B through F.
The client wants to know which locations are currently open at time of audit
For each place ID in my Google Sheet, fetch the Google Maps place details and write the business name, rating, phone, and website into columns B through E. In column F, write "Currently open" or "Currently closed" based on the current_opening_hours opening_status from the API, 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 column A of my Google Sheet, fetch all Google Maps place details. Write name, address, phone, website, rating, review count, and opening hours into columns B through H. In column I, classify rating as "Strong" (≥4.5), "Average" (3.5–4.4), or "Needs work" (<3.5). In column J, 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 template — 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.