Filter for positive Google reviews using Telegram, web form & Google Sheets
Ready for 3.0What this workflow does
This workflow has 21 nodes and runs on Telegram events (message) (plus 3 other triggers). Along the way it connects Telegram and Google Sheets.
How it runs
Trigger: On Telegram events (message) (plus 3 other triggers).
- Fetch Rows from sheet (Google Sheets): uses Google Sheets
- Save Private Feedback to Sheet (Google Sheets): update
- Update Status to 'Clicked' (Google Sheets): update
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- checks if customer exists in sheets (If): checks a condition and branches into true / false
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Updates customer details (Google Sheets): append
- checks if they still didn't claim the offer (If): checks a condition and branches into true / false
- Timestamp to Boolean (Edit Fields (Set)): sets 1 field: is_deadline_in_past
- Send Incentive Offer (Telegram): uses Telegram
…plus 7 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)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - Google Sheets
n8n-nodes-base.googleSheets - Telegram
n8n-nodes-base.telegram - Webhook
n8n-nodes-base.webhook - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - Wait
n8n-nodes-base.wait - Edit Fields (Set)
n8n-nodes-base.set
From the author
This workflow is a powerful reputation management tool designed to proactively filter customer reviews. It helps you encourage positive reviews on Google while capturing negative feedback privately before it impacts your public rating. By using an incentive,…