AutomationMart
Home/Browse/Automate bank statement and invoice reconciliation with GPT and Google Sheets
n8n

Automate bank statement and invoice reconciliation with GPT and Google Sheets

n8nn8n16 modulesv1.0
Google SheetsOpenAI

Manual Trigger Workflow starts manually to initiate the reconciliation process on demand. ๐Ÿ“„ Fetch Invoices & Bank Statements Retrieves invoice data and bank statement data from Google Sheets for comparison. ๐Ÿ”€ Merge Data Combines both datasets into a single structured dataset for processing. ๐Ÿงฉ Format Payload for AI Function node prepares and structures the merged data into a clean JSON payload for AI analysis. ๐Ÿค– AI Reconciliation AI Agent analyzes the invoice and bank statement data to identify m

At a glance

Automate bank statement and invoice reconciliation with GPT and Google Sheets is a ready-made n8n workflow you import as a workflow JSON file โ€” no build required. It connects Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, OpenAI
Modules
16
Price
Free
Version
v1.0
Automate bank statement and invoice reconciliation with GPT and Google Sheets workflow diagram

About this workflow

Manual Trigger Workflow starts manually to initiate the reconciliation process on demand. ๐Ÿ“„ Fetch Invoices & Bank Statements Retrieves invoice data and bank statement data from Google Sheets for comparison. ๐Ÿ”€ Merge Data Combines both datasets into a single structured dataset for processing. ๐Ÿงฉ Format Payload for AI Function node prepares and structures the merged data into a clean JSON payload for AI analysis. ๐Ÿค– AI Reconciliation AI Agent analyzes the invoice and bank statement data to identify matches, discrepancies, and reconciled entries. ๐Ÿงฎ Parse AI Output Parses the AI response into a structured format suitable for adding back to Google Sheets. ๐Ÿ“Š Update Sheets Adds the reconciled data and reconciliation results into the target Google Sheet for recordkeeping. ๐Ÿงพ Prerequisites โœ… OpenAI API Credentials Required for the AI Reconciliation node to process and match transactions. Add your OpenAI API key in n8n โ†’ Credentials โ†’ OpenAI. โœ… Google Sheets Credentials Needed to read invoice and bank statement data and to write reconciled results. Add credentials in n8n โ†’ Credentials โ†’ Google Sheets. โœ… Google Sheets Setup The connected spreadsheet must contain the following tabs: Invoices โ€“ for invoice data BankStatement โ€“ for bank transaction data ReconciledData โ€“ for storing the AI-processed reconciliation output โœ… Tab Structure & Required Headers Invoices Sheet Columns: InvoiceID InvoiceDate CustomerName Amount Status BankStatement Sheet Columns: TransactionID TransactionDate Description Debit/Credit Amount ReconciledData Sheet Columns: InvoiceID TransactionID MatchedStatus Remarks ConfidenceScore โš™๏ธ n8n Environment Setup Ensure all nodes are connected correctly and the workflow has permission to access the required sheets. Test each fetch and write operation before running the full workflow.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n โ†’ click the menu โ†’ Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Add new Podio tasks to a Google Sheets spreadsheet as a new row

Every time a new task is created in a selected Podio workspace, Make will automatically add it to a specified Google Sheets spreadsheet as a new row. The template uses this [example spreadsheet](https://goo.gl/x4D69C).

Free

Complete business WhatsApp AI-powered RAG chatbot using OpenAI

The provided workflow in n8n is designed to create a Business WhatsApp AI RAG (Retrieval-Augmented Generation) Chatbot. --- How it works: 1. Webhook Setup: The workflow begins by setting up webhooks for verification and response. The Verify webhook receives GET requests and sends back a verification code, while the Respond webhook handles incoming POST requests from Meta regarding WhatsApp messages. 2. Message Handling: Once a message is received, the workflow checks if the inc

Free

Turn YouTube meeting recordings into Notion notes with AI Agent, deAPI & Slack

Who is this for? - Teams who upload meeting recordings to YouTube (unlisted or private) and want automated notes - Project managers who need to track action items across recurring meetings - Remote teams who want searchable, structured meeting notes in Notion - Content teams repurposing recorded calls into documentation What problem does this solve? Meeting notes are either rushed, incomplete, or never written at all. This workflow removes that bottleneck โ€” upload a recording to YouTube

Free

๐Ÿ’ฅ๐Ÿ› ๏ธBuild a web search chatbot with GPT-4o and MCP Brave Search

MCP AI Chatbot using Brave Search Disclaimer: This workflow only works with local installations of n8n because it uses a community MCP node Who is this for? This workflow is ideal for developers, automation enthusiasts, and businesses looking to integrate AI-powered chat capabilities into their workflows. It's particularly useful for those leveraging Brave Search and MCP tools to enhance user interactions and streamline data retrieval. What proble

Free

Generate SEO-optimized PWA website with Google Gemini and deploy to S3

Generate SEO-Optimized PWA Website with AI and Deploy to S3 Who's it for This workflow is designed for agencies, freelancers, and businesses who want to generate production-ready static websites with built-in SEO optimization and PWA (Progressive Web App) capabilities โ€” all without manual coding. It is best suited for users who need landing pages, portfolios, event pages, or client microsites that are mobile-friendly, SEO-optimized, and installable as apps on any device. What it does This workfl

Free

Auto-generate SEO blog posts with Perplexity, GPT, Leonardo & WordPress

SEO Blog Post Automation with Perplexity, GPT, Leonardo AI & WordPress This workflow automates the creation and publishing of weekly SEO-optimized blog posts using AI and publishes them directly to WordPress โ€” with featured images and tracking in Google Sheets. --- ๐Ÿง  Who is this for This automation is ideal for: - Startup platforms and tech blogs - Content creators and marketers - Solopreneurs who want consistent blog output - Spanish-speaking audiences focused on startup tren

Free

Automated email assistant for suppliers using OpenAI and Google Sheets

Automated Email Assistant for Busy Professionals This assistant is designed for people who don't have time to write and send emails to suppliers. With just one request, it drafts and sends clear, professional messages automatically. How It Works The user makes a request (e.g., โ€œSend an email to my fruit supplier asking for a quote on 1 crate of mangoes.โ€). Workflow: 1. The AI agent searches for the supplier in a Google Sheets database. 2. It automatically drafts the email using OpenAI (with the

Free

๐Ÿ› ๏ธ Transform JSON to XML for Enhanced AI Prompt Formatting

Overview This template provides a powerful and configurable utility to convert JSON data into a clean, well-structured XML format. It is designed for developers, data analysts, and n8n users who need to interface with legacy systems, generate structured reports, or prepare data for consumption by Large Language Models (LLMs), which often exhibit improved understanding and parsing with XML-formatted input. Use Cases This workflow is ideal for solving several common data transformation problems:

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint โ€” instant download
  • Setup guide PDF included
  • 5 downloads ยท valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

โ‚น2,499/ session
3 hrs ยท video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free