Automate NGO aid request management with Telegram, GPT-4, and Google Sheets
Needs changesWhat this workflow does
This AI workflow has 12 nodes and runs on Telegram events (message). Along the way it connects Telegram, OpenAI, OpenAI Chat Model and Google Sheets.
How it runs
Trigger: On Telegram events (message).
- Route Message Type (Switch): routes items into 2 branches
- Extract Text Message (Edit Fields (Set)): sets 1 field: text
- Fetch Audio File (Telegram): work with file
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Transcribe Voice Message (OpenAI): transcribe (audio)
- Route to Appropriate Sheet (Switch): routes items into 2 branches
- Save Audio Request to Sheet (Google Sheets): append or update
- Save Text Request to Sheet (Google Sheets): append or update
- Send Confirmation Message (Telegram): uses Telegram
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - Switch
n8n-nodes-base.switch - Telegram
n8n-nodes-base.telegram - OpenAI
@n8n/n8n-nodes-langchain.openAi - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Sheets
n8n-nodes-base.googleSheets - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured
From the author
NGO TPM Request Management System Benefits For Beneficiaries: - 24/7 Accessibility - Submit requests anytime via familiar Telegram interface - Language Flexibility - Communicate in Arabic through text or voice messages - Instant Acknowledgment - Receive…