Library / AI Agents & Assistants
AI Agents & Assistants
Track Expenses in Google Sheets with an OpenAI Agent
When a chat message or workflow call arrives, an OpenAI agent with memory turns expense text into structured data and records it in Google Sheets.
What it does
# AI agent: expense tracker in Google Sheets and n8n chat ## Overview Automated workflow: AI agent: expense tracker in Google Sheets and n8n chat. This workflow integrates 10 different services: stickyNote, agent, informationExtractor, stopAndError, lmChatOpenAi. It contains 13 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 13 - Node Types: 10 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - AI Agent: agent - When chat message received: chatTrigger - Workflow Input Trigger: executeWorkflowTrigger - OpenAI Chat Model: lmChatOpenAi - Window Buffer Memory: memoryBufferWindow - Sticky Note: stickyNote - OpenAI Chat Model1: lmChatOpenAi - Expense text to JSON parser: informationExtractor - Save expense into Google Sheets: googleSheets - Parse msg and save to Sheets: toolWorkflow - ... and 3 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible
The steps
- AI Agent
- When chat message received
- Workflow Input Trigger
- OpenAI Chat Model
- Window Buffer Memory
- OpenAI Chat Model1
- Expense text to JSON parser
- Save expense into Google Sheets
- Parse msg and save to Sheets
- Error Handler for a1530601
- Error Handler for 61a489f7
- Error Handler for 23f123eb
- Error Handler
Similar automations
Finance, Invoices & AccountingTrack Expenses by Siri Voice with AI and Sheets9 stepsDocuments, PDF & OCRExtract Expenses from Videos with Gemini into Sheets19 stepsFinance, Invoices & AccountingExtract Expenses from Emailed Receipts into Google Sheets6 stepsFinance, Invoices & AccountingExtract Emailed Receipt Expenses into Sheets with Mindee16 steps