# Track supplier bills and missing invoices with Gmail, OpenAI, Sheets and Telegram

> Quick overview This workflow runs hourly to capture supplier bill PDFs from Gmail, extract key fields with OpenAI, and log them to Google Sheets with Telegram alerts for duplicates or anomalies, then runs every morning to learn supplier billing rhythms from the sheet and alert when expected bills are missing. How it works 1. Runs on two schedules: hourly to process incoming bill emails and daily to check for missing expected bills. 2. Searches Gmail for matching emails, downloads PDF attachments, and skips files already logged in the Google Sheets Bills tab. 3. Extracts text from each PDF and sends readable documents to OpenAI to return structured bill data (supplier, dates, currency, totals, category, and confidence). 4. Validates and classifies each document as OK, Needs review, Duplicate, or Ignored by checking missing fields, total consistency, AI confidence, duplicates, and unusual price jumps against prior bills. 5. Appends one row per processed file to the Google Sheets Bills ta

- **Domain**: `n8n-workflow-22422.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/22422
- Page (HTML): https://agenstry.com/agents/n8n-workflow-22422.n8n.io
- Documentation: https://n8n.io/workflows/22422
