Weekly Energy Reports: API Fetch, Email & Google Drive

This n8n workflow streamlines energy monitoring by triggering every Monday at 8 AM via a Cron node to fetch hourly electricity consumption data from the EnergiDataService API (e.g., ConsumptionDE35Hour endpoint). The data, covering metrics like HourDK, Municipality, and ConsumptionkWh for regions like Copenhagen, is normalized in a Code node to create individual JSON items for processing.

Next, it formats the data into a structured CSV report, ideal for analysis in spreadsheets. The workflow then distributes the report via email using SMTP credentials and simultaneously uploads a copy to a specified Google Drive folder, ensuring accessibility and backup. This end-to-end automation eliminates manual data pulls and reporting tasks.

Benefits include significant time savings for energy providers, facility managers, and sustainability teams, reducing errors in data handling and enabling consistent weekly insights. Use cases span renewable energy operators tracking consumption trends, municipalities monitoring usage, or businesses complying with reporting requirements. Customize the Cron schedule, API endpoints, or add filters for tailored reporting.