PG&E Daily Cost Tracker: Automate Your Energy Bill Monitoring
detail.loadingPreview
Effortlessly track your daily PG&E electricity and natural gas costs with this automated workflow. Receive clear, concise reports directly to your inbox, ensuring you stay informed about your energy spending.
About This Workflow
The PG&E Daily Cost Tracker is a powerful n8n workflow designed to bring transparency to your energy consumption. It automates the process of logging into your PG&E account, navigating to your energy cost details, and extracting daily usage information. The workflow meticulously gathers data on electricity and natural gas costs, presenting it in an easy-to-read HTML format suitable for email delivery. This ensures you have a consistent and up-to-date overview of your spending, enabling better budgeting and informed decisions about your energy usage. Whether you have a combined billing statement or separate gas and electricity costs, this workflow adapts to provide accurate insights.
Key Features
- Automated Login & Navigation: Securely logs into your PG&E account and navigates to the relevant energy cost pages.
- Daily Cost Extraction: Accurately extracts daily electricity and natural gas costs from your account.
- Customizable Reporting: Generates clear, HTML-formatted reports ideal for email summaries.
- Flexible Data Handling: Accommodates accounts with combined or separate gas and electricity billing information.
- Scheduled Operation: Runs daily at a user-defined time (8 AM in this configuration).
How To Use
- Set Up Credentials: In the 'Variables' node, securely store your PG&E username, password, and your desired email address. Ensure these are kept private.
- Configure Schedule Trigger: Adjust the 'Schedule Trigger' node to your preferred daily execution time. The current setting is for 8 AM.
- Airtop Node Configuration: The 'Airtop' nodes (e.g., 'Create session', 'Create browser window', 'Type username', 'Type password', 'Go to "Energy Costs"', etc.) are pre-configured to interact with the PG&E website. Ensure your browser profile name ('cesar-prod') and timeout settings are appropriate for your environment.
- Define Extraction Prompt: Review and refine the 'prompt' within the 'Extract Costs' node if you require specific formatting or additional data points. The current prompt is designed to output an HTML report.
- Email Integration (Optional but Recommended): To receive the reports, you will need to add an 'Email' node after the 'Extract Costs' node. Configure the email node with your email server details and ensure it uses the output from 'Extract Costs' as its message body.
Apps Used
Workflow JSON
{
"id": "8233d4dd-d3e9-4098-ba38-b6de7b4f7534",
"name": "PG&E Daily Cost Tracker: Automate Your Energy Bill Monitoring",
"nodes": 15,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 8233d4dd-d3e9...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.