Automate Your Product Surveys with Telegram and Google Sheets
detail.loadingPreview
Effortlessly collect product feedback by automating surveys directly through Telegram. This workflow leverages n8n to interact with users via Telegram, store survey data in Google Sheets, and manage survey progress using Redis.
About This Workflow
This n8n workflow provides a robust solution for automating product satisfaction surveys. It initiates surveys when users interact with a dedicated Telegram bot, dynamically retrieves survey questions from a Google Sheet, and intelligently manages the survey flow. User responses are captured, and the survey state is maintained using Redis, ensuring a seamless and personalized experience. The workflow is designed to be highly configurable, allowing you to easily adapt it to your specific product and survey needs. Imagine receiving real-time, structured feedback directly from your users, enabling faster iteration and improved product development.
Key Features
- Telegram Integration: Engage users directly within their familiar Telegram interface.
- Dynamic Questioning: Pull survey questions and logic directly from a Google Sheet.
- State Management: Utilize Redis to track user progress and maintain survey continuity.
- Automated Response Handling: Capture and process user answers efficiently.
- Customizable Surveys: Easily define your survey structure and Google Sheet source.
How To Use
- Set up a Telegram Bot: Obtain a bot token from BotFather on Telegram.
- Configure Telegram Trigger Node: Connect your Telegram bot token to the
Telegram Triggernode. - Prepare Google Sheet: Create a Google Sheet with your survey questions. Ensure the first row contains headers and subsequent rows have questions. Note the Sheet ID.
- Configure Google Sheets Node (
Get Columns1): Input your Google Sheet ID and specify the relevant sheet (e.g.,gid=0). - Set up Redis: Ensure a Redis instance is running and accessible.
- Configure Redis Node (
Get State2): Connect to your Redis instance to store and retrieve survey state. - Define Variables (
Set Variables1): Set your survey title, Google Sheet ID, and a unique cache key for each user session. - Implement Logic Nodes (
Has No Record?,Is Survey Continue?,Message Type1): Configure these nodes to handle initial survey starts, continuation of existing surveys, and different message types from Telegram. - Define Question Sending (
Send Next Question): Dynamically construct and send the next survey question to the user via Telegram. - Handle Responses: Implement logic to capture user responses and update the survey state.
Apps Used
Workflow JSON
{
"id": "90051bb9-bc05-41c6-932c-2434feafdf69",
"name": "Automate Your Product Surveys with Telegram and Google Sheets",
"nodes": 22,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 90051bb9-bc05...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
Automated AI Motion Illustration Workflow with Midjourney and Kling
Unleash your creativity with this n8n workflow that automates the generation of stunning motion illustrations. It leverages the power of Midjourney for static image creation and Kling AI to transform them into dynamic videos, all managed through the PiAPI. Perfect for content creators, marketers, and social media professionals looking to produce engaging visuals at scale.
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.