What This Workflow Does
This automation solution eliminates the tedious manual process of compiling weekly energy consumption reports. It connects directly to EnergiDataService API to pull the latest consumption metrics, formats the data into professional reports, and distributes them automatically via email and Google Drive.
Facility managers, sustainability teams, and operations leaders spend hours each week gathering energy data from multiple sources, compiling spreadsheets, and sending reports. This workflow automates the entire process, ensuring stakeholders receive accurate, timely reports without manual intervention.
How It Works
1. Data Retrieval from EnergiDataService
The workflow begins by connecting to the EnergiDataService API to fetch the latest energy consumption metrics. It automatically handles authentication and pulls the relevant data points based on predefined parameters like time period, meter IDs, and energy types.
2. Data Processing and Analysis
Raw API data gets transformed into actionable insights. The workflow calculates week-over-week comparisons, identifies consumption anomalies, and computes cost implications based on current energy rates.
3. Report Generation
The system generates professional PDF reports with charts, tables, and executive summaries. Reports follow your organization's branding guidelines and include all key metrics decision-makers need.
4. Automated Distribution
Completed reports get saved to a designated Google Drive folder with proper naming conventions and timestamps. Simultaneously, email notifications with report links get sent to predefined distribution lists.
Pro tip: Configure the workflow to run every Monday morning to ensure stakeholders have fresh reports at the start of each work week.
Who This Is For
This automation is ideal for facilities management companies, corporate sustainability teams, property managers, and industrial operations with significant energy consumption. Any organization tracking energy usage across multiple sites or meters will benefit from automated reporting.
What You'll Need
- Access to EnergiDataService API (credentials required)
- Google Workspace account for Drive storage
- Email service (Gmail, Outlook, or SMTP server)
- n8n instance (self-hosted or cloud)
- Basic report template design
Quick Setup Guide
- Download and import the JSON workflow file into your n8n instance
- Configure the EnergiDataService API connection with your credentials
- Set up Google Drive and email service connections
- Customize report templates and distribution lists
- Schedule the workflow to run weekly
- Test with a small dataset before full implementation
Key Benefits
Save 5-10 hours weekly by eliminating manual data collection and report generation. Staff can focus on analyzing insights rather than compiling data.
Improve data accuracy by removing error-prone manual data entry. Automated systems ensure consistent, reliable reporting.
Timely decision-making with reports delivered automatically at the same time each week, rather than waiting for manual preparation.
Centralized documentation with all reports automatically archived in Google Drive for easy reference and compliance purposes.
Scalable solution that easily accommodates additional meters, sites, or report recipients without increasing workload.