Research & Analysis

Customer Feedback Sentiment Classifier

Collect customer feedback through a form, classify its sentiment with OpenAI and log it in Google Sheets.

The Problem

Feedback forms produce a pile of text that nobody tags, so negative feedback sits unread next to praise.

How This Template Solves It

A small business shares a feedback form. Each submission is classified by sentiment and saved with the original answers to a Google Sheet, so the team can filter for unhappy customers.

How It Works

  1. 1A form collects customer feedback.
  2. 2OpenAI classifies the sentiment of the feedback text.
  3. 3Merges the form answers with the result.
  4. 4Adds a row to Google Sheets.

What You Need

  • An OpenAI API key
  • A Google Sheet, such as a copy of the author's example

What Stays Under Your Control

  • Someone follows up with customers who left negative feedback.

Watch Out For

  • Spell out the sentiment labels you want in the prompt so results stay consistent.

Adapted from a community workflow template. Before publishing we removed credentials, account and file IDs, email addresses and sample data. The original author's setup notes are kept inside the workflow file.

More Research & Analysis Templates

Research & Analysis

Weekly Google Analytics Report by Email and Telegram

Each week, compare the last seven days of Google Analytics data with the same days last year and send an AI-written report by email and Telegram.

Starts on: Schedule

Email (SMTP)Google AnalyticsOpenAI+1 more