# Retail Feedback Sentiment & Thank-You Emails

**Category:** Retail  
**Tools:** Google Sheets, Gmail, OpenAI  
**Nodes:** 8  
**Built by:** Forgent Systems

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

![Workflow](preview.webp)

## 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

## Data setup

**Google Sheets** (tab: columns)

- **Retail  - Customer Feedback Analysis → Sheet1**: `Guest Name`, `Email`, `Overall shopping Rate`, `Quality rate`, `Discounts Rate`, `Products As money Rate`, `Overall shopping  Feedback`, `Quality Feedback`, `Discounts Feedback`, `Products As money Feedback`, `Overall shopping Sentiment`, `Quality Sentiment`, `Discounts Sentiment`, `Products As money Sentiment`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Gmail account
   - Google Sheets account
   - OpenRouter account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **On form submission** — `n8n-nodes-base.formTrigger`
- **Review Log** — `n8n-nodes-base.googleSheets`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
- **Basic LLM Chain** — `@n8n/n8n-nodes-langchain.chainLlm`
- **OpenRouter Chat Model** — `@n8n/n8n-nodes-langchain.lmChatOpenRouter`
- **Structured Output Parser** — `@n8n/n8n-nodes-langchain.outputParserStructured`
- **Send User To Feedback Email** — `n8n-nodes-base.gmail`
- **Append Sentiment in Sheet** — `n8n-nodes-base.googleSheets`
