{"product_id":"n8n-bank-sms-to-google-sheets-telegram-claude-bot","title":"n8n Bank SMS to Google Sheets + Telegram Claude Bot","description":"\u003ch3\u003eBank SMS → Google Sheets ledger + Claude-powered Telegram answers (n8n workflow)\u003c\/h3\u003e\n\u003cp\u003eTurn forwarded bank SMS alerts into structured expense records in Google Sheets, and ask “How much did I spend on X?” directly in Telegram—powered by an Anthropic Claude LangChain agent that reads your ledger and review queue.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eReceives bank SMS via webhook:\u003c\/b\u003e An authenticated \u003cb\u003esecured webhook\u003c\/b\u003e accepts forwarded SMS messages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eParses and normalizes transaction text:\u003c\/b\u003e The workflow extracts fields such as \u003cb\u003eamount, debit\/credit, date, merchant, payment method, reference ID, and account last 4\u003c\/b\u003e, while \u003cb\u003erejecting OTPs and non-allowlisted senders\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRoutes complete vs incomplete messages:\u003c\/b\u003e\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cb\u003eComplete, valid transactions\u003c\/b\u003e are \u003cb\u003eupserted\u003c\/b\u003e into the \u003cb\u003eExpenses\u003c\/b\u003e tab and return a \u003cb\u003e200 JSON confirmation\u003c\/b\u003e.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cb\u003eIncomplete but not rejected\u003c\/b\u003e SMS messages are \u003cb\u003eupserted\u003c\/b\u003e into \u003cb\u003eReview_Queue\u003c\/b\u003e and return a \u003cb\u003e200 JSON\u003c\/b\u003e response indicating \u003cb\u003emanual review\u003c\/b\u003e is needed.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cb\u003eRejected SMS\u003c\/b\u003e (e.g., OTP or unknown sender) returns a \u003cb\u003e422 JSON rejection response\u003c\/b\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAnswers questions in Telegram using Claude:\u003c\/b\u003e On incoming Telegram messages, the workflow sends your question to a \u003cb\u003eLangChain agent\u003c\/b\u003e using \u003cb\u003eAnthropic Claude\u003c\/b\u003e with short-term conversation memory. The agent reads \u003cb\u003etransactions\u003c\/b\u003e and the \u003cb\u003eReview_Queue\u003c\/b\u003e from Google Sheets, uses a calculator tool for exact math, and replies with a plain-text answer in the same chat.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate personal or business expense tracking from bank SMS without manual entry.\u003c\/li\u003e\n  \u003cli\u003eCatch ambiguous SMS alerts in \u003cb\u003eReview_Queue\u003c\/b\u003e instead of losing transaction data.\u003c\/li\u003e\n  \u003cli\u003eAsk spending questions in \u003cb\u003eTelegram\u003c\/b\u003e while trusting the ledger and exact calculations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes\/tools:\u003c\/b\u003e webhook, if, code, telegram, and Google Sheets (plus sticky note for documentation).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets setup:\u003c\/b\u003e Use a spreadsheet with \u003cb\u003eExpenses\u003c\/b\u003e and \u003cb\u003eReview_Queue\u003c\/b\u003e tabs (columns matching the workflow fields) and connect \u003cb\u003eGoogle Sheets OAuth2\u003c\/b\u003e credentials.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46164212678835,"sku":"N8N-20482","price":59.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/L1Fck0Q_28i1d_7TcfPqe_H4TfqADN.png?v=1791278279","url":"https:\/\/buyflowscripts.com\/products\/n8n-bank-sms-to-google-sheets-telegram-claude-bot","provider":"N8N Commerce","version":"1.0","type":"link"}