Generate weekly energy consumption reports with EnergiDataService, email and Google Drive

📊 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 Implementation Steps: - Import the workflow into your n8n instance. - Configure your API, email details and Google Drive folder. - (Optional) Adjust the CRON schedule if you need a different time or frequency. - Activate workflow—automated weekly reports begin immediately.

🎯 Who’s It For Energy providers, sustainability departments, facility managers, renewable energy operators.

🛠 Requirements - n8n instance - Energy Consumption API access - Google Drive account - Email SMTP access

⚙️ How It Works Workflow triggers every Monday at 8 AM, fetches consumption data, emails CSV report and saves a copy to Google Drive.

🔄 Workflow Steps

1. Schedule Weekly (Mon 8:00 AM) - Type: Cron Node - Runs every Monday at 8:00 AM. - Triggers the workflow execution automatically.