Google Sheets + OpenAI: auto tag review sentiment
You get new reviews, and then the real work starts. Someone has to read them, judge the tone, tag them, and figure out what needs attention before a small issue turns into a public thread.
Marketing managers need quick “pull for social proof” picks. Support leads need early warnings. Product folks want patterns, not anecdotes. This review sentiment tagging automation turns every new row in Google Sheets into a clear Positive, Neutral, or Negative label without you babysitting it.
Below you’ll see how the workflow runs, what it changes day-to-day, and what you need to get it live in n8n.
How This Automation Works
See how this solves the problem:
n8n Workflow Template: Google Sheets + OpenAI: auto tag review sentiment
flowchart LR
subgraph sg0["Google Sheets Flow"]
direction LR
n0@{ icon: "mdi:robot", form: "rounded", label: "Sentiment Analysis", pos: "b", h: 48 }
n1@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
n2@{ icon: "mdi:play-circle", form: "rounded", label: "Google Sheets Trigger", pos: "b", h: 48 }
n3@{ icon: "mdi:database", form: "rounded", label: "Updated Sentiment of Product..", pos: "b", h: 48 }
n1 -.-> n0
n0 --> n3
n2 --> n0
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n2 trigger
class n0 ai
class n1 aiModel
class n3 database
The Challenge: Turning messy reviews into something usable
Reviews arrive one-by-one, but you experience them as a pile. By the time someone opens the spreadsheet, there are 40 new rows and half of them are vague (“it’s fine”), emotionally charged, or written in a hurry. So you skim, you guess the sentiment, and you move on. Then a truly negative review slips through, nobody replies quickly, and your team only notices after the damage is done. Even when nothing explodes, the constant context switching is exhausting. It’s small work, but it never stops.
It adds up fast. Here’s where it breaks down in real teams.
- Someone has to read every review, which becomes a daily “spreadsheet chore” nobody owns.
- Manual tags drift over time, so “Negative” means five different things depending on who labeled it.
- You only spot trends after the fact, because the sheet has raw text but no consistent structure.
- Important reviews don’t get routed anywhere, so support and marketing discover them too late.
The Fix: Auto-tag every new review using OpenAI
This workflow watches your Google Sheet for new review rows and classifies each one the moment it arrives. When a new review is added, n8n grabs the review text, sends it to OpenAI through the built-in OpenAI Chat Model used by the sentiment analysis step, and receives a simple label: Positive, Neutral, or Negative. Then it writes that label back into the “Sentiment” column on the same row. No copy-pasting, no “what did we decide last time?”, no backlog. The end result is still your familiar spreadsheet, just cleaner and instantly sortable, which means you can filter negative reviews in seconds or pull positive ones for campaigns without reading everything.
The workflow starts with a Google Sheets trigger that checks for new rows about every minute. OpenAI analyzes the text using the sentiment analysis step (powered by the OpenAI chat model). Finally, the workflow updates the same spreadsheet row so the sentiment tag lives right next to the original review.
What Changes: Before vs. After
| What This Eliminates | Impact You’ll See |
|---|---|
|
|
Real-World Impact
Say you get around 20 new reviews a day across products. If a teammate spends even 1 minute reading and tagging each one, that’s about 20 minutes daily, plus another 10 minutes later trying to find the “bad ones.” With this workflow, you add the review to Google Sheets as usual and the sentiment tag appears automatically within a minute. You still read the important reviews, but you stop reading the unimportant ones just to label them.
Requirements
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets to store reviews and the Sentiment column.
- OpenAI to classify each review’s sentiment.
- OpenAI API key (get it from the OpenAI dashboard)
Skill level: Beginner. You’ll connect accounts, select the right sheet, and test with a few sample reviews.
Need help implementing this? Talk to an automation expert (free 15-minute consultation).
The Workflow Flow
A new row hits your Google Sheet. The Google Sheets Trigger watches for fresh reviews (about once per minute), so you don’t need a form, webhook, or extra tooling to get started.
The review text gets packaged for analysis. The workflow pulls the “Review” cell from the new row and prepares it for the sentiment checker. Small detail, big difference: when your column headers are consistent, the whole thing stays reliable.
OpenAI labels it as Positive, Neutral, or Negative. The sentiment analysis step uses an OpenAI Chat Model (like GPT-4o-mini or GPT-3.5) to classify the text. It’s fast, and it’s consistent in a way humans aren’t on a busy day.
The label is written back to the sheet. n8n updates the same row by filling the “Sentiment” column, so your spreadsheet becomes filterable instantly and can feed dashboards later (including Airtable or Excel 365 if you want).
You can easily modify the sentiment categories to include things like “Mixed” or “Refund risk” based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Sheet Update Trigger
This trigger watches your Google Sheet and starts the workflow when new or updated rows are detected.
- Add the Sheet Update Trigger node and open its settings.
- Set Document to
[YOUR_ID]and select the spreadsheet namedReview. - Set Sheet Name to
Sheet1(valuegid=0). - Set the polling interval to
everyMinute. - Credential Required: Connect your googleSheetsTriggerOAuth2Api credentials.
Step 2: Connect Google Sheets
This step ensures the workflow can write sentiment results back to your sheet.
- Add the Update Review Sentiment node.
- Set Operation to
update. - Set Document to
[YOUR_ID]and select the spreadsheet namedReview. - Set Sheet Name to
Sheet1(valuegid=0). - Credential Required: Connect your googleSheetsOAuth2Api credentials.
Step 3: Set Up Review Sentiment Check
This node analyzes each review’s sentiment using the connected language model.
- Add the Review Sentiment Check node and place it after Sheet Update Trigger.
- Set Input Text to
={{ $json.Review }}. - Ensure OpenAI Chat Engine is connected as the language model for Review Sentiment Check (AI Language Model connection).
- Credential Required: Connect your openAiApi credentials on OpenAI Chat Engine (credentials are added to the parent model node, not the sentiment node).
Step 4: Configure Update Review Sentiment
This step writes the sentiment category back to the sheet, matched by the review text.
- In Update Review Sentiment, map Review to
={{ $json.Review }}. - Map Sentiment to
={{ $json.sentimentAnalysis.category }}. - Set Matching Columns to
Reviewto update the correct row. - Connect the flow: Sheet Update Trigger → Review Sentiment Check → Update Review Sentiment.
Step 5: Test and Activate Your Workflow
Validate the end-to-end flow, then enable it for continuous updates.
- Click Execute Workflow and add or edit a row in your
Reviewsheet. - Confirm Review Sentiment Check outputs a category in
sentimentAnalysis.category. - Verify Update Review Sentiment writes the sentiment to the Sentiment column.
- Toggle the workflow to Active so it runs automatically every minute.
Watch Out For
- Google Sheets credentials can expire or need specific permissions. If things break, check the Google connection inside n8n Credentials first, then re-auth.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.
Common Questions
Usually in about 30 minutes if your sheet and accounts are ready.
Yes. No code is required, but someone needs to connect Google Sheets and paste in an OpenAI API key.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs (often just a few dollars a month for typical review volumes).
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
You can tweak the behavior in the Review Sentiment Check step so it returns more than three labels (for example “Mixed” or “Refund risk”). If you prefer a different model, swap it in the OpenAI Chat Engine configuration. Common customizations include sending a Gmail alert on Negative, writing a daily summary to Airtable, or adding a second column that tags the topic (shipping, quality, pricing).
Most of the time it’s an expired OAuth session in n8n. Reconnect your Google Sheets credentials, then confirm the workflow still points to the right spreadsheet and worksheet. If only the update step fails, check that the “Sentiment” column header matches exactly and that the workflow has permission to edit the file.
Plenty for most small teams: it processes one new row at a time and runs every minute by default. On n8n Cloud, capacity depends on your plan’s monthly executions; if you self-host, there’s no fixed execution cap, it mainly depends on your server and OpenAI rate limits. If you’re adding hundreds of reviews an hour, consider batching (Split in Batches) so the sheet updates stay reliable.
Often, yes, because n8n is easier to extend when you want logic like “only alert on Negative” plus daily rollups and custom categories. You also get self-hosting, which is handy when executions grow. Zapier and Make can still be fine for a simple “Sheets in → tag out” setup, but costs usually climb once you add branching and AI steps. If you’re unsure, run this workflow as-is for a week, then decide what else you want it to do. Talk to an automation expert and we’ll help you pick the right approach.
Once sentiment tagging is automatic, reviews stop being noise and start being signals. Set it up, let it run, and spend your attention where it actually matters.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
