Automated monthly energy reports with PostgreSQL, PDF.co & email delivery

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 creation and ensures timely delivery of performance summaries.

Who’s it for

Energy companies monitoring solar, wind or hydro generation Operations & maintenance (O\&M) teams needing monthly summaries Managers and executives who require periodic performance reports Data analysts who want automated reporting instead of manual exports

How it works

1. Monthly Trigger → Schedules the workflow to run once a month. 2. Postgres Node → Fetches energy data from the energydata table. 3. Code Node (Transform Data) → Structures the raw records into JSON with metadata (daterange, records, note). 4. HTTP Request (PDF.co API) → Converts structured data into a formatted PDF report. 5. Gmail Node (Send Report) → Sends the PDF report (or link) via email to the configured recipient.

How to set up

1. Import the workflow JSON into n8n. 2. Configure credentials: