CORTEXFLOW · FREE FOREVER

Automation

Review & Reputation Engine

↓ Download workflow JSON

Import in n8n: Workflows → ⋯ → Import from file, then add your credentials. Free download with a free account.

How it works

Your always-on reputation assistant — two independent flows in one workflow:

  1. STEP 1 — Job completed → 2-day wait → review request — a POST webhook (/job-completed, with customer_name, email, phone, job_id) logs the job to Google Sheets with status REQUEST_PENDING, replies OK immediately, then waits 2 days and emails the customer 5 clickable star links.
  2. STEP 2 — Rating webhook → smart routing — clicking a star hits the GET /rate webhook (?job_id=…&stars=…). The rating is parsed, matched to the sheet row, and routed: 1–3 stars → Slack alert to your support channel + sheet flips to FLAGGED; 4–5 stars → Gmail sends your Google review link + sheet flips to REVIEW_ASKED. Both branches merge into a Flow-A summary.
  3. STEP 3 — Daily Google Business Profile monitoring — every morning at 8 AM the workflow lists your latest GBP reviews via the Google Business Profile API, drops the ones already logged, and for each new review an AI Agent classifies sentiment (positive / neutral / negative) via a Structured Output Parser, posts an alert to Slack with a suggested public reply, and appends it to the sheet as LOGGED. No new reviews → the flow ends quietly.
  4. STEP 4 — Sheets logging + Telegram digest — both flows feed one digest: new Google reviews with sentiment counts, plus review-request stats (pending / asked / flagged) read from Sheets. It lands in Telegram every morning, and after every rating event.

Status flow in Sheets: Review Requests tab: REQUEST_PENDING → REVIEW_ASKED / FLAGGED · GBP Reviews tab: new → LOGGED

Set up steps

You’ll need:

  • n8n (self-hosted or cloud)
  • A Gmail account — n8n Credentials → Gmail OAuth2 (Google Cloud Console to create the OAuth client if you don’t have one)
  • Google Business Profile API access — enable the My Business API in Google Cloud Console, then generate a token at the OAuth 2.0 Playground (refresh it monthly)
  • Your Google review link — Google Business Profile → get the “share review form” link for happy customers
  • A Slack workspace — create an app at api.slack.com/apps and add the n8n Slack credential
  • An OpenAI API key — platform.openai.com → API keys
  • Google Sheets OAuth2 credential + one spreadsheet with two tabs: Review Requests and GBP Reviews
  • A Telegram bot — message @BotFather, send /newbot, copy the token; get your chat ID from @userinfobot

Steps:

  1. Import the workflow — in n8n, Workflows → Import from File → select review-reputation-engine.json.
  2. Create the Review Requests tab — headers exactly: Date | Job ID | Customer | Email | Rating | Status. Create the GBP Reviews tab — headers exactly: Date | Review ID | Reviewer | Stars | Text | Sentiment | Status.
  3. CONFIG — Review Flow — open the Set node and fill in:
    • business_name — your business name as customers know it
    • rating_webhook_base_url — your n8n webhook base URL (e.g. https://your-n8n/webhook) — the star links are built from this
    • google_review_url — the Google review link from your Business Profile
    • support_slack_channel — e.g. #support
    • spreadsheet_id — the ID from your sheet’s URL
  4. CONFIG — GBP — paste your gbp_access_token (OAuth playground token), gbp_account_id, gbp_location_id, and the same spreadsheet_id. Select your Google Sheets credential in all six Sheets nodes.
  5. Connect your job-completed source — point your booking/CRM system at the Job Completed webhook URL with JSON body {"customer_name": "…", "email": "…", "phone": "…", "job_id": "…"}. Test it once and confirm a REQUEST_PENDING row appears.
  6. CONFIG — Notifications — paste your Telegram chat ID, select your Telegram credential; select your OpenAI credential in the chat model node, Gmail credential in both Gmail nodes, Slack credential in both Slack nodes. Activate the workflow (the schedule trigger and both webhooks).

Customize it

  • Different wait time — change the Wait 2 Days node to 1 day, 7 days, or anything else; service businesses with longer jobs may want more breathing room.
  • Rating threshold — the IF — Rating < 4? node routes 1–3 stars to support; tighten it to < 5 if you want every non-perfect rating flagged.
  • SMS instead of email — swap the Send Review Request Gmail node for a Twilio/WhatsApp node; the star links work in any channel.
  • Auto-reply to reviews — the AI already drafts a suggested_reply; add a GBP “reply to review” HTTP call after Post Review Alert to publish it automatically (review it manually first — auto-replies can backfire).
  • More review sites — duplicate STEP 2’s happy path to also send Trustpilot/Yelp links based on the customer’s country.
  • Weekly digest instead of daily — change the schedule trigger interval; the Sheets-based stats keep working at any cadence.

Workflow nodes

This workflow is built from 34 nodes. Here's what each one does:

#NodeTypeWhat it does
1 Job Completed Webhook Entry point — receives incoming HTTP requests that trigger the workflow.
2 CONFIG — Review Flow Set Holds editable configuration values — fill in your own settings here before activating.
3 Log — REQUEST_PENDING Google Sheets Reads from or writes to a Google Sheet — this workflow's log and state store.
4 Respond — Job Received Respond to Webhook Sends the HTTP response back to whoever called the webhook.
5 Wait 2 Days Wait Pauses the workflow until a condition or time is met.
6 Build Star Links Code Runs custom JavaScript to transform, filter, or compute data between steps.
7 Send Review Request Gmail Sends or reads email through your Gmail account.
8 Rating Submitted Webhook Entry point — receives incoming HTTP requests that trigger the workflow.
9 Parse Rating Code Runs custom JavaScript to transform, filter, or compute data between steps.
10 Read Review Requests Google Sheets Reads from or writes to a Google Sheet — this workflow's log and state store.
11 Match Job ID Code Runs custom JavaScript to transform, filter, or compute data between steps.
12 IF — Rating < 4? IF Splits the flow into branches based on a condition.
13 Alert — Unhappy Customer Slack Posts messages or reads data in Slack.
14 Update — FLAGGED Google Sheets Reads from or writes to a Google Sheet — this workflow's log and state store.
15 Send Google Review Link Gmail Sends or reads email through your Gmail account.
16 Update — REVIEW_ASKED Google Sheets Reads from or writes to a Google Sheet — this workflow's log and state store.
17 Merge — Combine Rating Branches Merge Combines the outputs of two or more branches back into one flow.
18 Build Flow-A Summary Code Runs custom JavaScript to transform, filter, or compute data between steps.
19 Daily Review Check — 8AM Schedule Trigger Starts the workflow automatically on a schedule.
20 CONFIG — GBP Set Holds editable configuration values — fill in your own settings here before activating.
21 List New GBP Reviews HTTP Request Calls an external API or webhook endpoint.
22 Read Seen Reviews Google Sheets Reads from or writes to a Google Sheet — this workflow's log and state store.
23 Filter New Reviews Code Runs custom JavaScript to transform, filter, or compute data between steps.
24 Read Request Stats Google Sheets Reads from or writes to a Google Sheet — this workflow's log and state store.
25 IF — New Reviews Found? IF Splits the flow into branches based on a condition.
26 AI Agent — Summarize Review Sentiment AI Agent The AI brain — reasons over the task and calls tools to get it done.
27 OpenAI Chat Model — Sentiment OpenAI Chat Model The language model powering the AI agent.
28 Structured Output Parser — Sentiment Structured Output Parser Forces the AI to return clean, structured JSON instead of free text.
29 Post Review Alert Slack Posts messages or reads data in Slack.
30 Log GBP Review Google Sheets Reads from or writes to a Google Sheet — this workflow's log and state store.
31 Build Flow-B Summary Code Runs custom JavaScript to transform, filter, or compute data between steps.
32 Build Daily Digest Code Runs custom JavaScript to transform, filter, or compute data between steps.
33 CONFIG — Notifications Set Holds editable configuration values — fill in your own settings here before activating.
34 Telegram — Send Digest Telegram Sends you a Telegram message or alert.

Setup instructions

1. Add your credentials

In n8n go to Credentials → New, create each credential below, then open the named node and select it:

NodeCredential to add
Log — REQUEST_PENDING Google Sheets OAuth2
Send Review Request Gmail OAuth2
Read Review Requests Google Sheets OAuth2
Alert — Unhappy Customer Slack API (token)
Update — FLAGGED Google Sheets OAuth2
Send Google Review Link Gmail OAuth2
Update — REVIEW_ASKED Google Sheets OAuth2
Read Seen Reviews Google Sheets OAuth2
Read Request Stats Google Sheets OAuth2
OpenAI Chat Model — Sentiment OpenAI API
Post Review Alert Slack API (token)
Log GBP Review Google Sheets OAuth2
Telegram — Send Digest Telegram Bot API

2. Fill in your config values

Open the config node listed below and replace each placeholder with your own value before activating the workflow:

NodeFieldWhat to paste
CONFIG — Review Flow business_name PASTE_YOUR_BUSINESS_NAME
Your business name
CONFIG — Review Flow rating_webhook_base_url PASTE_YOUR_N8N_WEBHOOK_BASE_URL
Your n8n webhook base url
CONFIG — Review Flow google_review_url PASTE_YOUR_GOOGLE_REVIEW_URL
Your google review url
CONFIG — Review Flow support_slack_channel PASTE_YOUR_SLACK_CHANNEL
Your slack channel
CONFIG — Review Flow spreadsheet_id PASTE_YOUR_SPREADSHEET_ID
Your spreadsheet id
CONFIG — GBP gbp_access_token PASTE_YOUR_GBP_ACCESS_TOKEN
Your gbp access token
CONFIG — GBP gbp_account_id PASTE_YOUR_ACCOUNT_ID
Your account id
CONFIG — GBP gbp_location_id PASTE_YOUR_LOCATION_ID
Your location id
CONFIG — GBP spreadsheet_id PASTE_YOUR_SPREADSHEET_ID
Your spreadsheet id
CONFIG — Notifications telegram_chat_id PASTE_YOUR_TELEGRAM_CHAT_ID
Your telegram chat id

How this workflow starts

  • Webhook: Listens on path /job-completed — copy the production URL from the node after activating the workflow.
  • Webhook: Listens on path /rate — copy the production URL from the node after activating the workflow.
  • Schedule Trigger: Runs every hours.

Use cases

Reviews decide who gets the job before you ever pick up the phone, but most businesses ask for them inconsistently and discover bad ones too late. This workflow runs two independent flows. Flow A starts when a job completes: your system posts to the job-completed webhook, the customer gets a review request email two days later with five clickable star links, and clicking a star hits the rating webhook — 1 to 3 stars route to Slack and get flagged for support, 4 to 5 stars get your Google review link. Flow B runs every morning at 8 AM, lists your latest Google Business Profile reviews, has an AI agent classify sentiment with a suggested public reply, and logs everything to Sheets.

The HVAC company catching unhappy customers first

For an HVAC company, a 2-star Google review can cost five future jobs. Here the 1-to-3-star path is the whole point: the moment a customer clicks two stars, the Alert node posts to the support Slack channel and the sheet marks the row FLAGGED, so the service manager can call within the hour — before frustration becomes a public review. Happy customers, meanwhile, are routed straight to the Google review link and marked REVIEW_ASKED. Practical tip: tighten the IF node from under 4 to under 5 if you want every non-perfect rating flagged for a personal follow-up.

The dental clinic building its Google review count

A dental clinic lives on its star rating, and timing is everything — ask too soon and the numbness has not worn off, too late and the goodwill fades. The Wait 2 Days node hits the sweet spot, the star-link email makes rating a one-click act, and the 4-to-5-star branch sends the Google review link while the patient is still smiling. The Telegram digest each morning shows pending, asked, and flagged counts from the Review Requests tab. Practical tip: swap the Gmail node for a Twilio or WhatsApp node if your patients respond better to texts — the star links work in any channel.

The restaurant group monitoring reviews daily

A three-location restaurant group gets reviews across all its listings, and the 8 AM GBP check keeps anyone from missing a weekend complaint until Monday. Each new review is classified positive, neutral, or negative by the AI agent, posted to Slack with a suggested public reply, and logged as LOGGED in the GBP Reviews tab. No new reviews means the flow ends quietly — no noise. Practical tip: the AI already drafts the suggested reply, and you can add a GBP reply call after the alert node to publish it — but review it manually first, because auto-replies to angry reviewers can backfire badly.

The home-services franchise standardizing follow-up

A franchise with ten territories needs every location doing the same review follow-up, and this workflow makes it a system instead of a hope. Each territory's booking software posts to the same job-completed webhook with its job ID, the Match Job ID node ties every rating back to the right row, and the Flow-A summary merges both branches after every rating event. Practical tip: change the Wait node to seven days for businesses with longer jobs — a kitchen remodel should not be reviewed two days after the crew leaves — and the Sheets-based stats keep working at any cadence.

The multi-location retailer expanding beyond Google

Google is not the only review site that matters. The happy path that sends the Google review link can be duplicated to send Trustpilot or Yelp links based on the customer's country, and the CONFIG node keeps the business name, webhook base URL, and review URL in one editable place. Practical tip: switch the Telegram digest from daily to weekly once the system is humming — the underlying stats are read from Sheets, so the digest stays accurate at any interval you choose.

← All templates