Northpeak Studio Labs

How to find every Google review you haven't replied to

Replying to reviews is one of the few things that visibly improves how a business looks on Google, and future customers do read the replies. The hard part is finding the ones you missed, especially old ones buried under hundreds of newer reviews. Here's a quick way to list them all, plus short replies you can adapt.

1. Get all your reviews into a spreadsheet

  1. Get Maps Reviews Exporter. It's free and needs no account or login.
  2. Open your business on Google Maps, click the extension, set the sort to Lowest rating and click Collect reviews. Sorting by lowest first means the free 50 cover the reviews that matter most.
  3. Click Export CSV and open the file in Google Sheets or Excel.

2. Filter to the ones with no reply

Turn on a filter (Data → Create a filter in Google Sheets), then on the owner_response column (column Q) keep only blanks. Sort by rating (column I), lowest first. That's your to-do list.

To count them: =COUNTIFS(I2:I,"<=3",Q2:Q,"") gives the number of unanswered 1 to 3 star reviews.

3. Reply, starting with the worst

Keep replies short, specific and calm. Never argue, and never share a customer's private details. Some starting points:

1 or 2 stars

Hi [name], thanks for telling us, and I'm sorry the [wait / order / visit] wasn't what it should have been. That's not the standard we aim for. If you're willing, please contact us at [email or phone] so we can make it right.

3 stars

Thanks for the honest review, [name]. Glad you liked [the thing they liked]. We hear you on [the complaint] and we're working on it. Hope to see you again.

4 or 5 stars

Thank you, [name]! Really glad you enjoyed [specific thing they mentioned]. See you next time.

Mentioning the specific thing they wrote about matters more than the wording. It shows a real person read it.

4. Keep it from piling up again

Run the export once a month with the sort set to Newest, and filter for blanks again. It takes a couple of minutes and you'll never fall behind.

Free vs Pro

Free exports 50 reviews per place, which is often enough when you sort by lowest rating. If you have hundreds of reviews, Pro ($24.99 once, no subscription) exports every one and adds star and keyword filters plus an owner reply rate in the summary, so you can see your progress.

Updated 2026-10-16.