Create product satisfaction surveys with Telegram, Google Sheets and AI
Needs changesWhat this workflow does
This AI workflow has 33 nodes and runs on Telegram events (message). Along the way it connects Telegram, Redis, Google Sheets and Redis Chat Memory and 1 more.
How it runs
Trigger: On Telegram events (message).
- Set Variables (Edit Fields (Set)): sets 3 fields: title, gsheetId, cacheKey
- Execution Data: uses Execution Data
- Get State (Redis): get
- Message Type (Switch): routes items into 1 branches
- Get Command (Edit Fields (Set)): sets 1 field: command
- Get Record (Google Sheets): uses Google Sheets
- Bot Actions (Switch): routes items into 2 branches
- Has No Record? (If): checks a condition and branches into true / false
- Create Record (Google Sheets): append or update
- Get State (Redis): get
…plus 18 more steps. See the full node list below.
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 Interview Agent1 (v1.7): 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) Interview Agent1 (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (14)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - Telegram
n8n-nodes-base.telegram - If
n8n-nodes-base.if - Redis
n8n-nodes-base.redis - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Switch
n8n-nodes-base.switch - Redis Chat Memory
@n8n/n8n-nodes-langchain.memoryRedisChat - Chat Memory Manager
@n8n/n8n-nodes-langchain.memoryManager - AI Agent
@n8n/n8n-nodes-langchain.agent - HTTP Request
n8n-nodes-base.httpRequest - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Text Classifier
@n8n/n8n-nodes-langchain.textClassifier - Execution Data
n8n-nodes-base.executionData
From the author
This n8n template uses a Telegram chatbot to conduct a Product Satisfaction Survey and fetches questions and stores answers in a Google sheet. It augments an AI Agent to ask follow-up questions to engage the user and uncover more insights in their responses.…