Guest Feedback & Sentiment Analysis
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.

On this page
How it works
- A guest submits the feedback form and the response is logged.
- AI classifies the review as positive, neutral or negative with a short summary.
- A tailored thank-you or follow-up email is sent to the guest.
- Sentiment results are appended to the sheet.
Use cases
- Hotels and resorts
- Restaurants and cafés
- Event venues
What you need
This workflow connects to these apps.
- OpenAI
- Gmail
- Slack
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.
| Table | Columns |
|---|---|
| Hospitality-Feedback Collection & Analysis → Sheet1Google Sheets | Guest NameEmailoverall stay Ratestaff ratecleanliness and comfort Ratefood & dining Rateoverall stay Feedbackstaff Feedbackcleanliness and comfort Feedbackfood & dining Feedbackoverall stay Sentimentstaff Sentimentcleanliness and comfort Sentimentfood & dining Sentiment |
Setup
- 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.
- Connect the credentials listed above.
- Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
- Replace placeholder emails, phone numbers, and form links with your own.
- 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
| Node | Type |
|---|---|
| On form submission | formTrigger |
| Review Log | googleSheets |
| Basic LLM Chain | chainLlm |
| OpenRouter Chat Model | lmChatOpenRouter |
| Structured Output Parser | outputParserStructured |
| Send User To Feedback Email | gmail |
| Append Sentiment in Sheet | googleSheets |
Frequently asked questions
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. 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.



