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
- Run Once to Create Table (n8n-nodes-base.manualTrigger)
- Create Approval Table (n8n-nodes-base.postgres)
- Approval Request Form (n8n-nodes-base.formTrigger)
- Decision Link Opened (n8n-nodes-base.webhook)
- Decision Submitted (n8n-nodes-base.webhook)
- Every 15 Minutes (n8n-nodes-base.scheduleTrigger)
- Approval Settings (n8n-nodes-base.set)
- Validate Request (n8n-nodes-base.code)
- Request Valid? (n8n-nodes-base.if)
- Save Request (n8n-nodes-base.postgres)
- Request Not Valid (n8n-nodes-base.form)
- Email Approver (n8n-nodes-base.emailSend)
- Could Not Save Request (n8n-nodes-base.form)
- Request Sent (n8n-nodes-base.form)
- Mark Request Not Sent (n8n-nodes-base.postgres)
- Approver Not Reached (n8n-nodes-base.form)
- Check Link (n8n-nodes-base.code)
- Look Up Request (n8n-nodes-base.postgres)
- Build Confirmation Page (n8n-nodes-base.code)
- Check Decision (n8n-nodes-base.code)
- Record Decision (n8n-nodes-base.postgres)
- Decision Recorded? (n8n-nodes-base.if)
- Email Requester Decision (n8n-nodes-base.emailSend)
- Save Decision Email Error (n8n-nodes-base.postgres)
- Build Result Page (n8n-nodes-base.code)
- Send Page (n8n-nodes-base.respondToWebhook)
- Send Database Unavailable Page (n8n-nodes-base.respondToWebhook)
- Expire Overdue Requests (n8n-nodes-base.postgres)
- Any Expired? (n8n-nodes-base.if)
- Email Requester Expired (n8n-nodes-base.emailSend)
- Save Expiry Email Error (n8n-nodes-base.postgres)
- Claim Due Reminders (n8n-nodes-base.postgres)
- Any Reminders? (n8n-nodes-base.if)
- Email Approver Reminder (n8n-nodes-base.emailSend)
- Release Reminder Claim (n8n-nodes-base.postgres)
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.