Request and reply to Google reviews with Twilio SMS, Gmail, and OpenAI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 29 nodes and runs on a schedule (every day at 18:00) (plus 2 other triggers). Along the way it connects Google Sheets, Twilio, OpenAI Chat Model and Gmail. It also calls mybusiness.googleapis.com over HTTP.
How it runs
Trigger: On a schedule (every day at 18:00) (plus 2 other triggers).
- CONFIG - Reviews (Jobs) (Edit Fields (Set)): sets 6 fields: business_name, review_link, owner_phone…
- CONFIG - Reviews (State) (Edit Fields (Set)): sets 6 fields: business_name, review_link, owner_phone…
- CONFIG - Reviews (Replies) (Edit Fields (Set)): sets 6 fields: business_name, review_link, owner_phone…
- Get Today's Jobs - Sheets (Google Sheets): read (sheet)
- Read State - Sheets (Google Sheets): read (sheet)
- Get Pending Replies - Sheets (Google Sheets): read (sheet)
- Filter Eligible - Code (Code): runs custom JavaScript code
- Get Last Check - Code (Code): runs custom JavaScript code
- Filter Approved - Code (Code): runs custom JavaScript code
- Send Review SMS - Twilio (Twilio): send (sms)
…plus 15 more steps. See the full node list below.
Services it uses
HTTP calls to: mybusiness.googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Twilio
n8n-nodes-base.twilio - Edit Fields (Set)
n8n-nodes-base.set - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Gmail
n8n-nodes-base.gmail
From the author
Quick overview Local service businesses — plumbers, clinics, salons, contractors, restaurants — that live or die by Google reviews but never remember to ask, and agencies that want a review engine they can deploy for clients. How it works 1. Three lanes. (1)…