Sheets =AI Function: Tag Each Row With One Category and a Sentiment

5 Views
0 Uses

Prompt

ChatGPT
Claude
Grok
OpenRouter
(In Google Sheets, enter the formula below in the first empty cell next to your data, then fill it down. Select the filled cells and click Generate and Insert. Check a sample of rows before you rely on the column. Google says "only the first 350 selected cells with AI functions will be generated", so for a longer column, select and generate up to 350 cells at a time; check Google's page for the current limit.)

=AI("You are sorting {{ITEM_TYPE}} for {{PURPOSE}}. Classify the text in the given cell into exactly one of these categories: {{CATEGORY_LIST}}. If more than one fits, choose the one the text spends the most words on. If none fits, use Other. Also give its sentiment as Positive, Neutral or Negative. If the cell is empty, output Blank. Output only the category and the sentiment, separated by a comma, with no other words.", {{FIRST_CELL}})

Customize this prompt

Fill in the variables below to personalize this prompt:

ChatGPT
Claude
Grok
OpenRouter

Report this prompt

Model Settings

Recommended Models

Gemini

Temperature

0.7

Max Tokens

2000

Additional Notes

Best for: Tagging a column of comments or tickets, 350 cells per pass

About this prompt

“Sheets =AI Function: Tag Each Row With One Category and a Sentiment” is a free prompt for Gemini in the Business category, 148 words long, added to The Prompt Index on November 18, 2026 by The Prompt Index. Copy it with the button above, paste it into Gemini or any other AI chat assistant, and send it.

It has 4 placeholders to fill in first: {{ITEM_TYPE}}, {{PURPOSE}}, {{CATEGORY_LIST}}, {{FIRST_CELL}}. Use the “Customize this prompt” fields to personalise it before you copy.

Recommended models: Gemini.

0 upvotes, sent to an AI tool 0 times, viewed 5 times.

Browse all Business prompts, the AI prompt database or use the AI prompt finder to search every prompt.