PG&E Daily Cost Tracker

PG&E Daily Cost Tracker automates the daily tracking of energy costs, providing timely updates on natural gas and electricity expenses. By extracting and formatting cost data into a clear email report, it ensures users stay informed about their energy usage and expenses, helping them manage their bills effectively.

7/8/2025
15 nodes
Complex
yjgnihos9kz1hkjsschedulecomplexschedule triggerairtopwaitgmailsticky noteautomationadvancedcron
Categories:
Communication & MessagingSchedule TriggeredComplex Workflow
Integrations:
Schedule TriggerAirtopWaitGmailSticky Note

Target Audience

Target Audience


- PG&E Customers: Individuals looking to track their daily energy costs effectively.
- Financial Analysts: Professionals needing to analyze energy expenses over time for budgeting purposes.
- Homeowners: Those wanting to manage their utility bills and reduce costs by monitoring energy usage.
- Automation Enthusiasts: Users interested in automating routine tasks related to energy monitoring.

Problem Solved

Problem Solved


This workflow automates the process of tracking daily energy costs from PG&E, eliminating the need for manual data entry and monitoring. It ensures users receive timely updates on their energy expenses, which can help in budgeting and identifying trends in energy usage. By sending a structured email report, it provides a clear overview of costs, making it easier to understand and manage energy bills.

Workflow Steps

Workflow Steps


1. Schedule Trigger: The workflow is initiated daily at 8:00 AM.
2. Variable Setup: User credentials (username, password, and email) are defined for accessing PG&E.
3. Session Creation: A session is established to interact with the PG&E website.
4. Browser Window Creation: A browser window is opened to navigate to the PG&E mobile site.
5. Username Entry: The workflow types the username into the appropriate field.
6. Password Entry: The password is entered, followed by pressing 'Enter' to log in.
7. Navigation to Energy Costs: The workflow navigates to the "Energy Costs" section of the website.
8. Navigation to Electricity and Gas: It then goes to the "Electricity and Gas" section to extract relevant cost data.
9. Extract Costs: Daily energy costs are extracted from the webpage content, formatted for email reporting.
10. Navigate to Energy Usage Details: The workflow checks the energy usage details for further insights.
11. Wait: A 5-second wait is implemented to ensure page elements are fully loaded.
12. Close Modal: If any modals appear, they are dismissed to avoid interruptions.
13. Email Sending: The extracted costs are sent as a structured email to the user’s specified email address.
14. Session Termination: The session is closed after the email is sent, completing the workflow.

Customization Guide

Customization Guide


- Credentials: Update the PGE_Username, PGE_Password, and Email fields in the Variables node to match your PG&E account information.
- Schedule Timing: Adjust the triggerAtHour in the Schedule Trigger node to change the time the workflow runs.
- Email Formatting: Modify the email content in the Extract Costs node to customize the format or details included in the report.
- Additional Data Extraction: If you want to include more data points, update the extraction prompt in the Extract Costs node to specify what additional information should be retrieved from the PG&E website.