Postgres Smtp Delayed Follow Up Email Sequence

    What this workflow does

    The workflow contains these steps: Run Once to Create Table → Create Queue Table → Enroll Contact Webhook → Sequence Settings → Validate and Build Steps → Is Request Valid? → Queue Sequence Steps → Respond Enrolled → Respond Invalid Request → Stop Sequence Webhook → Cancel Pending Steps → Respond Cancelled → Every 15 Minutes → Claim Due Steps → Any Steps Due? → Send Follow-Up Email → Mark Step Sent → Schedule Retry or Mark Failed.

    What you need

    • An n8n instance to import and run the workflow.
    • StickyNote access for the StickyNote steps listed in this workflow.
    • ManualTrigger access for the ManualTrigger steps listed in this workflow.
    • Postgres access for the Postgres steps listed in this workflow.
    • Webhook access for the Webhook steps listed in this workflow.
    • Set access for the Set steps listed in this workflow.
    • Code access for the Code steps listed in this workflow.
    • IF access for the IF steps listed in this workflow.
    • RespondToWebhook access for the RespondToWebhook steps listed in this workflow.
    • Schedule access for the Schedule steps listed in this workflow.
    • EmailSend access for the EmailSend steps listed in this workflow.

    Workflow nodes

    1. Run Once to Create Table (n8n-nodes-base.manualTrigger)
    2. Create Queue Table (n8n-nodes-base.postgres)
    3. Enroll Contact Webhook (n8n-nodes-base.webhook)
    4. Sequence Settings (n8n-nodes-base.set)
    5. Validate and Build Steps (n8n-nodes-base.code)
    6. Is Request Valid? (n8n-nodes-base.if)
    7. Queue Sequence Steps (n8n-nodes-base.postgres)
    8. Respond Enrolled (n8n-nodes-base.respondToWebhook)
    9. Respond Invalid Request (n8n-nodes-base.respondToWebhook)
    10. Stop Sequence Webhook (n8n-nodes-base.webhook)
    11. Cancel Pending Steps (n8n-nodes-base.postgres)
    12. Respond Cancelled (n8n-nodes-base.respondToWebhook)
    13. Every 15 Minutes (n8n-nodes-base.scheduleTrigger)
    14. Claim Due Steps (n8n-nodes-base.postgres)
    15. Any Steps Due? (n8n-nodes-base.if)
    16. Send Follow-Up Email (n8n-nodes-base.emailSend)
    17. Mark Step Sent (n8n-nodes-base.postgres)
    18. Schedule Retry or Mark Failed (n8n-nodes-base.postgres)
    StickyNoteManualTriggerPostgresWebhookSetCodeIFRespondToWebhookScheduleEmailSend
    23 nodesData Processing
    View on GitHub

    Need this workflow customized or debugged? Book a 30-min scope call →

    Want this set up for you? Book a 30-min scope call

    I build and fix n8n workflows for agencies and SaaS teams. 30-minute scope call — bring the problem, leave with an estimate.

    Related workflows