Score guest feedback sentiment and send thank-you emails automatically

Guests fill out a feedback form and the system scores sentiment by category, then sends a thank-you email.

How the work actually flows

It branches. Every path runs.

Pattern: Parallel Split (2)

flowchart TD trig>"guest submits feedback form"]:::trig s0[("log feedback in sheet")]:::store s1["AI scores sentiment by category"]:::task trig --> s0 s0 --> s1 gx{"+ which outputs to produce"}:::gate s1 --> gx p00["send thank-you email"]:::task gx -->|"thank guest"| p00 p10["save scores and average rating"]:::task gx -->|"record scores"| p10 p00 --> out p10 --> out out[/"guest thanked and feedback scored"/]:::out pay{{"spot satisfaction trends without manual reading"}}:::pay out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepA record or sheetEvery pathResultPayoff
Build size
Standard

A mid-size build with several tools working together.

Business functions
Email AutomationSpreadsheet & Database OpsReporting & AnalyticsSurvey & Feedback
Connects
GmailGoogle SheetsOpenRouter
Featured in

The problem it solves

Reading through guest feedback one form at a time and figuring out what it really says about staff, cleanliness, and food takes time you don't have. Without a consistent way to score it, patterns in guest satisfaction are easy to miss until a review goes public.

Who it fits

Hotels and hospitality businesses that collect guest feedback after a stay.

How it works

  1. Guest submits a feedback form after their stay
  2. Responses are logged in Google Sheets
  3. AI reads the feedback and scores sentiment for staff, cleanliness, food, and overall stay
  4. Guest receives a personalized thank-you email
  5. Sentiment scores and an average rating are saved back to the sheet
What you get

Guest sentiment sorted by category automatically

Guest feedback gets scored by category so you can see exactly where a stay fell short, and guests get a thank-you note automatically.

What you get

A running Google Sheet log of guest feedback with sentiment scores per category and an overall satisfaction rating.

What you need

A Google Workspace account, an OpenRouter API key, and a Gmail account.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Back to the AI Playbook