Telegram bot to request 2 pieces of information from the user and save the responses in Google Sheets

Automatically collect and store user responses from Telegram into Google Sheets – stress-free!

  • Instantly when the trigger is activated
  • Instantly when receiving a message, image, or file (telegrambot → webhook_txtimgdoc)
  • Ask user (telegrambot → ask)
  • Ask user (telegrambot → ask)
  • Add a new row at the end of a sheet (gspreadsheet → add_row_to_end)

Gathering data from Telegram users and organizing their responses manually burns countless hours every week. You chase down messages, copy and paste into spreadsheets, risk missing entries, and end up with messy, outdated records. This manual slog isn’t just exhausting—it leads to errors, lost opportunities, and makes analyzing user feedback or form responses almost impossible. Delay in acting on data hurts your business decisions, costs money, and leaves you feeling overwhelmed.

This formula automates the entire process: as soon as a user interacts with your Telegram bot, it instantly asks them two questions and captures their answers in real-time. Without any manual effort, each response is logged neatly into a Google Sheet, ready for analysis or follow-up. You control every step—customize the questions, adjust when the bot triggers, and filter which channels or users participate. As soon as the answers come in, they're saved securely, ensuring no response is missed and your records are always up-to-date.

Ready to stop the data scramble and run smoother Telegram campaigns? Just follow the step-by-step inside Botize to get this automation working for you—or use the one-click setup to launch in minutes. Your streamlined, stress-free data collection starts now!

Automate this task with 5 simple prompts

Copy and paste the following prompts into Botize's AI task editor

  1. 2

    Select the AI editing tool.

    AI Prompt Tool
  2. 3

    Set up the automation to start as soon as it is triggered.

    Copy and paste this prompt into the AI editing tool.

    Begin the workflow immediately when the trigger is activated. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  3. 4

    Create a step that listens for any message, image, or file received by the Telegram bot.

    Copy and paste this prompt into the AI editing tool.

    Listen for incoming messages, images, or files received by the Telegram bot in any public channel. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  4. 5

    Add a step to ask the user for the first piece of information via the Telegram bot.

    Copy and paste this prompt into the AI editing tool.

    Send a message to the user on Telegram asking them to provide the first piece of information. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  5. 6

    Add a follow-up step to ask the user for the second piece of information via the Telegram bot.

    Copy and paste this prompt into the AI editing tool.

    Send another message to the user on Telegram asking them to provide the second piece of information. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  6. 7

    Save both pieces of information into a Google Sheets document.

    Copy and paste this prompt into the AI editing tool.

    Add a new row to your Google Sheets file, putting the first answer in column A and the second answer in column B. ⤵

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  7. 8

    Your automation is ready to use. Click the 'Save changes' button.

    Save changes

Streamline Your Data Entry with Ease

Imagine asking someone two simple questions on Telegram and having their answers seamlessly slide right into your Google Sheets. No fuss, no manual entry, just pure efficiency.

Manual Botize
Sending questions manually on Telegram. 15 0 Minutes
Recording responses in Google Sheets. 20 0 Minutes
Verifying each entry. 10 0 Minutes
Total 45 0 Minutes

You've just landed in the right place for effortless data automation.


Customer Feedback Collection

Instantly gather customer reviews or preferences via Telegram and store them securely in Google Sheets for analysis.

Seamless Integration

Connect Telegram directly with Google Sheets effortlessly.

Save Time

Automate data collection and focus on what truly matters.

User-Friendly

Designed for everyone – no tech jargon, just simple steps.


Employee Check-In

Manage remote teams by collecting daily or weekly updates automatically and keeping everyone in the loop.

đź”§

⌾︎ Business owners seeking to simplify data entry.

⌾︎ Teams tired of manual spreadsheet updates.

đź“„

âś• Individuals not using Telegram for interactions.

âś• Those who prefer traditional pen and paper methods.


âś“ Adjust the questions as per your requirements.

âś“ Define specific Google Sheet columns for each response.

âś“ Set unique triggers based on user interactions.




Related automations