Save each new Telegram message to Google Sheets

Transform how you track user messages with a simple, automated flow.

  • Execute the task periodically
  • Instantly when receiving a text message (telegrambot → webhook)
  • Add a new row at the end of a sheet (gspreadsheet → add_row_to_end)

Manually copying every message your users send via Telegram into a Google Spreadsheet is tedious, error-prone, and makes it nearly impossible to keep up as your conversations grow. Not only does this chew up valuable time, but forgetting even a few details means you risk losing context, missing business opportunities, or failing to follow up with customers—directly impacting your organization’s efficiency and visibility.

This formula for Botize solves all that by automatically catching each Telegram message as it arrives and logging the sender’s name, message content, image URLs, and timestamp into your chosen Google Sheets document. You can set it up instantly, decide how often it runs, and apply your own filters so only relevant data gets stored. The clutter and chaos of manual tracking vanishes, replaced by a real-time, structured database of every user interaction ready for analysis, sharing, or quick lookup.

Let’s walk through automating this routine with Botize—it only takes a minute to connect your accounts and tailor each step to your specific workflow. If you’d rather plug and play, you can use this formula as-is and start capturing every conversation with zero manual effort. Your streamlined message archive is just a click away!

Start using this automation

It's ready to go. Choose how to set it up in your account.

Open it in the Botize editor

Load it into your account and customize it in the visual panel, with everything in view.

Open it in Claude or ChatGPT

Copy this and paste it into ChatGPT or Claude (with the free Botize connector): it'll load the automation, tailor it with you and save it to your account.

Not connected yet? Claude guide ¡ ChatGPT guide


Effortlessly Capture Messages in Google Sheets

With this automation, each message users send you magically appears in a Google Spreadsheet. No more copy-pasting, ever!

Manual Botize
Logging messages one-by-one 5 minutes per message 0 Minutes
Organizing data 3 minutes per message 0 Minutes
Total 8 minutes per message 0 Minutes

You've found the ultimate solution to keep your user interactions organized and efficient.


Customer Support Tracking

Capture user inquiries from your support chat into a structured log.

Save Time

Automatically logs messages without your intervention.

Stay Organized

All messages are neatly collected in one place.

Easy Access

Review, edit, or share messages from your Google Sheets effortlessly.


Sales Leads Management

Instantly log client interactions to review and follow-up.

📈

⌾︎ You need a simple way to track incoming messages.

⌾︎ You love automations that just work.

❌

✕ You never receive messages.

✕ You prefer manual data entry.


✓ Add or remove spreadsheet columns as needed.

✓ Set specific times for data processing.

✓ Edit your spreadsheet URL anytime.




This automation runs every time the Telegram bot receives a new text message and saves the user ID and message content into a new row in the specified Google Sheets spreadsheet. To set it up, you’ll need to provide the Google Sheets URL where the messages will be stored and, if desired, specify additional Telegram fields to be saved in each row.

Related automations

Other ready-to-use automations you may find useful.