Bibliothek / KI-Agenten & Assistenten
KI-Agenten & Assistenten
Chat-Ausgaben mit einem KI-Agenten in Google Sheets erfassen
Verwendet ein LLM, um Ausgabenmeldungen aus dem n8n-Chat in strukturiertes JSON umzuwandeln, und speichert jede als Zeile in Google Sheets. Läuft bei jeder Chatnachricht.
Was sie bewirkt
## Save your expenses via chat message. LLM will parse your message to structured JSON and save as a new row into Google Sheet. ## Installation ### 1. Set up Google Sheets: Clone this Sheet: {{ $env.WEBHOOK_URL }} (File -> Make a copy) Choose this sheet into "Save expense into Google Sheets" node. ### 2. Fix sub-workflow dropdown: open "Parse msg and save to Sheets" node (which is an n8n sub-workflow executor tool) and choose the SAME workflow in the dropdown. it will allow n8n to call "Workflow Input Trigger" properly when needed. ### 3. Activate the workflow to make chat work properly. Sent message to chat, something like "car wash; 59.3 usd; 25 jan 2024" you should get a response: Your expense saved, here is the output of save sub-workflow:{"cost":59.3,"descr":"car wash","date":"2024-01-25","msg":"car wash; 59.3 usd; 25 jan 2024"} and new row in Google sheets should be inserted!
Die Schritte
- 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
Ähnliche Automatisierungen
KI-Agenten & AssistentenEdit and publish OrbitPage site content with OpenAI chat approval18 SchritteKI-Agenten & AssistentenMit einem OpenAI-Agenten mit einer Google-Tabelle chatten14 SchritteKI-Agenten & AssistentenMit YouTube-Kommentaren und -Kanälen per OpenAI chatten22 SchritteKI-Agenten & AssistentenMit einer PostgreSQL-Datenbank per OpenAI chatten10 Schritte