Food menu update notifier
Ready for 3.0What this workflow does
This workflow has 17 nodes and runs on a schedule (every 30 minutes). Along the way it connects Google Sheets. It also calls api.whatsapp.com and api.twilio.com over HTTP.
How it runs
Trigger: On a schedule (every 30 minutes).
- Fetch Special Menu Data (Google Sheets): uses Google Sheets
- Detect Menu Changes (Code): runs custom JavaScript code
- Generate Menu Alert Message (Code): runs custom JavaScript code
- Fetch Customer Contact List (Google Sheets): uses Google Sheets
- Wait: pauses before continuing
- Merge Menu with Customer Data (Edit Fields (Set)): sets 1 field: customers
- Split by Notification Preference (Loop Over Items (Split in Batches)): loops over the items in batches
- Filter WhatsApp Users (If): checks a condition and branches into true / false
- Filter SMS Users (If): checks a condition and branches into true / false
- Filter Email Users (If): checks a condition and branches into true / false
…plus 6 more steps. See the full node list below.
Services it uses
HTTP calls to: api.whatsapp.com, api.twilio.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 (9)
- HTTP Request
n8n-nodes-base.httpRequest - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - Send Email
n8n-nodes-base.emailSend - Wait
n8n-nodes-base.wait
From the author
An intelligent food menu update notification system that automatically detects changes in your restaurant's special menu and sends personalized notifications to customers via multiple channels - WhatsApp, Email, and SMS. This workflow ensures your customers…