Workflow template for customer support and service

Customer review themes summary

Once a month the owner or marketing lead gets one summary of the month's public reviews: counts by site and rating that tie to the export, recurring themes with their review IDs and a quoted line, unanswered reviews oldest first, and the reviews a named person must see first. It drafts no reply.

View this template on GitHub

Put this on your planBuild this in a sprint

Add it to a workflow in the FullyPowered Planner, beside the teams and roles that will run it. Book a fit call

The outcome

Every review the business received last month is read, counted and placed, and the whole picture fits on one page. The counts by site and by star rating add up to the export, and a check line at the top proves it. What reviewers keep coming back to is grouped into themes, praise and criticism alike, each with the review IDs behind it and one short line in a reviewer's own words, so anyone can open the export and see the evidence.

If last month's summary is supplied, each site's count and average rating sit beside last month's, and each theme shows last month's count beside this month's, or that it is new or no longer seen. The customer service lead gets the list of reviews still waiting for an answer, oldest first, with how many days each has waited.

Some reviews should never wait in a monthly queue. A review that reports a safety problem, an illness, discrimination or a legal threat is lifted out and set apart for the person you name, before anyone replies to it. Reviewers appear only by their initials, and a member of staff named in a review appears only in a separate note for the manager, never in the summary itself. Nobody is scored or ranked.

Who starts the work, and when

The owner, the customer service lead or the marketing lead runs it in the first working days of each month, once the reviews export for the month is complete. The person who runs it reads the summary, passes the set-apart reviews to the named person the same day, gives the no-reply list to whoever answers reviews, and hands the manager's note to the manager alone.

The workflow template prepares the summary. It drafts no reply and posts nothing, reports no review to any site, never says whether a review is genuine, and never suggests asking a site to remove one. It needs no connection to any review site or platform.

What they supply

  • The reviews export from your reviews and reputation platform, one row per review, with these columns: review ID, date, site, rating, reviewer name, text, replied (yes or no), reply date, and location or product. The workflow template lists the default column headers; if one of yours does not match, it stops and asks which column is which before reading a row.
  • The period the summary covers.
  • Your theme list, if you keep one: the things you care about hearing, such as waiting times, product quality or prices. Without one, the workflow template names the themes itself.
  • Who replies to reviews, who decides on the reviews set apart, and which manager receives the note on staff named in reviews.
  • Last month's summary, if you want the comparison.

What comes out

One summary in a fixed order:

  1. Counts by site and rating, with the average for each site and for all sites, and a check line that ties every count to the export.
  2. Set apart for the named person. Reviews that report safety, illness, discrimination or a legal threat, each described plainly with no names, and kept out of the themes.
  3. Themes. Each with whether reviewers praise it, criticise it or both, the review IDs, the shops or products concerned, last month's count, and one short quoted line.
  4. Reviews in no theme, so nothing read is lost.
  5. What changed since last month, site by site.
  6. No reply yet, oldest first, with the reviewer's initials and the days waiting.
  7. Questions a person needs to settle, such as a review marked as answered with no reply date.

After the closing line comes the manager's note: each review that names a member of staff, with its ID, site and date and the name as written, and nothing else. It is cut off before the summary is shared. A section with nothing in it says "None."

An example

Illustrative example with sample data. Bakery A is an illustrative bakery and café with two shops, the North shop and the South shop. Its reviews appear on two public review sites, called Site A and Site B here. The reviewers, the staff, the reviews and every number below are illustrative. On Tuesday 3 November 2026 the marketing lead runs the workflow template on October's reviews.

The inputs come first, in full, so the workflow template can be run on them. The summary follows.

The inputs

The settings

Period: 1 October 2026 to 31 October 2026. Prepared: 3 November 2026.
Report reader: marketing lead.
Replies to reviews: customer service lead.
Named person for reviews set apart: owner.
Manager's note goes to: general manager.
Theme minimum: the default. Column mapping: none; the export uses the
default headers.

Our theme list

Queue and wait time
Bread and pastry quality
Coffee
Staff friendliness
Prices

Last period's summary (September 2026)

Site A: 9 reviews, average 4.1
Site B: 6 reviews, average 4.5
All sites: 15 reviews, average 4.3
Themes (reviews): Bread and pastry quality 6; Coffee 3; Queue and wait
time 2; Staff friendliness 2; Seating 2

The reviews export from your reviews and reputation platform

One row per review, with the default columns: review ID, date, site, rating, reviewer name, text, replied (yes or no), reply date, and location or product.

review_id,date,site,rating,reviewer_name,text,replied,reply_date,location_or_product
R-201,2026-09-30,Site A,5,Dana Whitlow,"Best sourdough in town.",yes,2026-10-01,North shop
R-202,2026-10-02,Site A,2,Marcus Ode,"Waited twenty minutes in the queue on Saturday morning for two coffees. Pastries were good once we got them.",no,,North shop
R-203,2026-10-03,Site B,5,Priya Lomas,"The almond croissant is the best I've had anywhere. Flaky and not too sweet.",yes,2026-10-05,South shop
R-204,2026-10-04,Site A,4,Tom Brennick,"Lovely bread, but the queue went out the door and only one till was open.",yes,2026-10-06,North shop
R-205,2026-10-06,Site B,1,Helen Q.,"My son has a nut allergy. We asked twice and were told the muffin had no nuts. He reacted within minutes and we had to use his pen. Nobody should go through that.",no,,South shop
R-206,2026-10-08,Site A,5,Sam Ferro,"Ellie at the counter remembered my order from last week. Coffee was perfect.",yes,2026-10-09,North shop
R-207,2026-10-09,Site A,3,Grace Allard,"Coffee was lukewarm and the flat white tasted burnt. Asked Josh to remake it and he just shrugged.",no,,North shop
R-208,2026-10-11,Site B,4,Owen Tasker,"Great rye loaf. A bit pricey for the size though.",yes,2026-10-12,South shop
R-209,2026-10-12,Site A,2,Lena Marsh,"Forty minutes for a table and nobody told us how long it would be.",no,,North shop
R-210,2026-10-14,Site B,5,Rafael Dunn,"Friendly team, warm welcome every time.",no,,North shop
R-211,2026-10-15,Site A,1,Corinne Vale,"The staff member at the till refused to serve my friend because of her headscarf and laughed about it. I will be taking this further.",no,,North shop
R-212,2026-10-17,Site B,3,Jon Petrakis,"Nearly five for a slice of cake is too much. Croissant was great though.",yes,2026-10-18,South shop
R-213,2026-10-19,Site A,4,Ama Kesh,"Great pastries. Coffee was cold by the time it reached the table.",yes,,North shop
R-214,2026-10-21,Site B,3,Ben Hollis,"Parking near the shop is impossible on weekdays.",no,,South shop
R-215,2026-10-23,Site A,1,Nadia Fenn,"Ate the chicken sandwich at lunch and was sick all night. Two of us had it and both were ill.",no,,North shop
R-216,2026-10-25,Site B,5,Ivo Brandt,"Sourdough and a cortado every Sunday. Never disappoints.",yes,2026-10-26,North shop
R-217,2026-10-27,Site A,2,Kit Morrow,"Queue was so long we gave up and left.",no,,North shop
R-218,2026-10-28,Site B,4,Mei Laurent,"Pricey, but the cinnamon bun is worth it.",no,,South shop
R-219,2026-10-30,Site A,5,,"Lovely staff and the best croissants around.",yes,2026-10-31,North shop
R-220,2026-10-31,Site B,1,Paul Grieve,"Charged twice for one order. If my refund isn't sorted this week you'll be hearing from my lawyer.",no,,South shop

The output

The summary is plain text, exactly as the workflow template sets it out. The manager's note follows the closing line, so the marketing lead can cut it off and pass it to the general manager alone.

CUSTOMER REVIEW THEMES SUMMARY: 1 October 2026 to 31 October 2026

For: marketing lead. Prepared 3 November 2026. Period 1 October 2026 to 31 October 2026.
Rows in the export: 20. Outside the period, left out: 1 (R-201).
Reviews in the period: 19. Set apart: 4. In at least one theme: 14. Not in a theme: 1.
Theme list: supplied. Last period: September 2026.

COUNTS BY SITE AND RATING

Site A | 5 stars 2 | 4 stars 2 | 3 stars 1 | 2 stars 3 | 1 star 2 | No rating 0 | Total 10 | Average 2.9
Site B | 5 stars 3 | 4 stars 2 | 3 stars 2 | 2 stars 0 | 1 star 2 | No rating 0 | Total 9 | Average 3.4
All sites | 5 stars 5 | 4 stars 4 | 3 stars 3 | 2 stars 3 | 1 star 4 | No rating 0 | Total 19 | Average 3.2
Check: 1 + 19 = 20. Site totals 10 + 9 = 19. Ratings 5 + 4 + 3 + 3 + 4 + no rating 0 = 19. Set apart 4 + in a theme 14 + not in a theme 1 = 19.

SET APART FOR OWNER

R-205 (Site B, 2026-10-06, 1 of 5): says a child with a nut allergy reacted within minutes after the family was told a muffin had no nuts.
- Matter: safety
- Replied: no

R-211 (Site A, 2026-10-15, 1 of 5): says a member of staff at the till refused to serve the reviewer's friend because of her headscarf.
- Matter: discrimination
- Replied: no

R-215 (Site A, 2026-10-23, 1 of 5): says two people were ill overnight after eating the chicken sandwich.
- Matter: illness
- Replied: no

R-220 (Site B, 2026-10-31, 1 of 5): says the reviewer was charged twice for one order and mentions a lawyer if the refund is not sorted.
- Matter: legal threat
- Replied: no

THEMES

1. Bread and pastry quality | Praised | Reviews 9: R-202, R-203, R-204, R-208, R-212, R-213, R-216, R-218, R-219 | Last period: 6
- Locations: North shop 5, South shop 4
- In their words: "Pastries were good once we got them." (R-202, Site A, 2 of 5)

2. Queue and wait time | Criticised | Reviews 4: R-202, R-204, R-209, R-217 | Last period: 2
- Locations: North shop 4
- In their words: "Waited twenty minutes in the queue on Saturday morning for two coffees." (R-202, Site A, 2 of 5)

3. Coffee | Mixed | Reviews 4: R-206, R-207, R-213, R-216 | Last period: 3
- Locations: North shop 4
- In their words: "Coffee was lukewarm and the flat white tasted burnt." (R-207, Site A, 3 of 5)

4. Staff friendliness | Mixed | Reviews 4: R-206, R-207, R-210, R-219 | Last period: 2
- Locations: North shop 4
- In their words: "[staff member] at the counter remembered my order from last week." (R-206, Site A, 5 of 5)

5. Prices | Criticised | Reviews 3: R-208, R-212, R-218 | Last period: new
- Locations: South shop 3
- In their words: "A bit pricey for the size though." (R-208, Site B, 4 of 5)

Themes on your list with no review this period: None.
Last period's themes not seen this period: Seating (2 last period).

NOT IN A THEME

R-214

WHAT CHANGED SINCE LAST PERIOD

Site A: reviews 10 (last period 9); average 2.9 (last period 4.1).
Site B: reviews 9 (last period 6); average 3.4 (last period 4.5).
All sites: reviews 19 (last period 15); average 3.2 (last period 4.3).

NO REPLY YET, OLDEST FIRST (for customer service lead)

R-202 | 2026-10-02 | Site A | 2 of 5 | M.O. | waiting 32 days
R-205 | 2026-10-06 | Site B | 1 of 5 | H.Q. | waiting 28 days | set apart: reply waits for owner
R-207 | 2026-10-09 | Site A | 3 of 5 | G.A. | waiting 25 days
R-209 | 2026-10-12 | Site A | 2 of 5 | L.M. | waiting 22 days
R-210 | 2026-10-14 | Site B | 5 of 5 | R.D. | waiting 20 days
R-211 | 2026-10-15 | Site A | 1 of 5 | C.V. | waiting 19 days | set apart: reply waits for owner
R-214 | 2026-10-21 | Site B | 3 of 5 | B.H. | waiting 13 days
R-215 | 2026-10-23 | Site A | 1 of 5 | N.F. | waiting 11 days | set apart: reply waits for owner
R-217 | 2026-10-27 | Site A | 2 of 5 | K.M. | waiting 7 days
R-218 | 2026-10-28 | Site B | 4 of 5 | M.L. | waiting 6 days
R-220 | 2026-10-31 | Site B | 1 of 5 | P.G. | waiting 3 days | set apart: reply waits for owner

QUESTIONS

1. R-213 is marked as replied but has no reply date. Was the reply posted, and on what date?

Prepared for marketing lead. No reply has been drafted or posted, no review has been reported, and nothing has been changed.

MANAGER'S NOTE: STAFF NAMED IN REVIEWS (for general manager only; not part of the summary)

R-206 (Site A, 2026-10-08): names "Ellie".
R-207 (Site A, 2026-10-09): names "Josh".

How the figures add up: the export holds 20 rows; R-201 is dated 30 September and is left out, leaving 19 reviews, 10 on Site A and 9 on Site B. Site A's ratings add to 29 over 10 reviews, an average of 2.9; Site B's add to 31 over 9, which is 3.44 and shows as 3.4; all sites add to 60 over 19, which is 3.16 and shows as 3.2. Four reviews are set apart and sit in no theme, R-214 is the only review about parking and so falls below the theme minimum of two, and the other 14 sit in at least one theme. The five themes hold 24 places because ten reviews each speak about two things and sit in two themes (R-202, R-204, R-206, R-207, R-208, R-212, R-213, R-216, R-218 and R-219), while R-203, R-209, R-210 and R-217 sit in one each: 20 + 4 = 24. Coffee is Mixed with two reviews praising it (R-206, R-216) and two criticising it (R-207, R-213), so its line comes from the earliest criticising review. Days waiting are counted from each review's date to 3 November 2026. No reply was drafted, and no review was reported to either site.

Where it fits

  • Customer support and service, which answers reviews and needs to know which have waited longest and which must not be answered before someone senior decides.
  • Marketing and content, where public reviews are part of how the business is seen and the themes feed what it says about itself.
  • Hospitality, where cafés, restaurants and hotels collect reviews every day on several public sites.
  • E-commerce and retail, where reviews of each shop and product pile up faster than anyone reads them.
  • Consumer brands, where reviews show how a product is received, product by product, month by month.
  • Established businesses, with years of reviews and nobody who counts them the same way each month.
  • Growth & scaling, when a second shop or a new site doubles the reviews and the owner can no longer read them all.

It sits beside customer feedback themes, which reads tickets, disputes, surveys and reviews together and proposes fixes, and public guest review reply, which drafts the answer to a single guest review for a manager to approve. This one counts and groups the reviews and leaves every reply to a person.

What has to change for your company

Match the column headers to your export once, and give each review site a plain label. Write down your theme list in your own words, in the order that matters to you. Name who reads the summary, who replies to reviews, who decides on reviews that are set apart, and which manager receives the note on staff. Add any matter you want set apart beyond the four the workflow template already looks for. Decide where the summary is kept, and how the manager's note reaches the manager and nobody else. It runs in your AI assistant from the export you supply.

What has been checked

FullyPowered AI wrote this workflow template. It was editorially reviewed on 19 November 2026. It was tried on its example on 19 November 2026 in one run, published with it. Edits after that run, which settled a few judgment points in the instructions, have not been run again. It has not yet been tested in a client environment or as a packaged version in ChatGPT, Claude, Copilot or Gemini.

Testing in your environment means running it on a past month whose reviews your team remembers well, with hard cases written in advance: a review that mentions a lawyer, one that names a member of staff, a column header the workflow template does not know, a review marked answered with no reply date. The person who runs it checks every count against the export before anyone relies on it. Pilot acceptance-test preparation sets those cases up.

Who decides

People decide

Your people keep

  • How each set-apart review is handled
  • Every reply to a review
By design

It does not

  • Drafts no reply
  • Posts nothing
  • Reports no review to any site
  • Never says whether a review is genuine
  • Never suggests asking a site to remove a review

Questions people ask

Who is this for?

The owner, the customer service lead or the marketing lead runs it in the first working days of each month, once the reviews export for the month is complete.

What do I need to supply?

The reviews export from your reviews and reputation platform, the period, your theme list if you keep one, who replies to reviews, and last month's summary if you want the comparison.

Does it reply to reviews or say which are fake?

No. It drafts no reply and posts nothing, reports no review to any site, never says whether a review is genuine, and never suggests asking a site to remove one.

How does it treat names?

Reviewers appear only by their initials. A member of staff named in a review appears only in a separate note for the manager, never in the summary itself. Nobody is scored or ranked.

What has been checked?

It was editorially reviewed and tried once on an example. It has not yet been tested in a client environment.

What it connects to

The business systems this workflow template works with, what it reads from each and what it writes to it, from a reviewed reading of its own text.

Writes to it: nothing.

What it connects to
How it works with the systemReads from it
Works from an export from a review and reputation management platform.Reads from itEach review with site, rating, text and whether it was replied to.

The full workflow template

Everything above is the outline. The complete workflow template is the working version: the roles, the inputs, the procedure, the exceptions and stop conditions, the output format, the reviewer checklist, the acceptance tests, the instructions for an AI assistant and what to customize for your company. It comes with a download and the link to its folder in FullyPowered’s public repository.

View the full template

Free with an account. Sign in by email: no password and no card.

Next step

Put this workflow template to work for your team: on your plan, or built with you in a sprint.

  1. 01

    The full workflow template

    Free with an account. Sign in by email: no password and no card.

  2. 02

    FullyPowered Planner

    Add it to a workflow in the FullyPowered Planner, beside the teams and roles that will run it.

  3. 03

    Build this in a sprint

    In a sprint, FullyPowered adapts this workflow template to your rules, proves it on your own work and puts it in the hands of the roles that own it.

These workflow templates are examples and a starting point, not a complete list. We can build any workflow for your company, including one that runs several steps, in a Workflow Sprint or a scoped implementation.

Rather talk it through first? Book a fit callDiscuss adapting this

FullyPowered Planner. A card to start, everything unlocked, nothing charged for seven days.Security & your informationPlanner termsRefunds