Brief for the development of a Telegram bot for collecting questionnaires for a restaurant
1. General project description**
The Telegram bot is designed to collect questionnaires from potential participants, automatically save their responses to a database, and simplify communication with the restaurant.
2. Main functionality of the bot**
1️⃣ **Greeting and explanation of the rules**
- The bot starts and shows an introductory message about the rules of participation in the project.
- The user confirms their desire to fill out the questionnaire.
- If the user clicks "No," the bot thanks them for their interest and ends the dialogue.
2️⃣ **Filling out the questionnaire**
- collecting contact data (First name, Last name, year of birth, if possible – link to social media)
- The bot sequentially asks 18-20 questions, offering answer options.
- Responses are automatically recorded in **Google Sheets** or **Excel file** for further processing by the organizers.
- Questions where one option must be selected are implemented with buttons.
- Questions where **multiple options** can be selected have a multiple-choice format.
3️⃣ **Completion of the questionnaire and confirmation**
- The bot thanks for filling out the questionnaire and informs that invitations will be sent according to the participant's profile.
4️⃣ **Ability to share the questionnaire**
- The bot asks: "Would you like to recommend your friends to participate in this project?"
- If the user answers "Yes," the bot sends them a **link to the questionnaire** for further distribution.
- If "No" – the bot thanks and ends the dialogue.
---
### **4. Logic of the bot's operation**
📌 **The bot guides the user sequentially through all questions**
📌 **Records are automatically entered into the database** (Google Sheets or Excel)
📌 **Minimized need for manual text entry** – all questions, except for personal data, have selection options
📌 **Option to share the questionnaire is implemented**
---
### **5. Development requirements**
📌 **Platform:** Telegram
📌 **Programming language:** Python (Aiogram) or Node.js (Telegraf.js)
📌 **Data storage:** Google Sheets / Excel
📌 **Type of questions:**
- Selection of one option
- Selection of two options from 5 (if it does not complicate programming)
- Selection of multiple or all options (multiple choice)
### **6. Expected results**
✅ Convenient bot for filling out the questionnaire without Gmail authorization and lengthy form filling
✅ Automatic saving of responses in a convenient format
✅ Ability to recommend the questionnaire to friends and attract more participants
Please provide a budget estimate.
