Tag 1,000 support tickets by hand, or drag one cell.
Free text in, a fixed category out, with a small model that makes tokens go a long way.
fx=AITEXT("Classify into one of Billing, Bug, Feature, Other. Reply with the word only: " & A2)
| Ticket | Formula | |
|---|---|---|
| 2 | Charged twice this month | =AITEXT("Classify into one of Billing, Bug, Feature, Other. Reply with the word only: " & A2) |
| 3 | Export button does nothing | =AITEXT("Classify into one of Billing, Bug, Feature, Other. Reply with the word only: " & A3) |
| 4 | Can we get dark mode? | =AITEXT("Classify into one of Billing, Bug, Feature, Other. Reply with the word only: " & A4) |
| 5 | How do I add a seat? | =AITEXT("Classify into one of Billing, Bug, Feature, Other. Reply with the word only: " & A5) |
| 6 | Invoice shows wrong VAT | =AITEXT("Classify into one of Billing, Bug, Feature, Other. Reply with the word only: " & A6) |
| category |
|---|
| Billing |
| Bug |
| Feature |
| Other |
| Billing |
Example output for illustration, not a live result.
1,000 tickets. About 5 hours by hand, or one formula dragged down.
How AITEXT() works.
Where it runs
This is generative AI, not scraping. AITEXT sends your prompt and any cell references to the model you have picked in the sidebar and writes the reply straight into the cell. Nothing is written to a new tab.
Where the data comes from
Nothing is fetched from the web. The category comes from the AI model you have picked in the sidebar, reading only the ticket text you reference.
Spends AI tokens, not integration credits. A smaller model such as Claude Haiku or GPT-4o mini covers a job like this for a fraction of the tokens a larger model would use.
Two ways to do it.
Formula
Every formula works on Free.
1. Paste the formula
Put your ticket values in column A and paste =AITEXT("Classify into one of Billing, Bug, Feature, Other. Reply with the word only: " & A2) into B2.
2. Drag it down
Drag the AITEXT cell down the column. Every row runs on its own.
3. Read the results
Results fill in beside the formula, one row per input.
Chat
Chat Agent is on Solo, Team and Business plans.
1. Type the job
“Dedupe column A and tag each ticket as Billing, Bug, Feature or Other”
2. The agent writes the sheet
Removed 63 duplicates and tagged 937 tickets in column B.
Month four.
Tickets keep coming. Paste the new ones under the old ones.
| ticket | category | Run |
|---|---|---|
| Refund not processed after 10 days | Billing | New |
| Add support for GET requests | Feature | New |
What re-running the same formula next month adds or changes. Example output for illustration, not a live result.
Turn on Keep Formula in the sidebar and the column stays live for the rows you add next week.
Formulas for this job.
=AITEXT("Write a product description for: " & A1)Generate AI text from any prompt, supports every model and optional real-time web search
=AILIST("10 blog topics about coffee")AI-generated list that spills down rows
=AITRANSLATE(A1, "Spanish")Translate cell content into any language
Not sure it fits your job? Ask.
Describe the task in plain English. In about ten seconds you get a straight answer, yes, partially or not a fit, plus the exact formulas or Chat Agent prompt to run. No signup, no card.
Already sure?
Installs from the Google Workspace Marketplace in under a minute. Every formula works on the free allowance.
Install free for Google Sheets