Every X day at Y pm, the workflow is automatically triggered.
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.
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
The workflow sends this personalized message to each user via the Whapi API, using their WhatsApp ID.
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.