AI automate UX feedback: Sentiment & emotion analysis in Google Sheets + OpenAI
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets and OpenAI.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Fetch Allowed Tags (Google Sheets): uses Google Sheets
- Fetch New Feedbacks (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Attach Tags Array (Edit Fields (Set)): sets or maps fields
- Process Feedbacks in Batches (Loop Over Items (Split in Batches)): loops over the items in batches
- Aggregate Batch Items (Code): runs custom JavaScript code
- Tag Feedbacks with AI (OpenAI): uses OpenAI
- Split Batch Results (Code): runs custom JavaScript code
- Update Google Sheet (Tagged) (Google Sheets): update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - OpenAI
@n8n/n8n-nodes-langchain.openAi - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Who's it for Product managers, customer success teams, and UX researchers who collect feedback in Google Sheets and want to automatically categorize and analyze it with sentiment and emotions insights. Ideal for teams processing dozens or hundreds of customer…