Retail

Retail Feedback Sentiment & Thank-You Emails

Collects shopper feedback through a form, analyzes sentiment with AI, sends a personalized thank-you email and logs everything in Google Sheets.

The Retail Feedback Sentiment & Thank-You Emails workflow on the n8n canvas, with its 8 nodes and connections
The workflow on the n8n canvas. Click to open it full size.

At a glance

Category
Retail
Nodes
8
Apps
Google Sheets, Gmail, OpenAI
Price
Free
Download JSON
On this page

How it works

  1. A customer submits the feedback form and it's logged.
  2. AI classifies the sentiment and summarizes the feedback.
  3. A personalized email is sent to the customer.
  4. The sentiment result is appended to the sheet.

Use cases

  • Retail stores
  • Showrooms
  • Franchise outlets

What you need

This workflow connects to these apps.

  • Google Sheets
  • Gmail
  • OpenAI

You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.

  • Gmail account
  • Google Sheets account
  • OpenRouter account

Data setup

Create these tables with these exact column names before the first run.

TableColumns
Retail - Customer Feedback Analysis → Sheet1Google SheetsGuest NameEmailOverall shopping RateQuality rateDiscounts RateProducts As money RateOverall shopping FeedbackQuality FeedbackDiscounts FeedbackProducts As money FeedbackOverall shopping SentimentQuality SentimentDiscounts SentimentProducts As money Sentiment

Setup

  1. Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
  2. Connect the credentials listed above.
  3. Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
  4. Replace placeholder emails, phone numbers, and form links with your own.
  5. Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.

Nodes

NodeType
On form submissionformTrigger
Review LoggoogleSheets
Basic LLM ChainchainLlm
OpenRouter Chat ModellmChatOpenRouter
Structured Output ParseroutputParserStructured
Send User To Feedback Emailgmail
Append Sentiment in SheetgoogleSheets

Frequently asked questions

Collects shopper feedback through a form, analyzes sentiment with AI, sends a personalized thank-you email and logs everything in Google Sheets. It's a 8-node n8n workflow.

An n8n instance, on n8n Cloud or self-hosted, and credentials for Gmail, Google Sheets, and OpenRouter. It uses only nodes that ship with n8n, so there's nothing else to install.

It works with 1 table in Google Sheets. Create it with the column names listed under Data setup on this page before the first run.

Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.

Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.

Keep exploring
  • n8n canvas of the POS Invoice to WhatsApp workflow

    Retail10 nodes

    POS Invoice to WhatsApp

    Each new POS order gets a PDF invoice, which is uploaded to Drive and sent to the customer on WhatsApp. The order status is updated in Google Sheets.

  • n8n canvas of the Retail Sales & Inventory Manager workflow

    Retail34 nodes

    Retail Sales & Inventory Manager

    A complete shop back-office in Google Sheets. It records sales, updates stock, sends receipts, alerts on low stock, handles restocking and sends a daily sales summary.

  • n8n canvas of the AI Crop Advisory for Farmers workflow

    Agriculture27 nodes

    AI Crop Advisory for Farmers

    Gives farmers practical, AI-generated crop advice based on their soil, crop and live weather. Advice is delivered instantly on sign-up and refreshed daily over WhatsApp.