TelegramTrigger Automate

Target Audience

• Market Researchers: Professionals conducting surveys to gather consumer insights.
• Product Managers: Individuals seeking feedback on product satisfaction and features.
• Business Analysts: Analysts looking to collect and analyze customer responses for better decision-making.
• Developers: Those interested in automating chat interactions using Telegram and Google Sheets integration.
• Small Business Owners: Entrepreneurs wanting to understand customer satisfaction without extensive resources.

Problem Solved

This workflow addresses the challenge of collecting structured feedback from users through a conversational interface. It automates the process of conducting surveys via Telegram, allowing for dynamic interactions, follow-up questions, and real-time data storage in Google Sheets. By utilizing Redis for state management, it efficiently tracks user progress through the survey, ensuring a seamless experience.

Workflow Steps

1. Trigger: The workflow begins when a user sends a message to the Telegram bot.
2. Set Variables: Initial variables such as survey title and Google Sheet ID are set for later use.
3. Check User Record: The bot checks if the user already has a record in the Google Sheet to determine if it should create a new entry.
4. Start Session: If the user is new, a session is initiated, and a welcome message is sent.
5. Process Commands: The bot listens for commands like /start or /next to navigate through questions.
6. Survey Questions: Questions are fetched from Google Sheets and sent to the user one at a time.
7. Follow-Up Evaluation: After each response, the workflow assesses whether to ask follow-up questions based on the user's input.
8. Store Responses: User answers and AI-generated follow-ups are recorded in the Google Sheet for analysis.
9. Completion: Once all questions are answered, a completion message is sent, and users can opt to restart the survey.