Hotels get a constant stream of guest feedback, but it’s scattered across Google and TripAdvisor. That means slow follow-ups, missed negative reviews, and painful reporting. To fix that, I built Suite Talk: n8n workflow that pulls reviews into one place, checks the mood (sentiment), and raises a ticket when something needs attention.
What Suite Talk solves:
Centralizes reviews from multiple sites
Flags negative experiences automatically
Stores everything for easy reporting (Postgres)
How it works:
Runs on a schedule – Every hour, the workflow wakes up.
Sets up the database – If the required tables don’t exist, it creates them (safe to run every time).
Loads settings and hotels – It reads which hotels to check, which providers they use, the last time we looked, the sentiment threshold, and whether to create tickets.
Gets new reviews –
If the row says “Google,” it calls Google’s Reviews API.
If it says “TripAdvisor,” it calls your partner/aggregator endpoint.
Cleans and unifies the data – Different sites return different shapes; Suite Talk standardizes them and skips anything we’ve already seen.
Asks OpenAI for sentiment – It sends only the review text and asks for a simple JSON result: label (negative/neutral/positive) and a score from −1 to +1.
Saves the review – It writes the review + sentiment to Postgres.
Moves the checkpoint – It records the newest review time so next run only fetches fresh items.
Creates a ticket (only when needed) – If the score is below your threshold and ticketing is enabled, it creates a Zendesk ticket with all the details. Otherwise, it just stores the review.
Who can use it:
Hotel groups and management companies
CX/Guest Experience teams who want fast triage
Anyone using n8n who wants a configurable, audit-friendly automation
GitHub: https://lnkd.in/dsMdBRmc
#hospitality #hotels #CX #openai #automation #postgres #reviews
