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
Send structured logs to BetterStack from any workflow using HTTP Request
Send structured logs to BetterStack from any workflow using HTTP Request Who is this for? This workflow is perfect for...
Provide latest euro exchange rates from European Central Bank via Webhook
What is this workflow doing? This simple workflow is pulling the latest Euro foreign exchange reference rates from the E...
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...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments