Send WhatsApp booking links for Facebook leads with Sheets, Redis, and Cal.com
Ready for 3.0What this workflow does
This workflow has 10 nodes and runs on Facebook Lead Ads events. Along the way it connects Facebook Lead Ads, Google Sheets, WhatsApp Business Cloud and Redis.
How it runs
Trigger: On Facebook Lead Ads events.
- Fetch Lead from Sheets (Google Sheets): uses Google Sheets
- Check If Row Exists (If): checks a condition and branches into true / false
- Upsert Lead in Sheets (Google Sheets): append or update
- Check If Contacted (If): checks a condition and branches into true / false
- Set Address Fields (Edit Fields (Set)): sets 1 field: NY street, Studio Appartment
- Add Calcom Params (Code): runs custom JavaScript code
- Send WhatsApp Message (WhatsApp Business Cloud): send
- Save Session to Redis (Redis): push
- Mark Contacted in Sheets (Google Sheets): update
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 (7)
- Facebook Lead Ads Trigger
n8n-nodes-base.facebookLeadAdsTrigger - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - Redis
n8n-nodes-base.redis - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code
From the author
Quick overview Youtube Video: https://youtu.be/2yB1Imaa6AY?si=FAY4YCeSqqnxCdgW This workflow captures new Facebook Lead Ads leads, stores or updates them in Google Sheets, generates a personalized Cal.com booking link, and sends it via WhatsApp, while also…