Track expenses in Google Sheets with AI chat agent

How it works

1. 1.Receive user message through n8n chat trigger
2. 2.Process message with AI agent powered by OpenAI model
3. 3.Extract expense details (amount, category, date) from free-text input
4. 4.Save extracted data to dedicated Google Sheets spreadsheet
5. 5.Maintain conversation history in memory buffer for context
6. 6.Send confirmation message to user confirming expense logged

Use cases

• Enable employees to log daily expenses without switching applications
• Manage small project budgets with real-time expense tracking and categorization
• Build historical expense datasets for financial analysis and reporting
• Support multi-turn conversations to track related or recurring expenses

Requirements

• Active n8n account with permissions to create AI agents
• OpenAI API key for natural language processing capabilities
• Connected Google account with edit permissions on Google Sheets
• Basic understanding of expense data structure (categories, amounts, dates)

Service Value

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