Customer feedback pours in from everywhere. Email replies, product reviews, social media comments, support tickets. Most of it sits in one inbox, untagged and unsorted. You read the angry ones first and miss the pattern in the compliments.
A feedback tag system fixes this. Every piece of feedback gets categorised by sentiment (positive, neutral, negative) and topic (shipping, product quality, pricing, customer service, delivery). In under an hour, you can build this without a plugin, a CRM, or a developer.
What You Need
- A Google Sheet (free)
- A simple form (Google Forms or Typeform free tier)
- 30 minutes to set up categories
- 15 minutes to build a summary dashboard
Step 1: Create Your Feedback Form
Start with a Google Form. Keep it short. Five fields maximum.
- Feedback text (paragraph field) – the actual message
- Source (dropdown) – Email, Review, Social Media, Support Ticket, Other
- Sentiment (dropdown) – Positive, Neutral, Negative
- Topic (dropdown) – Shipping, Product Quality, Pricing, Customer Service, Delivery, Packaging, Website Experience, Other
- Date (date field) – when the feedback was received
Connect the form to a Google Sheet. Every submission auto-populates a row. You can also manually paste feedback from reviews and social media into the sheet.
Step 2: Set Up Auto-Tagging With a Formula
This is where the magic happens. Add two helper columns to your sheet:
Column G: Auto Sentiment
Paste this formula in G2:
=IF(C2="","",IF(REGEXMATCH(LOWER(B2),"love|amazing|perfect|great|excellent|happy|recommend|best|beautiful"),"Positive",IF(REGEXMATCH(LOWER(B2),"terrible|awful|broken|disappointed|angry|worst|refund|hate|poor"),"Negative","Neutral")))
Column H: Auto Topic
Paste this formula in H2:
=IF(D2="","",IF(REGEXMATCH(LOWER(B2),"shipping|delivery|courier|postage|arrived|dispatch"),"Shipping",IF(REGEXMATCH(LOWER(B2),"quality|material|defective|broken|damaged|faulty"),"Product Quality",IF(REGEXMATCH(LOWER(B2),"price|expensive|cheap|cost|value|worth"),"Pricing",IF(REGEXMATCH(LOWER(B2),"support|service|reply|response|help|rude"),"Customer Service","Other"))))
These formulas scan the feedback text for keywords and auto-assign sentiment and topic. They are not perfect, but they catch 80% of feedback correctly. You can refine the keyword lists over time.
Step 3: Build a Summary Dashboard
Create a second tab in your sheet called Dashboard. Add a pivot table that counts feedback by sentiment and topic.
Rows: Topic
Columns: Sentiment
Values: Count of Topic
This gives you a grid that shows, at a glance, where your problems and strengths are. If Shipping has 12 negative tags and 2 positive ones, you know where to focus this week.
Add a second pivot table with Date as rows and Sentiment as columns. This shows your sentiment trend over time. If negative feedback is trending up week over week, you catch it before it becomes a public problem.
Step 4: Set Up a Weekly Review
Pick one day a week to review the dashboard. Friday afternoon works well. Spend 10 minutes looking at:
- Which topics have the most negative feedback this week
- Whether negative sentiment is trending up or down
- Which positive comments could become testimonials or social proof
- Any recurring keywords in the Other category that deserve their own tag
Write one action item per week based on the data. Not five. One. Fix the thing that generated the most negative feedback. Next week, check if it worked.
Step 5: Refine Your Keywords Monthly
After 30 days, you will have enough data to see where the auto-tagging misses. Common patterns:
- Sarcasm (“Oh great, another broken item”) gets tagged as positive because of the word “great”
- Shipping complaints that mention “slow” but not “shipping” get missed
- Product quality issues that say “fell apart” instead of “broken” get missed
Add these keywords to your REGEXMATCH formulas. Each refinement makes the system smarter. After 3 months, your auto-tagging accuracy will be above 90%.
What This System Replaces
This replaces paid tools like Zendesk, Intercom, or dedicated feedback platforms that charge per seat. For a small store doing 50 to 200 orders a month, a Google Sheet with smart formulas is enough. You upgrade when you hit 500+ feedback items per month and need AI-powered sentiment analysis.
When to Upgrade
If you are spending more than 30 minutes a week manually correcting tags, it is time to upgrade. Tools like Klaviyo’s sentiment analysis, or even feeding your sheet into ChatGPT for batch classification, handle volume better than formulas. But start simple. The sheet teaches you what categories matter for your business before you pay for a tool that guesses.
Want more like this? Join MOKU Club for free. Weekly resources, early access to new guides, and occasional templates you can actually use. Join below.
