Workflow: PG&E Daily Cost Tracker
Integrations: airtop, gmail, scheduleTrigger, set, stickyNote, stopAndError, wait

{"id": "NMGsDLoVZ7DUukGs", "meta": {"instanceId": "workflow-ef945ffb", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:59.410950", "updatedAt": "2025-09-29T07:07:59.410963", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "name": "PG&E Daily Cost Tracker", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "nodes": [{"id": "814cc9ac-382b-42b3-b5b8-90eda0dc2889", "name": "Schedule Trigger", "type": "n8n-nodes-base.scheduleTrigger", "position": [-2640, 100], "parameters": {"rule": {"interval": [{"triggerAtHour": 8}]}}, "typeVersion": 1.2, "notes": "This scheduleTrigger node performs automated tasks as part of the workflow."}, {"id": "310bfb08-2086-4f0f-8790-02c2c186bae2", "name": "Type password", "type": "n8n-nodes-base.airtop", "position": [-1540, 100], "parameters": {"text": "={{ $('Variables').item.json.PGE_Password }}", "resource": "interaction", "windowId": "={{ $('Create browser window').item.json.windowId }}", "operation": "type", "sessionId": "={{ $('Create session').item.json.sessionId }}", "pressEnterKey": true, "additionalFields": {"waitForNavigation": "networkidle0"}, "elementDescription": "PASSWORD Text Box"}, "typeVersion": 1, "notes": "This airtop node performs automated tasks as part of the workflow."}, {"id": "b0de782e-9c54-4a40-b7e8-8e7ab3655986", "name": "Variables", "type": "n8n-nodes-base.set", "position": [-2420, 100], "parameters": {"options": {}, "assignments": {"assignments": [{"id": "3a765a8e-14d8-4a32-b894-b6f90e5db246", "name": "PGE_Username", "type": "string", "value": ""}, {"id": "81a94ea1-714b-4f9f-b63a-47fee5f51e3a", "name": "PGE_Password", "type": "string", "value": ""}, {"id": "e90a5678-4c62-443c-ab1d-57efd6ca69eb", "name": "Email", "type": "string", "value": ""}]}}, "typeVersion": 3.4, "notes": "This set node performs automated tasks as part of the workflow."}, {"id": "69cca1c7-9a83-43a7-95e7-98ba24f9575b", "name": "Go to \"Energy Costs\"", "type": "n8n-nodes-base.airtop", "position": [-660, 100], "parameters": {"resource": "interaction", "windowId": "={{ $('Create browser window').item.json.data.windowId }}", "sessionId": "={{ $('Create session').item.json.sessionId }}", "additionalFields": {"waitForNavigation": "load"}, "elementDescription": "ENERGY COSTS"}, "typeVersion": 1, "notes": "This airtop node performs automated tasks as part of the workflow."}, {"id": "184206ce-4b4d-4bb0-b468-cbb61f45b61b", "name": "Go to \"Electricity and Gas\"", "type": "n8n-nodes-base.airtop", "onError": "continueRegularOutput", "position": [-440, 100], "parameters": {"resource": "interaction", "windowId": "={{ $('Create browser window').item.json.data.windowId }}", "sessionId": "={{ $('Create session').item.json.sessionId }}", "additionalFields": {"waitForNavigation": "networkidle0"}, "elementDescription": "COMBINED"}, "typeVersion": 1, "notes": "This airtop node performs automated tasks as part of the workflow."}, {"id": "424b5209-97e7-4eef-a496-ac9f08d84d3d", "name": "Extract Costs", "type": "n8n-nodes-base.airtop", "notes": "Some PG&E accounts have a \"Combined\" view for gas and electricity", "position": [-220, 100], "parameters": {"prompt": "Extract the daily energy costs from the webpage content, including both natural gas and electricity costs. Format the information as a daily update email, listing the costs from the most recent date to the earliest. Ensure the email format is clear and concise, without including a subject line or greeting. Include the date, total combined costs, natural gas costs, and electricity costs for each day. \n\nIf natural gas costs are not provided, ignore them, ignore Total Combined Costs and report only on electricity \n\nFor example, if the webpage content provides the following data:\n\n- Date: 2023-10-01, Total Combined Costs: $15.00, Natural Gas Costs: $5.00, Electricity Costs: $10.00\n- Date: 2023-09-30, Total Combined Costs: $14.50, Natural Gas Costs: $4.50, Electricity Costs: $10.00\n\nThe output should be formatted as an easy to read email:\n\n<!DOCTYPE html>\n<html>\n<body>\n<p>October 1, 2023</p>\n<p>Total Combined Costs: $15.00<br>\nNatural Gas Costs: $5.00<br>\nElectricity Costs: $10.00</p>\n\n<p>September 30, 2023</p>\n<p>Total Combined Costs: $14.50<br>\nNatural Gas Costs: $4.50<br>\nElectricity Costs: $10.00</p>\n</body>\n</html>\n", "resource": "extraction", "windowId": "={{ $('Create browser window').item.json.data.windowId }}", "operation": "query", "sessionId": "={{ $('Create session').item.json.sessionId }}", "additionalFields": {}}, "notesInFlow": true, "typeVersion": 1}, {"id": "b0cf1ebc-157d-4ab3-9ed6-267c81293feb", "name": "Go to \"Energy Usage Details\"", "type": "n8n-nodes-base.airtop", "position": [-880, 100], "parameters": {"resource": "interaction", "windowId": "={{ $('Create browser window').item.json.windowId }}", "sessionId": "={{ $('Create session').item.json.sessionId }}", "additionalFields": {"waitForNavigation": "load"}, "elementDescription": "Click on the box that says ENERGY USAGE DETAILS See usage & costs over time"}, "typeVersion": 1, "notes": "This airtop node performs automated tasks as part of the workflow."}, {"id": "485f8071-9c54-4f79-9378-d354260b2038", "name": "Wait 5 secs", "type": "n8n-nodes-base.wait", "position": [-1100, 100], "webhookId": "371deac7-bd64-4385-8bc5-a14a0db2bcc7", "parameters": {}, "typeVersion": 1.1, "notes": "This wait node performs automated tasks as part of the workflow."}, {"id": "87d68490-1064-4180-89d9-534c9308c6c9", "name": "Close modal (if any)", "type": "n8n-nodes-base.airtop", "position": [-1320, 100], "parameters": {"resource": "interaction", "windowId": "={{ $('Create browser window').item.json.windowId }}", "sessionId": "={{ $('Create session').item.json.sessionId }}", "additionalFields": {}, "elementDescription": "If there is a modal on the page, click on the button to dismiss the modal"}, "typeVersion": 1, "notes": "This airtop node performs automated tasks as part of the workflow."}, {"id": "80018e55-6557-4641-a07b-926517a72bb0", "name": "Create session", "type": "n8n-nodes-base.airtop", "position": [-2200, 100], "parameters": {"profileName": "cesar-prod", "timeoutMinutes": 5}, "typeVersion": 1, "notes": "This airtop node performs automated tasks as part of the workflow."}, {"id": "05711cf0-9c20-4f41-854e-dea872eee3d8", "name": "Create browser window", "type": "n8n-nodes-base.airtop", "position": [-1980, 100], "parameters": {"url": "{{ $env.WEBHOOK_URL }}", "resource": "window", "getLiveView": true, "disableResize": true, "additionalFields": {"waitUntil": "load"}}, "typeVersion": 1, "notes": "This airtop node performs automated tasks as part of the workflow."}, {"id": "d673347d-ef40-4349-a7e7-2ba594400d2c", "name": "Type username", "type": "n8n-nodes-base.airtop", "position": [-1760, 100], "parameters": {"text": "={{ $('Variables').item.json.PGE_Username }}", "resource": "interaction", "operation": "type", "additionalFields": {}, "elementDescription": "USERNAME text box"}, "typeVersion": 1, "notes": "This airtop node performs automated tasks as part of the workflow."}, {"id": "b64a04b1-d00b-4d04-b9e3-7d2c86800923", "name": "Send email", "type": "n8n-nodes-base.gmail", "position": [0, 200], "webhookId": "7586d2f6-00b8-41ee-89d0-f2768b402165", "parameters": {"sendTo": "={{ $('Variables').item.json.Email }}", "message": "={{ $json['data'].modelResponse }}", "options": {"senderName": "Airtop Monitor", "appendAttribution": false}, "subject": "Daily energy costs report"}, "typeVersion": 2.1, "notes": "This gmail node performs automated tasks as part of the workflow."}, {"id": "d402443c-ed67-4df7-b5c8-032f4a2ea941", "name": "End session", "type": "n8n-nodes-base.airtop", "position": [0, 0], "parameters": {"operation": "terminate", "sessionId": "={{ $('Create session').item.json.sessionId }}"}, "typeVersion": 1, "notes": "This airtop node performs automated tasks as part of the workflow."}, {"id": "076e7eed-e71f-4ef7-8038-ea3dcc188b9c", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [-2480, -40], "parameters": {"color": 5, "height": 340, "content": "## Heads up!\nTo get this workflow running correctly, please enter your PG&E credentials below"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "error-1f408a1f", "name": "Error Handler", "type": "n8n-nodes-base.stopAndError", "typeVersion": 1, "position": [1000, 400], "parameters": {"message": "Workflow execution error", "options": {}}}], "active": false, "pinData": {}, "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "versionId": "0d0d4991-e9c1-4f51-be90-bb8337e40bc2", "connections": {}, "description": "Automated workflow: PG&E Daily Cost Tracker. This workflow integrates 6 different services: stickyNote, wait, scheduleTrigger, set, airtop. It contains 15 nodes and follows best practices for error handling and security.", "notes": "Excellent quality workflow: PG&E Daily Cost Tracker. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}