This n8n workflow automates the process of managing leads and sending WhatsApp messages through Gallabox API. It retrieves contact data from Supabase, segments contacts based on specific criteria, sends personalized WhatsApp messages using templates, and updates lead statuses in the database. The workflow also logs all activities in Supabase for tracking and analysis. It is scheduled to run at regular intervals, making it ideal for lead nurturing, customer engagement, or follow-up campaigns.

The process begins with a scheduled trigger, then fetches all contacts from a Supabase table. It uses multiple ‘switch’ nodes to categorize contacts by their message count and disposition, determining the sequence of messages for each lead. Based on these classifications, it sends WhatsApp notifications using templated messages, such as brochures or follow-up prompts.

After each message, the workflow logs the interaction and updates the contact’s record in Supabase, including the latest message sent time and message count. Conditional nodes evaluate the response status codes to handle errors or success responses, ensuring reliable operation.

This automation is practical for marketing teams running drip campaigns, customer support follow-ups, or sales outreach, enabling personalized communication at scale with minimal manual intervention.