Review electricity bills and flag anomalies with OpenAI, Google Sheets, and SendGrid
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Bill Data Validator Agent (v1.6), Advisory Report Generator Agent (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (11)
- Webhook
n8n-nodes-base.webhook - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Wait
n8n-nodes-base.wait - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Respond to Webhook
n8n-nodes-base.respondToWebhook - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets
What it does
Quick overview This workflow accepts electricity bill submissions via webhook or a monthly schedule, uses OpenAI to validate and summarize the bill, pulls up to 12 months of billing history and either returns an advisory report immediately or escalates high-severity cases via SendGrid email after a 24-hour wait. How it works 1. Receives a bill submission through a POST webhook or runs monthly on a cron schedule to recheck submitted bills. 2. Uses OpenAI to extract, normalize, and validate key bill fields (such as billing period, units consumed, bill amount, and tariff category) and rejects invalid submissions with an error response. 3. Fetches the account’s historical bill records from a Google Sheets BillsLog sheet and analyzes the most recent 12 months in Python to calculate a weighted anomaly score and severity. 4. Uses OpenAI to generate a plain-language advisory report based on the anomaly metrics and recommended next steps. 5. Returns the advisory report immediately and appends the result to Google Sheets for Normal and Moderate cases. 6. For High-severity cases, responds with an “escalation pending” message, waits 24 hours (with an optional resume webhook), then sends a support alert email via SendGrid and logs the escalated case to Google Sheets. Setup 1. Add an OpenAI API credential for the OpenAI Chat Model used by the extraction/validation and advisory generation steps. 2. Add Google Sheets OAuth2 credentials and replace YOURSHEETID in the Google Sheets API HTTP request and both Google Sheets append steps. 3. Add a SendGrid API key as an HTTP Header Auth credential (Authorization: Bearer <key) and set the verified sender/recipient details in the SendGrid email request payload. 4. If using the webhook intake, copy the production webhook URL from n8n and configure your app or gateway to POST the required bill fields to it. 5. Ensure your Google Sheets document contains a BillsLog sheet with columns that match the workflow’s expected row positions used for history parsing.