Draft and manage Google review replies with OpenRouter, Gmail and Sheets
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 15 nodes and runs on a schedule (every hour). Along the way it connects Google Sheets, Gmail and OpenRouter Chat Model.
How it runs
Trigger: On a schedule (every hour).
- Workflow Settings (Edit Fields (Set)): sets 7 fields: businessName, ownerEmail, accountId…
- Read Already-Logged Reviews (Google Sheets): uses Google Sheets
- Fetch Latest Google Reviews (HTTP Request): calls an HTTP API
- Keep Only New Reviews (Code): runs custom JavaScript code
- Prepare Error Log (Edit Fields (Set)): sets 4 fields: Timestamp, Node, Error…
- OpenRouter — Classify + Draft Reply (Basic LLM Chain): sends a prompt to an LLM, with model: OpenRouter Chat Model
- Log Error in Google Sheets (Google Sheets): append
- Validate AI Draft Safely (Code): runs custom JavaScript code
- Alert Owner — Workflow Error (Gmail): uses Gmail
- Log Review and Draft in Sheets (Google Sheets): append
…plus 3 more steps. See the full node list below.
Services it uses
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 (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Gmail
n8n-nodes-base.gmail - Code
n8n-nodes-base.code - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - If
n8n-nodes-base.if
From the author
Quick overview This workflow checks for new Google Business Profile reviews hourly, uses OpenRouter to classify sentiment and draft on-brand public replies, logs reviews and drafts to Google Sheets, and emails the business owner for approval via Gmail, with…