Библиотека / ИИ-агенты и ассистенты
ИИ-агенты и ассистенты
Учёт расходов в Google Sheets с агентом OpenAI
Когда приходит сообщение в чате или вызов из другого рабочего процесса, агент OpenAI с памятью преобразует текст о расходах в структурированные данные и записывает их в Google Sheets.
Что делает
# 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
Шаги
- 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
Похожие автоматизации
ИИ-агенты и ассистентыRescue no-show appointments with OpenAI, Twilio SMS, and Google SheetsШагов: 29ИИ-агенты и ассистентыCreate researched newsletter drafts from Google Sheets with Tavily, OpenAI, and MailerLiteШагов: 22ИИ-агенты и ассистентыОтветы на вопросы клиентов из Google Sheets с агентом OpenAIШагов: 15ИИ-агенты и ассистентыОтбор резюме с OpenAI и Google SheetsШагов: 17