Reviewed records by category
0 of 8 records reviewed. This chart does not count unreviewed suggestions.
Counts represent records, not unique customers. Duplicate candidates remain included. Human choices can differ from rule suggestions.
AI FOR GOOGLE SHEETS / THE WORKFLOW LAB
Messy rows.
Useful answers.
You in control.
Learn to clean feedback, organize it with clear rules and review the results before they become a chart.
12 lessons · 8 practice records · 3 reusable recipes
01 / PREPAREKeep the originalClean text. Spot duplicate candidates.
↓ make the category rules explicit
02 / CLASSIFYPropose, then reviewMeaning is more complicated than a keyword.
↓ count only what you have checked
03 / UNDERSTANDA summary you can explainShow the denominator and what is unresolved.
CLEAN → CLASSIFY → REVIEW → SUMMARIZE
Find the story in eight rows.
Changing policy clears prior suggestions and reviews. Rerunning classification also resets review decisions so they cannot silently apply to changed proposals.
Show the exact rules
Delivery: ship, shipping, delivery, late. Billing: refund, charge, invoice, payment. Product: broken, damaged, size, quality. Matching uses whole English words without case sensitivity. It does not understand negation, synonyms or context. No matching group goes to Review. Cleaning collapses whitespace; duplicate checks compare cleaned text without case sensitivity.
Start by cleaning the text. Original values are preserved.
8Input records
0Reviewed records
8Unresolved records
On a small screen, swipe the table horizontally to reach the review controls.
| ID | Original → cleaned text | Rule suggestion | Your reviewed category |
|---|
Learn the workflow.
TAKE IT INTO YOUR SPREADSHEET
Three recipes. Clear boundaries.
Copy the prompt into an AI feature available to your account and supply only the stated, approved data. This page does not send or execute it.
Which route should I use?
Formulas: exact rules and counts
In a spare column, try =TRIM(B2) for regular spaces. Use =COUNTIF(E2:E9,"Delivery") to count reviewed Delivery labels in E2:E9. Adjust references and separators for your sheet and locale. Keep unresolved rows visible.
Gemini in Sheets: semantic help
Use the AI features available in your account for meaning-based categorization or draft summaries. Availability and controls vary by plan and rollout. Inspect the selected input and review generated content; do not assume every cell or file was included.
Google’s Sheets analysis guide ↗Apps Script + API: repeatable workflows
Use a status column and a capped batch, validate labels before writing, and keep credentials in the server-side project. API access and usage are separate from in-Sheets features. Start with the one-cell assistant before processing many rows.
Open the Apps Script + Gemini lab →Before using real data
Start with a copy and approved sample records. Define categories, missing-data behavior, destination columns and the review owner. Record the input range and denominator beside your summary.