Generate weekly energy consumption reports with EnergiDataService, email and Google Drive
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Cron. 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 6 nodes and runs on a schedule (legacy Cron node). Along the way it connects Google Drive. It also calls api.energidataservice.dk over HTTP.
How it runs
Trigger: On a schedule (legacy Cron node).
- Fetch Energy Data (HTTP Request): calls api.energidataservice.dk
- Normalize Records (Code): runs custom JavaScript code
- Convert to File: converts data to a file
- Send Email: sends an email over SMTP
- Report File Upload to Google Drive (Google Drive): uses Google Drive
Services it uses
HTTP calls to: api.energidataservice.dk
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron in Schedule Weekly (Mon 8AM): replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Schedule Weekly (Mon 8AM) | Schedule Trigger |
Nodes used (6)
- Cron
n8n-nodes-base.cron - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Convert to File
n8n-nodes-base.convertToFile - Send Email
n8n-nodes-base.emailSend - Google Drive
n8n-nodes-base.googleDrive
From the author
📊 Generate Weekly Energy Consumption Reports with API, Email and Google Drive This workflow automates the process of retrieving energy consumption data, formatting it into a CSV report, and distributing it every week via email and Google Drive. ⚡ Quick…