AI Agents

AI Agent: Track expenses in Google Sheets and n8n chat

10 nodes 228 134 Automatic trigger
Download

Workflow Description

An intelligent agent that engages users via n8n chat to log and track expenses directly into Google Sheets, while maintaining conversation context and extracting expense details from user messages.

How it works

  1. 1.Activate the agent when a new message arrives in n8n chat
  2. 2.Process the message using OpenAI to extract expense data (amount, category, description)
  3. 3.Store conversation context and previous data in memory for improved follow-up responses
  4. 4.Insert the extracted expense record into Google Sheets in an organized format
  5. 5.Send a confirmation message back to the user through the chat interface

Use cases

  • Enable decentralized team expense management through natural conversation
  • Automatically capture employee expenses without requiring manual form submission
  • Maintain a centralized expense log with filtering by category, date, or department

Requirements

  • Google Sheets account with write permissions
  • Valid OpenAI API key configured
  • n8n instance supporting AI agents and chat triggers

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 228
Downloads 134

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