# Guest Feedback & Sentiment Analysis

**Category:** Hospitality  
**Tools:** OpenAI, Gmail, Slack  
**Nodes:** 8  
**Built by:** Forgent Systems

Collects guest feedback through a form, has AI score the sentiment, and replies to each guest with a personalized email. All results are logged in Google Sheets for review.

![Workflow](preview.webp)

## How it works

1. A guest submits the feedback form and the response is logged.
2. AI classifies the review as positive, neutral or negative with a short summary.
3. A tailored thank-you or follow-up email is sent to the guest.
4. Sentiment results are appended to the sheet.

## Use cases

- Hotels and resorts
- Restaurants and cafés
- Event venues

## Data setup

**Google Sheets** (tab: columns)

- **Hospitality-Feedback Collection & Analysis → Sheet1**: `Guest Name`, `Email`, `overall stay Rate`, `staff rate`, `cleanliness and comfort Rate`, `food & dining Rate`, `overall stay Feedback`, `staff Feedback`, `cleanliness and comfort Feedback`, `food & dining Feedback`, `overall stay Sentiment`, `staff Sentiment`, `cleanliness and comfort Sentiment`, `food & dining 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`
