Data ProcessingPro — €97
Telegram Bot with Google Sheets & Redis Integration
100/100
33 NodesBeschreibung
Ein Telegram-Bot, der mit Google Sheets interagiert und Redis zur Datenspeicherung verwendet.
Setup-Anleitung
## Try It Out
### This n8n template demonstrates how you can build a structured chat journey augmented with AI for your business.
In this scenario, a chatbot conducts a product satisfaction survey with a user using a predefined set of questions. For each question, the agent can dive deeper into the user's answers by asking follow-up questions.
This chatbot template isn't fully "agentic" which makes it a bit more complicated and scripted but ensures a more deterministic user journey; suitable when you need more guide-rails on the experience.
See example survey here: {{ $env.WEBHOOK_URL }}
### How it works
* A chat session is started with the user who needs to enter the bot command "/next" to start the survey.
* Once started, the template pulls in questions from a google sheet to ask the user. Questions are asked in sequence from left to right.
* When the user answers the question, a text classifier node is used to determine
if a follow-up question could be asked.
* If not, the survey proceeds to the next question. Otherwise, an AI Agent will generate a follow-up question based on the user's response.
* All answers and AI conversations are recorded in the Google Sheet.
* When all questions are answered, the template will stop the survey and give the user a chance to restart.
### How to use
* You'll need to setup a Telegram bot ([see docs]({{ $env.WEBHOOK_URL }}
* Create a google sheet with an ID column. Populate the rest of the columns with your survey questions ([see sample]({{ $env.WEBHOOK_URL }}
* Ensure you have a Redis instance to capture state. Either self-host or sign-up to [Upstash]({{ $env.WEBHOOK_URL }} for a free account.
* Update the "Set Variable" node with your google sheet ID and survey title.
* Share the bot with users to allow others to participate in your survey.
### Can I use this for WhatsApp?
Yes you can! Swapping out all telegram nodes for WhatsApp nodes should produce the same result.
### Need Help?
Join the [Discord]({{ $env.WEBHOOK_URL }} or ask in the [Forum]({{ $env.WEBHOOK_URL }}Benötigte Integrationen (5)
Workflow freischalten
Kaufe das Pro Bundle für €97 — erhalte sofortigen Zugang zu diesem und allen weiteren Starter + Pro Workflows als ZIP-Datei zum Import in n8n.
Sichere Zahlung via Stripe. 7-Tage Geld-zurück-Garantie.