Curated

(5/5)

AI agent: expense tracker in Google Sheets and n8n chat

Save your expenses via chat message. LLM will parse your message to structured JSON and save as a new row into Google Sheet. Installation 1. Set up Google Sheets: Clone this Sheet: https://docs.google.com/spreadsheets/d/1D0r3tun7LF7Ypb21CmbTKEtn76WE-kaHvBCM5NdgiPU/edit?gid=0gid=0 (File -> Make a copy) Choose this sheet into "Save expense into Google Sheets" node. 2. Fix sub-workflow dropdown: open "Parse msg and save to Sheets" node (which is an n8n sub-workflow executor tool) and choose the

Integrations Used (8)

Workflow Structure (9 nodes)

100%

Langchain.chat Trigger

When chat message received

Langchain.lm Chat Open Ai

OpenAI Chat Model

Langchain.agent

AI Agent

Langchain.memory Buffer Window

Window Buffer Memory

Langchain.tool Workflow

Parse msg and save to Sheets

Execute Workflow Trigger

Workflow Input Trigger

Langchain.lm Chat Open Ai

OpenAI Chat Model1

Langchain.information Extractor

Expense text to JSON parser

Google Sheets

Save expense into Google Sheets

Node Types:

default

trigger

action

Requires credentials

Prerequisites

Required Credentials (2)

Google Sheets

Used by: Save expense into Google Sheets

Docs

OpenAI

Used by: OpenAI Chat Model, OpenAI Chat Model1

Docs

Complexity

Moderate

Some experience helpful. Multiple integrations or logic.

Setup time: ~25 min

Score: 29/100

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

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

{
  "id": "aLTkMiEDYXbMK4fT",
  "meta": {
    "instanceId": "5b860a91d7844b5237bb51cc58691ca8c3dc5b576f42d4d6bbedfb8d43d58ece",
    "templateCredsSetupCompleted": true
  },
  "name": "AI agent: expense tracker in Google Sheets and n8n chat",
  "tags": [],
  "nodes": [
    {
      "id": "9260b53e-6848-4f34-9643-311c58c807f6",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        360,
        40
      ],
      "parameters": {
        "options": {
          "maxIterations": 3,
...