Curated

(5/5)

Reconcile Rent Payments with Local Excel Spreadsheet and OpenAI

Step 1. Wait For Incoming Bank Statements [Read more about the local file triggers](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.localfiletrigger) For this demo, we'll show that n8n is more than capable working with the local filesystem. This gives great benefits in terms of privacy and data security. For our datastore, we're using a locally hosted XLSX Excel file which we'll query and update throughout this workflow.

Integrations Used (6)

Localfile

Toolcode

Outputparserstructured

Readwritefile

Lmchatopenai

Agent

Workflow Structure (11 nodes)

100%

Local File Trigger

Watch For Bank Statements

Set

Set Variables

Read Write File

Get Bank Statement File

Extract From File

Get CSV Data

Langchain.lm Chat Open Ai

OpenAI Chat Model

Langchain.agent

Reconcile Rental Payments

Langchain.tool Code

Get Tenant Details

Langchain.tool Code

Get Property Details

Langchain.output Parser Structured

Structured Output Parser

Split Out

Alert Actions To List

Code

Append To Spreadsheet

Node Types:

trigger

code

default

logic

transform

Requires credentials

Prerequisites

Required Credentials (1)

OpenAI

Used by: OpenAI Chat Model

Docs

Complexity

Complex

Advanced features used. Requires n8n experience.

Setup time: ~30 min

Score: 48/100

Custom Code

When to Use This Workflow

AI-Powered Content Creation

Automate content generation, summarization, or analysis using AI capabilities.

Save hours of manual work while maintaining quality and consistency.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json

{
  "meta": {
    "instanceId": "26ba763460b97c249b82942b23b6384876dfeb9327513332e743c5f6219c2b8e"
  },
  "nodes": [
    {
      "id": "bebbf9cf-8103-4694-a3be-ae3ee1e9ebaf",
      "name": "Watch For Bank Statements",
      "type": "n8n-nodes-base.localFileTrigger",
      "position": [
        780,
        400
      ],
      "parameters": {
        "path": "/home/node/host_mount/reconciliation_project",
        "events": [
          "add"
        ],
        "options": {
          "ignored": "!**/*.csv"
...