Track Google reviews and draft replies with Gemini and Slack

Checks your Google reviews every hour, drafts an AI reply, and alerts your team on Slack when a review turns negative.

How the work actually flows

It branches. Exactly one path is taken; runs once per each new review.

Pattern: Exclusive Choice (4) · Multiple Instances without Synchronization (12)

flowchart TD trig(["hourly review check"]):::trigtime s0["check for new reviews"]:::task s1[["score review sentiment"]]:::mi s2["draft ai reply"]:::task s3[("log review to spreadsheet")]:::store trig --> s0 s0 -->|"one per each new review"| s1 s1 --> s2 s2 --> s3 gx{"× is review negative"}:::gate s3 --> gx p00["send slack alert with draft reply"]:::task gx -->|"negative review"| p00 p10["no alert sent"]:::task gx -->|"positive or neutral"| p10 p00 --> out p10 --> out out[/"logged reviews with instant negative alerts"/]:::out pay{{"fast consistent review responses"}}:::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 stepRuns once per itemA record or sheetOne path onlyResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
Email AutomationMessaging & NotificationsSpreadsheet & Database Ops
Connects
Google MapsGoogle SheetsGmailSlackGemini
Featured in

The problem it solves

You want to respond quickly to every review, but checking Google multiple times a day isn't realistic when you're running the floor or the store. Negative reviews are especially urgent, and a slow or missed response can cost you a customer.

Who it fits

Restaurant owners, retail managers, and small business owners who get regular reviews and need fast, consistent responses.

How it works

  1. Every hour, it checks for new Google reviews
  2. AI reads each review and scores how positive or negative it is
  3. A draft reply is written and the review is logged to a spreadsheet
  4. Negative reviews trigger an immediate Slack alert with the review and draft reply
  5. At the end of the day, you get an email summary of the day's reviews
What you get

Review replies drafted before you sit down

You get every Google review scored, a draft reply ready to send, and an instant alert the moment one turns negative.

What you get

An hourly log of every review plus an instant Slack alert with a draft reply for negative ones.

What you need

A Google Places API key, a Google Sheets account, a Gmail account, and a Slack workspace.

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