Postgres Sales Dashboard With Period Comparison Via Webhook
What this workflow does
The workflow contains these steps: Run Once to Create Tables → Create Sales Tables → Add Demo Orders If Empty → Sales Dashboard Webhook → Weekly Report Schedule → Dashboard Settings → Validate Request → Request Valid? → Respond Bad Request → Load Sales Metrics → Browser Request? → Respond Database Unavailable → Fail Weekly Report Query → Build Report → Weekly Run? → Send Weekly Report Email → Fail Weekly Email → CSV Requested? → Respond CSV → Respond Dashboard.
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.
- 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.
- RespondToWebhook access for the RespondToWebhook steps listed in this workflow.
- StopAndError access for the StopAndError steps listed in this workflow.
- EmailSend access for the EmailSend steps listed in this workflow.
Workflow nodes
- Run Once to Create Tables (n8n-nodes-base.manualTrigger)
- Create Sales Tables (n8n-nodes-base.postgres)
- Add Demo Orders If Empty (n8n-nodes-base.postgres)
- Sales Dashboard Webhook (n8n-nodes-base.webhook)
- Weekly Report Schedule (n8n-nodes-base.scheduleTrigger)
- Dashboard Settings (n8n-nodes-base.set)
- Validate Request (n8n-nodes-base.code)
- Request Valid? (n8n-nodes-base.if)
- Respond Bad Request (n8n-nodes-base.respondToWebhook)
- Load Sales Metrics (n8n-nodes-base.postgres)
- Browser Request? (n8n-nodes-base.if)
- Respond Database Unavailable (n8n-nodes-base.respondToWebhook)
- Fail Weekly Report Query (n8n-nodes-base.stopAndError)
- Build Report (n8n-nodes-base.code)
- Weekly Run? (n8n-nodes-base.if)
- Send Weekly Report Email (n8n-nodes-base.emailSend)
- Fail Weekly Email (n8n-nodes-base.stopAndError)
- CSV Requested? (n8n-nodes-base.if)
- Respond CSV (n8n-nodes-base.respondToWebhook)
- Respond Dashboard (n8n-nodes-base.respondToWebhook)
StickyNoteManualTriggerPostgresWebhookScheduleSetCodeIFRespondToWebhookStopAndErrorEmailSend
25 nodesData Processing
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
N8n Data Tables Daily Backup To Postgres
34 nodesStickyNoteManualTriggerPostgres
Postgres Smtp Approval Requests With Approve Reject Email Links
40 nodesStickyNoteManualTriggerPostgres
Manual Postgres Automate Triggered
4 nodesManualTriggerSetPostgres
Postgres Smtp Email Queue That Prevents Duplicate Sends
33 nodesStickyNoteManualTriggerPostgres