FM
FlowMarket
AI Agents Advanced ⚡ 40 n8n Nodes

Create product satisfaction surveys with Telegram Google Sheets

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...

🔌 Nodes & Integrations Used (11)

Telegram Trigger Telegram Redis Google Sheets Memory Redis Chat Memory Manager Agent HTTP Request Lm Chat Open Ai Text Classifier Execution Data

📖 Implementation & Setup Guide

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.

This template is intended to demonstrate how you'd realistically approach a workflow where there is structured conversation (static questions) but you still want to include an free-form element (follow-up questions) which can only be accomplished via AI.

**Check out an example Survey results**: [https://docs.google.com/spreadsheets/d/e/2PACX-1vQWcREg75CzbZd8loVI12s-DzSTj3NE_02cOCpAh7umj0urazzYCfzPpYvvh7jqICWZteDTALzBO46i/pubhtml?gid=0&single=true](https://docs.google.com/spreadsheets/d/e/2PACX-1vQWcREg75CzbZd8loVI12s-DzSTj3NE_02cOCpAh7umj0urazzYCfzPpYvvh7jqICWZteDTALzBO46i/pubhtml?gid=0&single=true)

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 column to right column. * When the user answers the question, a text classifier node is used to determine if a follow-up question could be asked. * If so, a mini conversation is initiated by the AI agent to get more details. * If not, the survey proceeds to the next question. * All answers and mini-conversations are recorded in the Google Sheet under the respective question. * 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](https://docs.n8n.io/integrations/builtin/credentials/telegram/)) * Create a google sheet with an ID column. Populate the rest of the columns with your survey questions ([see sample](https://docs.google.com/spreadsheets/d/e/2PACX-1vQWcREg75CzbZd8loVI12s-DzSTj3NE_02cOCpAh7umj0urazzYCfzPpYvvh7jqICWZteDTALzBO46i/pubhtml?gid=0&single=true)) * Ensure you have a Redis instance to capture state. Either self-host or sign-up to [Upstash](https://upstash.com?ref=jimleuk) for a free account. * Update the "Set Variable" node with your google sheet ID and survey title. * Share your bot to allow others to participate in your survey.

Requirements * Telegram for Chatbot * Google Sheets for Survey questions and answers * Redis for State Management and Chat Memory * Community+ license and above for Execution data node - you can remove this node if you don't have this licence.

Customising this workflow * Not using Telegram? This template technically works with other chat apps such as Whatsapp, wechat and even n8n's hosted chat! * This state management pattern can also be applied to other use-cases and scenarios. Try it for other types of surveys!

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Create_product_satisfaction_surveys_with_Telegram_Google_Sheets.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related AI Agents Workflows

View All in AI Agents →