Weekly Energy Reports: API Fetch, Email & Google Drive - n8n Workflow | Neura Market
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
QualityWorkflows
energy
reports
api
email
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.