AutomationMart
Home/Browse/AI automate UX feedback: Sentiment & emotion analysis in Google Sheets + OpenAI
n8n

AI automate UX feedback: Sentiment & emotion analysis in Google Sheets + OpenAI

n8nn8n11 modulesv1.0
SlackNotionAirtableGoogle SheetsOpenAI

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 comments daily. - [Read on Medium](

At a glance

AI automate UX feedback: Sentiment & emotion analysis in Google Sheets + OpenAI is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Slack, Notion, Airtable, Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Slack, Notion, Airtable, Google Sheets, OpenAI
Modules
11
Price
Free
Version
v1.0
AI automate UX feedback: Sentiment & emotion analysis in Google Sheets + OpenAI workflow diagram

About this workflow

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 comments daily. - Read on Medium - Watch on Youtube What it does This workflow automatically tags and analyzes customer feedback stored in Google Sheets using OpenAI's GPT-4. It reads unprocessed feedback entries, sends them in batches to OpenAI for intelligent tagging and sentiment analysis, then writes the results back to your sheet—complete with up to 3 relevant tags per feedback, sentiment scores (Very Negative to Very Positive), and emotional analysis. The workflow uses batch processing to optimize API costs: instead of sending 10 separate requests, it sends one request with all 10 feedbacks, reducing API calls by 90%. How it works 1. Fetches allowed tags from a Tags sheet and new feedback entries (where Status is empty) from a Feedbacks sheet 2. Merges tags with feedbacks and processes them in batches of 10 3. Sends each batch to OpenAI with a structured prompt requesting tags, sentiment, and emotional analysis 4. Writes results back to Google Sheets with tags, sentiment, emotions, and timestamps Requirements - Google Sheets account with OAuth2 credentials - OpenAI API account (uses GPT-4o-mini model) - Google Sheet template with two sheets: "Tags" (single column) and "Feedbacks" (with columns: Feedbacks, Status, Tag 1-3, Sentiment, Primary/Secondary Emotion, AI Tag 1-2, Updated Date) Setup instructions 1. Duplicate the provided Google Sheet template 2. Connect your credentials in n8n: - Google Sheets OAuth2 API - OpenAI API 3. Update Sheet URLs in these nodes: - "Fetch Allowed Tags" - point to your Tags sheet - "Fetch New Feedbacks" - point to your Feedbacks sheet - "Update Google Sheet (Tagged)" - point to your Feedbacks sheet 4. Test manually first using the Manual Trigger, then enable the Schedule Trigger for automatic processing every 60 minutes How to customize - Adjust batch size: Change the batch size in "Process Feedbacks in Batches" (default: 10) to process more or fewer feedbacks per API call - Modify tagging logic: Edit the system prompt in "Tag Feedbacks with AI" to change how tags are selected or add custom sentiment categories - Change schedule: Update the Schedule Trigger interval (default: 60 minutes) based on your feedback volume - Extend the workflow: Add nodes to send results to Slack, Notion, or Airtable for real-time alerts on negative feedback

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Create personalized B2B outreach emails with Tavily Research & OpenRouter LLM

About this workflow This workflow automatically generates personalized B2B outreach email messages by combining AI-based company research and text generation. It’s designed to help sales and marketing professionals automate the creation of tailored cold emails for prospects. --- ⚙️ How it works 1. Get rows from Google Sheets — Retrieves companies marked as “ready” for outreach. 2. Loop Over Items — Processes each company individually. 3. Company Research (LangChain Agen

Free

Send new articles to Telegram as a photo with ChatGPT

Automatically send new RSS articles to Telegram as a photo with ChatGPT. Convert HTML to text, generate an image, and share via Telegram.

Free

Save a Gmail email containing a specific phrase to Google Sheets as a new row

Use this template to save a Gmail message containing a specific phrase to your Google Sheets spreadsheet as a new row.

Free

WhatsApp group onboarding with automated welcome messages & Airtable point system

Receive Webhook Notification The workflow starts when a webhook receives a POST request from Whapi, notifying that a new participant has joined a WhatsApp group. Filter the Event The workflow checks two conditions: The event is for the correct WhatsApp group (matching the specific group ID). The action type is "add" (meaning a user was added to the group). Send Welcome Message If both conditions are met, the workflow sends a personalized welcome message to the new participant via Whapi. The mess

Free

Automated SEO keyword & SERP analysis with DataForSEO for high-converting content

Overall Purpose: The workflow automates the process of gathering extensive keyword data for a "Main Keyword." It starts by reading initial parameters from a Google Sheets template, creates a new dedicated Google Sheet for the research, queries multiple DataForSEO API endpoints for different types of keyword information (related, suggestions, ideas, autocomplete, subtopics, SERP, and PAA), and populates the newly created Google Sheet with this data across various tabs. A "Master All KW Variations

Free

Send custom email notifications to ChatGPT and log results in Google Sheets

Send personalized email notifications and log responses in Google Sheets using ChatGPT. Enhance communication and data tracking effortlessly.

Free

YouTube video transcription & summary to Telegram with GPT-4o

Disclaimer This workflow uses a community node: - npm install n8n-nodes-supadata - Please make sure to install this before running the workflow. 🔎 Who is this for? This workflow is for anyone who wants quick summaries of YouTube videos, such as researchers, students, analysts, or busy professionals. Just send a video link via Telegram and receive a structured summary in seconds—no need to watch the entire video. 🧠 What problem is this workflow solving? Watching long videos to extract key informa

Free

Automate Morning Brew–style Reddit Digests and Publish to DEV using AI

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Who’s it for Community managers, content marketers, and builders who want a daily, skimmable update from a subreddit—automatically summarized, formatted, and cross-posted to DEV Community. Here is a Link to video hackathon detailing this build. What it does Collects fresh posts from a subreddit (seeded via RSS). Uses the Bright Data node to batch-scrape each post for richer fields (upvotes, co

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free