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