Library / Alerts & Notifications
Alerts & Notifications
Send Weekly WhatsApp Engagement Stats and Raffle Updates
Every Wednesday at 1 PM, this reads user records from Airtable and sends each person a weekly WhatsApp message with engagement stats and raffle updates.
What it does
## Scheduled Trigger: Every Wednesday at 1 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.
The steps
- Every wednesday at 1 pm
- Send WhasApp (Weekly Message)
- Search records
Similar automations
Data Sync & ETLTrack WhatsApp Group Engagement in Airtable7 stepsReports, Analytics & DashboardsGenerate n8n Creator Profile Stats and Commit to GitHub12 stepsReports, Analytics & DashboardsReport Weekly Google Analytics Stats to Baserow52 stepsReports, Analytics & DashboardsReport Weekly Google Analytics Stats to Baserow52 steps