Postgres Smtp Approval Requests With Approve Reject Email Links

    What this workflow does

    The workflow contains these steps: Run Once to Create Table → Create Approval Table → Approval Request Form → Decision Link Opened → Decision Submitted → Every 15 Minutes → Approval Settings → Validate Request → Request Valid? → Save Request → Request Not Valid → Email Approver → Could Not Save Request → Request Sent → Mark Request Not Sent → Approver Not Reached → Check Link → Look Up Request → Build Confirmation Page → Check Decision → Record Decision → Decision Recorded? → Email Requester Decision → Save Decision Email Error → Build Result Page → Send Page → Send Database Unavailable Page → Expire Overdue Requests → Any Expired? → Email Requester Expired → Save Expiry Email Error → Claim Due Reminders → Any Reminders? → Email Approver Reminder → Release Reminder Claim.

    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.
    • FormTrigger access for the FormTrigger steps listed in this workflow.
    • Webhook access for the Webhook steps listed in this workflow.
    • Schedule access for the Schedule 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.
    • Form access for the Form steps listed in this workflow.
    • EmailSend access for the EmailSend steps listed in this workflow.
    • RespondToWebhook access for the RespondToWebhook steps listed in this workflow.

    Workflow nodes

    1. Run Once to Create Table (n8n-nodes-base.manualTrigger)
    2. Create Approval Table (n8n-nodes-base.postgres)
    3. Approval Request Form (n8n-nodes-base.formTrigger)
    4. Decision Link Opened (n8n-nodes-base.webhook)
    5. Decision Submitted (n8n-nodes-base.webhook)
    6. Every 15 Minutes (n8n-nodes-base.scheduleTrigger)
    7. Approval Settings (n8n-nodes-base.set)
    8. Validate Request (n8n-nodes-base.code)
    9. Request Valid? (n8n-nodes-base.if)
    10. Save Request (n8n-nodes-base.postgres)
    11. Request Not Valid (n8n-nodes-base.form)
    12. Email Approver (n8n-nodes-base.emailSend)
    13. Could Not Save Request (n8n-nodes-base.form)
    14. Request Sent (n8n-nodes-base.form)
    15. Mark Request Not Sent (n8n-nodes-base.postgres)
    16. Approver Not Reached (n8n-nodes-base.form)
    17. Check Link (n8n-nodes-base.code)
    18. Look Up Request (n8n-nodes-base.postgres)
    19. Build Confirmation Page (n8n-nodes-base.code)
    20. Check Decision (n8n-nodes-base.code)
    21. Record Decision (n8n-nodes-base.postgres)
    22. Decision Recorded? (n8n-nodes-base.if)
    23. Email Requester Decision (n8n-nodes-base.emailSend)
    24. Save Decision Email Error (n8n-nodes-base.postgres)
    25. Build Result Page (n8n-nodes-base.code)
    26. Send Page (n8n-nodes-base.respondToWebhook)
    27. Send Database Unavailable Page (n8n-nodes-base.respondToWebhook)
    28. Expire Overdue Requests (n8n-nodes-base.postgres)
    29. Any Expired? (n8n-nodes-base.if)
    30. Email Requester Expired (n8n-nodes-base.emailSend)
    31. Save Expiry Email Error (n8n-nodes-base.postgres)
    32. Claim Due Reminders (n8n-nodes-base.postgres)
    33. Any Reminders? (n8n-nodes-base.if)
    34. Email Approver Reminder (n8n-nodes-base.emailSend)
    35. Release Reminder Claim (n8n-nodes-base.postgres)
    StickyNoteManualTriggerPostgresFormTriggerWebhookScheduleSetCodeIFFormEmailSendRespondToWebhook
    40 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