{"product_id":"n8n-import-bank-statements-to-google-sheets-via-drive-openai","title":"n8n: Import Bank Statements to Google Sheets via Drive + OpenAI","description":"\u003ch3\u003eAutomatically import bank statements into Google Sheets—using Google Drive + OpenAI (with balance reconciliation)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches a specific Google Drive folder for new bank-statement files, extracts transactions using OpenAI, verifies that opening + transaction totals equal the closing balance, and then appends only new (non-duplicate) transactions to your Google Sheets—while emailing you when a statement fails reconciliation.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eMonitors your Google Drive folder\u003c\/b\u003e and triggers when a new statement PDF or CSV is created.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDownloads and extracts content\u003c\/b\u003e from the file (PDF text extraction or CSV-to-text) to capture the statement details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUses OpenAI to produce structured data\u003c\/b\u003e in JSON, including account details, statement period, opening\/closing balances, and a transaction list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eValidates balance integrity\u003c\/b\u003e by checking that opening balance plus all transaction amounts equals the closing balance (in integer cents), with optional identification of the first running-balance mismatch.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eHandles failures safely\u003c\/b\u003e: if reconciliation fails, it logs the refused import to Google Sheets and sends you a Gmail email describing the discrepancy and suspected sign error.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePrevents duplicates\u003c\/b\u003e: if reconciliation succeeds, it reads category rules and existing transaction fingerprints from Google Sheets, categorizes transactions, and keeps only transactions not previously imported.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAppends results\u003c\/b\u003e to the \u003ci\u003eTransactions\u003c\/i\u003e tab and writes a summary entry to an \u003ci\u003eImport log\u003c\/i\u003e tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFreelancers and SaaS operators importing monthly statements from bank exports into a single Google Sheets ledger.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing ingestion + categorization for recurring statement PDFs\/CSVs.\u003c\/li\u003e\n  \u003cli\u003eTeams needing reconciliation checks to catch parsing issues or sign mismatches before updating records.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Drive\u003c\/b\u003e: triggers on new files and downloads statement documents.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI\u003c\/b\u003e: converts extracted text into structured JSON (account, balances, transactions).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e: reads category rules and transaction fingerprints; appends new transactions and writes to an import log.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail\u003c\/b\u003e: emails alerts when a statement fails reconciliation.\u003c\/li\u003e\n  \u003cli\u003eAdditional workflow logic uses nodes such as \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003esplit out\u003c\/b\u003e, and \u003cb\u003esticky note\u003c\/b\u003e for control flow and processing.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46094092665011,"sku":"N8N-19951","price":35.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/VWSxSqUVZFzdH7qnPZnD0_84WeP8ZZ.png?v=1790413479","url":"https:\/\/buyflowscripts.com\/products\/n8n-import-bank-statements-to-google-sheets-via-drive-openai","provider":"N8N Commerce","version":"1.0","type":"link"}