Create product satisfaction surveys with Telegram, Google Sheets and AI

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

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)
• Create a google sheet with an ID column. Populate the rest of the columns with your survey questions (see sample)
• Ensure you have a Redis instance to capture state. Either self-host or sign-up to Upstash 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!