Bot that searches for users in Google Sheets and responds with their data if they are in the database; if not, it adds them to the sheet

This bot seamlessly connects your Telegram and Google Sheets without breaking a sweat.

  • Instantly when the trigger is activated
  • Instantly when receiving a text message (telegrambot → webhook)
  • Get a row according to a column value (gspreadsheet → read_by_column)
  • Reply to the user (telegrambot → reply)
  • Add a new row at the end of a sheet (gspreadsheet → add_row_to_end)
  • Reply to the user (telegrambot → reply)

Manually tracking and responding to user queries in Telegram, and constantly updating Google Sheets with new users, is a repetitive grind that eats up your focus and time. Every time someone asks for their info, you have to search rows, copy-paste details, or add missing users yourself—meanwhile, keeping everyone updated. It’s not just tedious; it leads to delays, scattered records, and risks missing valuable contacts, which can ultimately hit your responsiveness, credibility, and team productivity.

This Botize automation takes over the whole process: when someone uses the '/buscar' command in your Telegram bot, it instantly checks your Google Sheet for the user. If the user already exists, their information—like email and name—is sent back automatically. If not, the bot adds them to the sheet on the spot and confirms their addition. No more manual searching, updating, or replying. Enjoy a frictionless, real-time database with zero effort, where inquiries are handled instantly and records stay accurate. All frequencies, sheet destinations, and data fields are easy to adjust so the solution stays perfectly tailored to your needs.

Ready to transform your user management from time-draining manual work into seamless automation? Just follow the step-by-step guide below, and feel free to tweak the flow or filters to match your workflow. If you prefer to dive right in, there’s a ready-to-use formula link waiting—so you can reclaim your time and run your Telegram channels like a pro. Let’s automate it!

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 Manage Contacts with Telegram & Google Sheets!

Our Telegram bot is the bridge to your Google Sheets. Simply type 'search' and let the magic unfold. Find users in your database or effortlessly add new ones, all while staying informed.

Manual Botize
Search manually through records 5 minutes 0 Minutes
Enter user data 3 minutes 0 Minutes
Total 8 minutes 0 Minutes

Looking to streamline your contact management with ease? You've landed at the right place!


Solopreneur's Secret

John, a solopreneur, quickly checks his client's presence in his sheet before calls.

Time Saver

Find and add users with zero hassle.

Effortless Setup

No tech jargon, just plain and simple.

Stay Informed

Instant notifications ensure no user is left behind.


Customer Care Ace

Sarah uses this to effortlessly log new inquiries into her CRM-like sheet.

🧑‍💻

⌾︎ This system is ideal if you're always juggling between messaging and databases.

⌾︎ Perfect for those who desire quick info retrieval and seamless data entry.

📵

âś• Not useful if you operate outside Telegram or Google Sheets.

âś• Makes little sense for those without basic contact management needs.


âś“ Define custom data fields in Google Sheets for additional user info.

âś“ Edit the bot's response templates for a personal touch.

âś“ Set up Telegram commands beyond 'search' for other interactions.




This Telegram bot is designed to interact with a Google Sheets spreadsheet. Each time it receives the command "search", the bot looks for the user in column A of the spreadsheet. If found, it responds with relevant information such as email and name. Otherwise, the bot automatically adds the user to the spreadsheet with the provided details and notifies that they have been added.

Related automations

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