Automate Re-engagement Emails with Supabase & SMTP

Effortless Email Re-Engagement Automation with Supabase & SMTP

Reignite engagement with your inactive users seamlessly. Automate daily personalized re-engagement emails using Supabase and SMTP, powered by the advanced language model, Anthropic Claude. This n8n workflow boosts communication efficiency by streamlining the process of reaching out to users who have drifted away, driving user interaction and retention effortlessly.

What this workflow does

• Runs every day at 9 AM to ensure timely re-engagement efforts.
• Extracts pertinent email guidance, including three strategic directions and a subject hint, tailored to your brand's voice, from the Supabase email_guidance table.
• Identifies up to 100 inactive users from the Supabase users table who require engagement, ensuring no repeat emails have been sent previously.
• Collaborates with Anthropic Claude by providing user details and guidance directions to generate a personalized email subject and body.
• Transforms Claude's JSON response into a compelling HTML email, skipping users without valid email addresses.
• Dispatches these personalized emails through SMTP and updates the user record post successful delivery, marking them as engaged and capturing the re-engaged timestamp.

Use cases

• SaaS platforms aiming to transform dormant accounts into active users with personalized re-engagement strategies.
• Automation engineers seeking to reduce manual efforts in marketing campaigns, ensuring consistent and timely email send-offs to retain and win back customers.
• n8n users who wish to enhance their Supabase data utilization by integrating AI-powered content personalization and SMTP for seamless communication.

Technical details

• Nodes and tools employed: set, code, supabase, email send, sticky note, HTTP request
• Requires Supabase integration with host and service_role key configurations.
• Utilizes Anthropic API for personalized content generation using the x-api-key header for authentication.
• SMTP setup mandatory for email dispatch; ensure credentials for email providers are correctly configured.