How to build a free Google reviews dashboard in Google Sheets

Review tracking tools charge a monthly fee for what is really four numbers and a chart: average rating, how many reviews came in, how many got a reply, and whether the trend is going up or down. You can build the same thing in Google Sheets in about fifteen minutes, then refresh it once a month in two.

1. Set up two tabs

Create a new Google Sheet with a tab called Data and a tab called Dashboard. All the formulas below live on Dashboard and read from Data, so refreshing never means rebuilding.

2. Fill the Data tab

1. Get Maps Reviews Exporter. It's free and needs no account.
2. Open the business on Google Maps, click the extension, set the sort to Newest and click Collect reviews.
3. Click Export CSV. In Google Sheets, open the Data tab, then File → Import → Upload, choose Replace current sheet, and untick Convert text to numbers, dates, and formulas so the dates stay in the same form the formulas below expect.

The columns used here are rating (I), date_estimated (K) and owner_response (Q).

3. The four headline numbers

On the Dashboard tab, put labels in column A and these formulas in column B:

• Average rating: =ROUND(AVERAGE(Data!I2:I),2)
• Reviews in the last 30 days: =SUMPRODUCT(Data!K2:K>=TEXT(TODAY()-30,"yyyy-mm-dd"))
• Reply rate: =COUNTIF(Data!Q2:Q,"?*")/COUNTA(Data!I2:I), formatted as a percent
• Unanswered 1 to 2 star reviews: =COUNTIFS(Data!I2:I,"<=2",Data!Q2:Q,"")

Dates in the export are text in yyyy-mm-dd form, which is why the 30-day formula turns today's date into the same format. Text dates in that form sort and compare correctly.

4. The monthly trend

In D1 put this, and it builds the whole table for you:

=QUERY({ARRAYFORMULA(LEFT(Data!K2:K,7)),Data!I2:I},"select Col1, count(Col2), avg(Col2) where Col1 where Col1 <> '' group bylt;where Col1 <> '' group bygt; '' group by Col1 order by Col1 label Col1 'Month', count(Col2) 'Reviews', avg(Col2) 'Avg rating'",0)

Select the Month and Avg rating columns and choose Insert → Chart → Line chart. Add a second chart from Month and Reviews as columns. Now you can see at a glance if a bad month was a one-off or the start of a slide.

5. Star breakdown

In H2 to H6 type 5, 4, 3, 2, 1, and in I2 put =COUNTIF(Data!I$2:I,H2) and fill down. A bar chart of that range shows whether the average is being held up by a few fans or dragged down by a cluster of one-star reviews.

6. Refresh it monthly

Once a month, export again and import into the Data tab with Replace current sheet (with the same box unticked). Every number and chart on the Dashboard updates by itself. To track several locations, make one Data tab per location and copy the Dashboard tab, pointing it at the matching Data tab. There's more on that in comparing reviews across locations.

Free vs Pro

The free version exports the newest 50 reviews, which is enough for a monthly refresh at most small businesses. For a full history, and for busy listings, Pro ($24.99 once, no subscription) exports every review and builds a rating-by-month and reply-rate summary inside the extension too.

Updated 2026-10-24.