Automated monthly energy reports with PostgreSQL, PDF.co & email delivery
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 5 nodes and runs on a schedule (every month). Along the way it connects Gmail and Postgres. It also calls api.pdf.co over HTTP.
How it runs
Trigger: On a schedule (every month).
- Get energy data (Postgres): select
- Transform data (Code): runs custom JavaScript code
- Convert data to pdf (HTTP Request): calls api.pdf.co
- Send Report (Gmail): uses Gmail
Services it uses
HTTP calls to: api.pdf.co
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Gmail
n8n-nodes-base.gmail - Postgres
n8n-nodes-base.postgres - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Monthly Energy Generation Report (PostgreSQL → PDF → Email) This workflow automatically collects monthly energy generation data from a PostgreSQL database, converts it into a structured PDF report and emails it to stakeholders. It eliminates manual report…