Recipe: a report on your Google reviews¶
Copy your Google reviews into a text file and give it to Hermes. It works out the average rating, counts the stars, finds what customers praise and what they complain about most, and suggests three concrete improvements.
| Time needed | 10 minutes (most of it to copy the reviews) |
| You need | A Hermes agent connected to an AI model and your reviews in a text file, with the number of stars of each one |
| Result | A short report with the rating, the top 3 praises and complaints with how many reviews mention each, and 3 improvements, saved in reviews-report.md |
1. Copy your reviews into a file¶
Copy your Google reviews into a text file (Notepad, TextEdit): the number of stars and the text of each review. Give each review a number, so you can check the counts later. Mixed languages are fine. Upload the file in FILES → workspace (see Hermes reads a contract for you).
Our test file, salon-reviews.txt, has 15 reviews of a hair salon, in English and Portuguese. The first ones:
Google reviews - Salão Lúcia, copied 15 Nov 2026
Review 1 - 5 stars
Joana is lovely and my colour came out exactly as I wanted. Very friendly team!
Review 2 - 5 stars
Best haircut I've had in years. Marco really listens. Clean, bright salon.
Review 3 - 4 stars
Great result on my highlights, staff very friendly. I waited 20 minutes past my appointment time though.
Review 4 - 5 stars
Simpatia total da equipa, saí de lá encantada com o corte.
...
2. Ask for the report¶
Say exactly what you want in the report, and the language. In CHAT we wrote:
Open workspace/salon-reviews.txt: 15 Google reviews of my hair salon. Give me the average rating and how many reviews have each number of stars. Then the top 3 things customers praise and the top 3 complaints, each with how many reviews mention it, and 3 concrete improvements we could make. Answer in English. Save it as workspace/reviews-report.md.
Hermes answered in less than a minute:
- The average rating, 4.07 out of 5, and how many reviews have each number of stars.
- What customers praise most: the result of the cut or colour, the friendly team, the clean salon (tied with fair prices).
- What they complain about most: waiting past the appointment time (4 reviews), booking (phone not answered, no online booking: 3 reviews) and prices (2 reviews). Hermes notes that 3 other reviews call the prices fair, so opinion is split.
- Three improvements, each one linked to a complaint: buffer time so appointments start on time, online booking, and clear "from" prices.
The file reviews-report.md in FILES → workspace has the same report with a bit more detail, for example the review numbers for some themes and "Also mentioned once: parking nearby is difficult."
Check that it worked¶
Before asking Hermes, we wrote the 15 reviews ourselves with themes placed on purpose, so we knew the right counts:
| Check | Our answer | Hermes |
|---|---|---|
| Average rating | 4.07 (61 stars ÷ 15) | 4.07 |
| Stars | 5★ 7, 4★ 5, 3★ 1, 2★ 1, 1★ 1 | Same |
| Praise: friendly staff | 8 reviews | 8 |
| Praise: clean salon | 3 reviews | 3 |
| Praise: cut or colour result | 10 clear mentions | 13 (see below) |
| Complaint: waiting | 4 reviews | 4 |
| Complaint: hard to book | 3 reviews | 3 |
| Complaint: expensive | 2 reviews | 2 |
| Parking | 1 review | Mentioned once |
The only difference is the cut or colour result. We counted 10 reviews that clearly praise it. Hermes counted 13: its report lists the men's cut and the "blow-dry lasting three days" among them, short mentions we had not counted. That is a matter of reading, not a mistake in the sums, and the order of the top 3 does not change. Hermes also found a theme we had not planned (fair prices, in 3 reviews), which is really in the text.
To check your own report, ask Hermes for the numbers: "For each praise and complaint, list the review numbers." Then read two or three of those reviews yourself.
Make it yours¶
- Every month: copy the new reviews into the file and schedule the report.
- Compare: "Compare with last month's report: what got better, what got worse?"
- Per staff member: "Which staff members are named in the reviews, and is it good or bad?"
- Answer them: see Recipe: reply to customer reviews.
Common problems¶
The average is wrong
Check that every review in your file has its number of stars, written the same way ("5 stars"). Hermes cannot guess the stars from the text.
The counts look too high or too low
Counting "how many reviews mention it" needs some reading: one person counts "good cut" as praise, another does not. Ask for the review numbers of each theme, as above, and tell Hermes what to count: "Only count clear praise of the result, not 'the cut was fine'."
The report is in the wrong language
Add "Answer in English" (or Portuguese) to the message, as we did. In an earlier test Hermes answered in Portuguese when the message mentioned two languages and did not say which one to use for the answer.