{"product_id":"n8n-workflow-supabase-outreach-scheduler-with-twilio-retell","title":"n8n Workflow: Supabase Outreach Scheduler with Twilio \u0026 Retell","description":"\u003ch3\u003eAutomatically schedule and send outreach SMS or voice calls from Supabase—with Twilio \u0026amp; Retell\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every 15 minutes to claim due outreach enrollments from \u003cstrong\u003eSupabase\u003c\/strong\u003e, decide the next message or voice touch (respecting sequence rules and quiet hours), send via \u003cstrong\u003eTwilio\u003c\/strong\u003e (SMS) or \u003cstrong\u003eRetell\u003c\/strong\u003e (voice), and then writes attempt outcomes and enrollment updates back to Supabase—optionally posting a summary to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule (or on demand):\u003c\/strong\u003e executes every 15 minutes, loading configuration that controls the outreach sequence, quiet hours, caps, and provider settings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClaims due outreach from Supabase:\u003c\/strong\u003e uses an RPC call to pull a batch of due attempts; if Supabase isn’t configured, it can fall back to a built-in sample queue.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects the next ladder step \u0026amp; content:\u003c\/strong\u003e evaluates each due enrollment, determines the next step, renders SMS body \/ voice-call variables, and generates an idempotency key to prevent duplicate sends.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnforces quiet hours and caps:\u003c\/strong\u003e applies candidate-local quiet hours\/weekend rules and daily limits before attempting delivery.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends or previews:\u003c\/strong\u003e routes items to \u003cstrong\u003eTwilio\u003c\/strong\u003e for SMS or \u003cstrong\u003eRetell\u003c\/strong\u003e for outbound voice calls; if sending is disabled, it outputs a preview of what would be sent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles outcomes and retry logic:\u003c\/strong\u003e classifies provider responses (sent, transient failure, permanent failure including carrier opt-outs) and advances, retries later with backoff, or stops the enrollment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePersists results back to Supabase:\u003c\/strong\u003e writes contact attempts, enrollment state updates, and carrier opt-outs when database writes are enabled.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts Slack run summaries (optional):\u003c\/strong\u003e sends an incoming webhook message when Slack is configured and there’s something noteworthy to report.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn Supabase “due outreach” records into timely SMS follow-ups with Twilio.\u003c\/li\u003e\n  \u003cli\u003eRun a mixed-channel outreach ladder where SMS and Retell voice touches occur in sequence.\u003c\/li\u003e\n  \u003cli\u003ePrevent unwanted texting during quiet hours using candidate-local rules and daily caps.\u003c\/li\u003e\n  \u003cli\u003eMaintain accurate outreach state, retries, and opt-out handling in Supabase.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e if, code, no op, merge, sticky note, http request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Supabase (RPC claim + writes), Twilio (SMS), Retell (voice), Slack (incoming webhook summary).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46123147493555,"sku":"N8N-20112","price":63.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/T-yJmStFfssBaVVF0WF6k_XwpdBEhy.png?v=1790673123","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-supabase-outreach-scheduler-with-twilio-retell","provider":"N8N Commerce","version":"1.0","type":"link"}