Weekly Energy Reports: API Fetch, Email & Google Drive
Automates weekly retrieval of energy consumption data from EnergiDataService API, generates CSV reports, emails them, and uploads to Google Drive every Monday at 8 AM.
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 th
- Platform
- n8n
- Category
- Education
- Price
- $14.99
- Creator
- Arjun Radu
- energy
- reports
- api
- google drive
- cron
- csv
- automation
- business intelligence
- sustainability
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Education workflows
- Learn JSON Basics with an Interactive Step-by-Step Tutorial for Beginners$14.99
- Learn n8n Expressions with an Interactive Step-by-Step Tutorial for Beginners$14.99
- Automated AI Degree Audit Using Google Sheets and OpenAI$9.99
- Learn API Fundamentals with an Interactive Hands-On Tutorial Workflow$24.99
- Master Webhook Integration and Security with Supabase in n8n$14.99
- Master JavaScript Code Node with Interactive n8n Tutorial$9.99
More from Arjun Radu
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.