Zum Inhalt springen
Data ProcessingPro — €97

Telegram Bot with Google Sheets & Redis Integration

100/100
33 Nodes

Beschreibung

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)

Execution Data

ExecutionData

Google API

Google Sheets

API Key

HTTP/

HTTP/API

Redis

Redis

API Key

Telegram

Telegram

API Key

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.
← Zurück zum Marketplace