# Track bank SMS expenses with Google Sheets, Telegram and Claude

> Quick overview This workflow captures bank SMS alerts via a secured webhook, parses them into structured transactions, and stores them in Google Sheets, while also running a Telegram bot powered by Anthropic Claude to answer spending questions using the ledger and a review queue. How it works 1. Receives forwarded bank SMS messages through an authenticated webhook request. 2. Parses and normalizes the SMS text to extract fields like amount, debit/credit, date, merchant, payment method, reference ID, and account last 4, while rejecting OTPs and non-allowlisted senders. 3. If the SMS is a complete, valid transaction, upserts it into the Google Sheets Expenses ledger and returns a 200 JSON confirmation to the sender. 4. If the SMS is incomplete but not rejected, upserts it into a Google Sheets ReviewQueue tab and returns a 200 JSON response indicating manual review is needed. 5. If the SMS is rejected (for example OTP or unknown sender), returns a 422 JSON rejection response. 6. Triggers 

- **Domain**: `n8n-workflow-20482.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/20482
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20482.n8n.io
- Documentation: https://n8n.io/workflows/20482