AI Agents

AI Agent: Track expenses in Google Sheets and n8n chat

10 nodes 245 147 Automatic trigger
Download

Workflow Description

An intelligent agent that interacts through n8n chat to track your expenses and automatically record them in Google Sheets, maintaining a structured conversation history for easy retrieval and analysis.

How it works

  1. 1.Activate the chat trigger and wait for the user to report a new expense
  2. 2.Process the message using OpenAI to extract amount, category, and description details
  3. 3.Store the conversation context in n8n memory for session continuity
  4. 4.Extract structured data and send it to Google Sheets as a new row
  5. 5.Reply to the user with confirmation and remaining budget status

Use cases

  • Small business employees managing daily expenses efficiently without extra tools
  • Freelancers who want to document operational costs through natural conversation

Requirements

  • Google account with edit permissions on Google Sheets
  • OpenAI API key for intelligent text processing
  • Basic familiarity with n8n triggers and workflow configuration

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

AI Agent Chat Trigger Twitter/X OpenAI Memory Google Sheets Tool

Details

Trigger Automatic trigger
Nodes 10
Apps 7
Views 245
Downloads 147

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (10)

AI Agent

Agent

#1

When chat message received

Chat Trigger

#2

Workflow Input Trigger

Execute Workflow Trigger

#3

OpenAI Chat Model

OpenAI

#4

Window Buffer Memory

Memory Buffer Window

#5

Sticky Note

Sticky Note

#6

OpenAI Chat Model1

OpenAI

#7

Expense text to JSON parser

Information Extractor

#8

Save expense into Google Sheets

Google Sheets

#9

Parse msg and save to Sheets

Tool Workflow

#10