# Local listing health board for every location you manage

> See every Google Maps listing you manage on one screen, ranked worst first, with an audit button that writes the fix list for you.

- Workflow type: app
- Services: Local Business Data, Google Sheets
- Categories: Marketing, Operations
- Published: 2026-08-31

## What it does

- Add each location by searching for it by name and city, then save it to a board grouped by client or region.
- Get one row per location showing rating, total reviews, new reviews since your last visit, whether the website, phone and hours are filled in, photo count, and days since the last owner post.
- Rows are scored and sorted worst first, so the weakest listing is always sitting at the top of your Monday check.
- Click any location for its recent reviews, its photos, and the themes people keep mentioning, plus a short internal note you can keep on every row.
- Hit Audit to have a background assistant read the listing and write a prioritized fix list back into the app, then export a client ready sheet to Google Sheets.

## What you'll need

- A Local Business Data connection, which is how the board reads public Google Maps listing information
- A Google account so the export can create and fill a spreadsheet in Google Sheets
- The list of locations you look after, findable by name and city on Google Maps
- A way you want locations grouped, usually by client, brand or region

## Prompt

I want an app that gives me one screen for the health of every Google Maps listing I am responsible for, so my Monday check is a single board instead of opening each location in Google Maps one by one. It is built for local SEO agency account managers and multi-location marketing leads, so it has to handle locations spread across several clients and regions.

Adding a location works by searching. I type a business name, or a name plus a city, and the app uses Autocomplete in Local Business Data for predictions as I type, then Search to resolve the real Google Maps listing. Show me the candidate matches with name, full address and rating so I can confirm I have the right one, then save the business id along with the name, address, a group I choose or create (client or region), and an empty internal note. The saved list persists in the app, and I can edit a location's group, edit its note, or remove it later.

The board is the home page: one row per saved location, with columns for rating, total reviews, new reviews since my last visit, whether the listing has a website, whether it has a phone number, whether hours are filled in, photo count, and days since the last owner post. Rows read through Business Details for the profile fields, rating and review count, Business Photos for the photo count, and Business Posts for the date of the most recent owner post. Business Details accepts up to 20 business ids in one call, so refresh the board in batches of 20 rather than calling it once per row. Business Photos and Business Posts use cursor pagination, so follow the cursor from each response when a full count is needed. Cache the row snapshot per location so the board loads fast and only refetches on demand or when the snapshot is older than a staleness window.

New reviews since my last visit comes from storing, per location, the total review count and the timestamp at the moment I last opened the board, then showing the difference on my next visit. Each row also gets a health score built from penalties: no website, no phone number, no hours, photo count under a threshold, no owner post in the last 30 days, rating below 4.0, and a rating drop since the previous snapshot. Sort the board worst score first so the weakest listing is always at the top, show the score as a number with a colored status, and let me expand a row to see exactly which penalties made it up.

I can group the board by client or region, collapse and expand those groups, and filter down to a single group. Each group header shows a roll-up: number of locations, average score, and the worst location in the group. Every row keeps a short internal note that I can edit inline, saved with the location and shown on the detail page and in the export.

Clicking a location opens its detail page. The header repeats the profile facts and the score, then there are three sections. Recent reviews come from Business Reviews sorted newest first, showing rating, author, date and text, with a load more button that follows the cursor. Photos come from Business Photos as a grid, also cursor paginated. Review keywords come from Business Details Plus, which is the only source of the keywords mentioned in reviews. Business Details Plus costs 2 credits per business, so call it only here on the detail page, never for the whole board, and cache the result per location.

An Audit this location button on the detail page runs an embedded background agent scoped to that one location. The agent reads the listing with Business Details Plus, the recent reviews with Business Reviews, and the owner posts with Business Posts, then writes a prioritized fix list back into the app attached to that location: missing or weak profile fields, posting recency problems with a suggested topic for the next post, and the recurring themes in reviews that deserve an owner response. Each item carries a priority of high, medium or low and a one line action. Store the fix list with a timestamp, show it on the detail page, show an audited badge with its date on the board row, and let me re-run the audit whenever I want. While the agent is running the button shows a running state, and the result appears in place when it finishes.

An Export audit button builds a client ready sheet. It calls Create Spreadsheet in Google Sheets, named for the group and the date, then Append Values to write a header row plus one row per location in scope: location name, address, group, rating, total reviews, new reviews, whether website, phone and hours are present, photo count, days since the last owner post, health score, the top fix items from the latest audit, and my internal note. Show me the resulting spreadsheet link when it is done. I should be able to export the whole board or just one group.

Everything the app reads is public Google Maps listing data and the app is read only against those listings: it never edits a Google Business Profile, it tells me what to fix. Keep credit use in mind throughout by batching Business Details, keeping Business Details Plus to the detail page and the audit agent, and caching row snapshots between refreshes.

## How to customize

- Reweight the health score so the things your clients care about most, like stale posts or thin photo galleries, push a location to the top
- Change the thresholds for what counts as a stale post or too few photos
- Switch the default grouping between client, brand and region, and choose which group the board opens on

## FAQ

### Do I need to own or manage these listings to track them?

No. Everything the board reads is public Google Maps information, so you can track the locations you manage and keep an eye on competitors in the same view. Making the actual fixes still happens in Google Business Profile.

### How does it know which reviews are new?

The board remembers each location's review count from the last time you opened it, then shows you the difference the next time you visit. So the 'new reviews' column always means new since you last looked, not new since some fixed date.

### Can I use this for more than one client?

Yes. Every location belongs to a group you pick when you add it, usually a client or a region, and the board can collapse, filter and roll up by that group. Exports can cover the whole board or a single client.

### What does the Audit button actually do?

It starts a background assistant on that one location. The assistant reads the listing, its recent reviews and its owner posts, then writes a prioritized fix list back into the app: missing profile fields, posting gaps, and the review themes worth responding to. It appears on the location page when it finishes.

### Will it post replies or change my listings?

No. The app is read only against Google Maps. It tells you what to fix and hands you a client ready sheet, and you make the changes yourself.

Use this prompt in General Input: https://www.generalinput.com/prompts/local-listing-health-board-for-every-location-you-manage