Send Weekly Engagement Stats & Raffle Updates via WhatsApp using Airtable
Scheduled Trigger: Every X day at Y pm, the workflow is automatically triggered.
Fetch User Data: The workflow retrieves all user records from the "WhatsApp Engagement Database" in Airtable. Each record contains the user’s WhatsApp ID, current points, and the number of raffle vouchers.
Personalized Message Preparation: For each user, a personalized WhatsApp message is prepared. The message includes:
The user’s current point total
The number of raffle vouchers they have for the week
Encouragement to keep engaging for more chances to win
Information about the weekly raffle and available prizes
Send WhatsApp Message: The workflow sends this personalized message to each user via the Whapi API, using their WhatsApp ID.
Result: Every active user receives a weekly update about their engagement status, raffle tickets, and a motivational message to encourage further participation. This helps boost engagement and keeps users informed about their progress and chances in the weekly raffle.
Related Templates
Automate Daily Keyword Research with Google Sheets, Suggest API & Custom Search
Who's it for This workflow is perfect for SEO specialists, marketers, bloggers, and content creators who want to automa...
USDT And TRC20 Wallet Tracker API Workflow for n8n
Overview This n8n workflow is specifically designed to monitor USDT TRC20 transactions within a specified wallet. It u...
Add product ideas to Google Sheets via a Slack
Use Case This workflow is a slight variation of a workflow we're using at n8n. In most companies, employees have a lot o...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments