Run a guided chat survey inside Telegram that collects richer answers and writes every response to Google Sheets. It blends a clear question path with smart follow up prompts so teams get deeper insight without extra work.

When a user messages the bot, the flow checks if it is a command or a normal reply. Questions come from Google Sheets, and Redis tracks which question each user is on. Users can send simple commands like start, next, or restart. A text classifier checks if a follow up is needed. If yes, an AI agent asks one or more clarifying questions. Chat memory resets for each question so the agent stays focused. All answers and bot messages are saved back to the sheet, then the next question is sent until the survey ends.

You will need a Telegram bot, a Google Sheet with an ID column and question columns, a Redis database, and an OpenAI API key. Expect to cut manual survey time and get cleaner data in one place. It fits product research, post purchase feedback, and service follow up surveys where you want consistent flow with room for deeper probes.

• Telegram trigger listens for new messages and bot commands
• Command router supports start, next, and restart actions to guide the chat
• Google Sheets reads question columns and records every answer and agent reply
• Redis stores session state and question index for each user
• Text classifier decides if a follow up is needed based on the user reply
• AI agent asks follow up questions and generates responses
• Chat memory resets each question to keep the agent focused and reduce drift
• Completion step confirms the survey is done and offers a fresh start
• Telegram messages send the next question or the agent reply back to the user

• Reduce manual survey work from hours to minutes by running chats and saving data automatically
• Automate up to 70 percent of follow up probing with an AI agent that asks clarifying questions
• Improve data quality by removing copy and paste and writing answers directly to Google Sheets
• Handle many parallel chats with Redis session tracking for each user
• Connect Telegram, Google Sheets, Redis and OpenAI in one controlled flow
• Speed time to insight with answers stored in the sheet in real time

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Telegram, Google Sheets, Redis and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. Make sure your n8n instance has a public secure URL so Telegram can reach it. If you use n8n Cloud, this is already set.
4. Set up Telegram credentials: In n8n, open the Telegram Trigger node, choose Create new credential, and paste your bot token from BotFather. Save and test the connection.
5. Connect Google Sheets: Open a Google Sheets node, choose Create new credential, select Google Sheets OAuth2, and follow the on screen steps to allow access to your sheet.
6. Configure Redis: Open a Redis node, choose Create new credential, and enter host, port, and password from your Redis provider. Turn on TLS if your provider requires it. Click Test to confirm.
7. Add OpenAI: Open the language model node, choose Create new credential for OpenAI, and paste your API key from your OpenAI account page. Save and test.
8. Prepare your sheet: Create an ID column in the first column, then add one column per survey question. Keep the target sheet on the first tab or update the sheet reference in the Google Sheets nodes.
9. Set variables: Open the Set Variables1 node and paste your Google Sheet ID and the survey title. Confirm the sheet name or gid matches what the Google Sheets nodes expect.
10. Activate the workflow and start a Telegram chat with your bot. Send the start command and then next to begin. You should receive the first question.
11. Answer a question and check your sheet for a new row with your response. If a follow up is triggered, confirm the AI reply also appears in the sheet.
12. Troubleshooting: If Telegram does not respond, check the Telegram Trigger status and your public URL. If sheet updates fail, verify the document ID and permissions. If state does not move, test the Redis credential. If AI replies fail, confirm the OpenAI key and usage limits.