{"product_id":"automate-re-engagement-emails-with-supabase-smtp","title":"Automate Re-engagement Emails with Supabase \u0026 SMTP","description":"\u003ch3\u003eEffortless Email Re-Engagement Automation with Supabase \u0026amp; SMTP\u003c\/h3\u003e\n\n\u003cp\u003eReignite 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRuns every day at 9 AM to ensure timely re-engagement efforts.\u003c\/li\u003e\n  \u003cli\u003eExtracts pertinent email guidance, including three strategic directions and a subject hint, tailored to your brand's voice, from the Supabase \u003ccode\u003eemail_guidance\u003c\/code\u003e table.\u003c\/li\u003e\n  \u003cli\u003eIdentifies up to 100 inactive users from the Supabase \u003ccode\u003eusers\u003c\/code\u003e table who require engagement, ensuring no repeat emails have been sent previously.\u003c\/li\u003e\n  \u003cli\u003eCollaborates with Anthropic Claude by providing user details and guidance directions to generate a personalized email subject and body.\u003c\/li\u003e\n  \u003cli\u003eTransforms Claude's JSON response into a compelling HTML email, skipping users without valid email addresses.\u003c\/li\u003e\n  \u003cli\u003eDispatches these personalized emails through SMTP and updates the user record post successful delivery, marking them as engaged and capturing the re-engaged timestamp.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS platforms aiming to transform dormant accounts into active users with personalized re-engagement strategies.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers seeking to reduce manual efforts in marketing campaigns, ensuring consistent and timely email send-offs to retain and win back customers.\u003c\/li\u003e\n  \u003cli\u003en8n users who wish to enhance their Supabase data utilization by integrating AI-powered content personalization and SMTP for seamless communication.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eNodes and tools employed: set, code, supabase, email send, sticky note, HTTP request\u003c\/li\u003e\n  \u003cli\u003eRequires Supabase integration with host and service_role key configurations.\u003c\/li\u003e\n  \u003cli\u003eUtilizes Anthropic API for personalized content generation using the x-api-key header for authentication.\u003c\/li\u003e\n  \u003cli\u003eSMTP setup mandatory for email dispatch; ensure credentials for email providers are correctly configured.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45590341189811,"sku":"N8N-16423","price":38.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/EBro6Tyy791cPeEGsjdJS_80ccbba8d6f641bd86ad8980d9c5f524.jpg?v=1782119304","url":"https:\/\/buyflowscripts.com\/products\/automate-re-engagement-emails-with-supabase-smtp","provider":"N8N Commerce","version":"1.0","type":"link"}