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.
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!
Automate this task with 6 simple prompts
Copy and paste the following prompts into Botize's AI task editor
-
1
Access the Botize automated task editor.
-
2
Select the AI editing tool.
-
3
Start the automation as soon as it gets triggered
Copy and paste this prompt into the AI editing tool.
Add a step that immediately activates the automation when it is triggered. ⤵
Click the 'Apply this task' button to confirm.
-
4
Wait for the user to send the 'search' command in any Telegram chat
Copy and paste this prompt into the AI editing tool.
Set up the Telegram bot to listen for the 'search' command in any type of chat, including public channels. ⤵
Click the 'Apply this task' button to confirm.
-
5
Look for the user in Google Sheets by checking if their name or ID exists in column A
Copy and paste this prompt into the AI editing tool.
Add a step that searches for a row in the first sheet of a Google Sheets file where the value in column A matches the text received from the user, excluding the header row. ⤵
Click the 'Apply this task' button to confirm.
-
6
If the user is found in the spreadsheet, respond with their stored email, name, and URL
Copy and paste this prompt into the AI editing tool.
If a matching user is found, have the Telegram bot reply to the user with their email, name, and URL as shown in the corresponding columns. ⤵
Click the 'Apply this task' button to confirm.
-
7
If the user is not found in the spreadsheet, add them as a new row with default values
Copy and paste this prompt into the AI editing tool.
If no matching user is found, add a new row to the end of the Google Sheet with their text in column A, and set columns B and C to 'Not specified'. ⤵
Click the 'Apply this task' button to confirm.
-
8
Let the user know that they were added to the database
Copy and paste this prompt into the AI editing tool.
If the user was just added to the sheet, send them a message on Telegram telling them they have been added to the database. ⤵
Click the 'Apply this task' button to confirm.
-
9
Your automation is ready to use. Click the 'Save changes' button.
Save changes
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.
