Search a record in the database for the name, email or profile indicated
Instantly locate exactly who or what you're looking for in your database.
Manually searching your database each time someone asks for a contact’s details or profile information is a frustrating productivity drain. With every lookup, you have to fumble through Google Sheets, scroll columns and triple-check for typos—a repetitive task that chews up precious minutes and scales poorly as your records grow. Inefficient searching kills response speed, risks human error, and leaves team members waiting or misinformed, hurting reputation and wasting valuable working hours.
This Botize formula transforms the way you pull data: Simply submit a name, email, or profile via Telegram, and the automation instantly scans your database to return exact matches—no spreadsheet digging required. Whether it’s a straightforward name, an email address, or an Amazon Profile, the bot knows which column to query and delivers clean, neatly formatted answers directly to you. Results are immediate and accurate, freeing you from interruptions and allowing you to allocate time where it really matters.
Ready to supercharge your workflow? Follow the easy step-by-step to set up this formula and start searching your database in seconds—no coding needed, and you can adjust filters and frequency to suit your needs. Prefer a head start? Just use the ready-made formula and feel the difference with Botize’s automation at your fingertips.
Automate this task with 7 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
First, create a step that runs as soon as the automation is triggered.
Copy and paste this prompt into the AI editing tool.
Make sure the automation starts immediately when triggered. ⤵
Click the 'Apply this task' button to confirm.
-
4
Set up a step to listen for incoming text messages on Telegram, specifically using the command 'buscar', from any chat type.
Copy and paste this prompt into the AI editing tool.
Add a step to listen for Telegram messages and trigger when the 'buscar' command is sent from any user or chat. ⤵
Click the 'Apply this task' button to confirm.
-
5
Add a step that searches Google Sheets for a row where the 'Profile' column matches the text provided and contains a link (starting with http:// or https://).
Copy and paste this prompt into the AI editing tool.
Search in Google Sheets, in the first sheet, for rows where the 'Profile' column (Column C) matches the message text and contains 'http://' or 'https://'. Exclude the first row as a header. ⤵
Click the 'Apply this task' button to confirm.
-
6
Add another search step to look for a row where the 'Email' column matches and contains an '@' sign.
Copy and paste this prompt into the AI editing tool.
Search in Google Sheets, in the first sheet, for a row where the 'Email' column (Column B) matches the message text and includes an '@' symbol. Exclude the first row. ⤵
Click the 'Apply this task' button to confirm.
-
7
Add a final search step to find a row where the 'Name' column matches (and doesn't contain a link or an '@').
Copy and paste this prompt into the AI editing tool.
Search in Google Sheets, in the first sheet, for a row where the 'Name' column (Column A) matches the message text and does not contain 'http://', 'https://', or '@'. Exclude the first row. ⤵
Click the 'Apply this task' button to confirm.
-
8
Set up a step to reply to the user on Telegram if the search finds a matching record.
Copy and paste this prompt into the AI editing tool.
If a matching row was found in Google Sheets, reply to the user in Telegram with: 'Nombre: [Name] - Mail: [Email] - Perfil: [Profile]'. ⤵
Click the 'Apply this task' button to confirm.
-
9
If no match is found in the database, send a reply to let the user know no results were found.
Copy and paste this prompt into the AI editing tool.
If no matching row is found, reply in Telegram: 'No figura en la base de datos ningún usuario con este dato, por introduce un email, nombre o perfil de Amazon válido o contacta con el administrador.' ⤵
Click the 'Apply this task' button to confirm.
-
10
Your automation is ready to use. Click the 'Save changes' button.
Save changes
Find Your Data Buddy Fast!
This tool makes finding a name, email, or profile in your database as simple as clicking a button. No more digging through endless lists!
| Manual | Botize | |
|---|---|---|
| Looking up data manually | 30 | 0 Minutes |
| Cross-referencing information | 20 | 0 Minutes |
| Consolidating results | 10 | 0 Minutes |
| Total | 60 | 0 Minutes |
Yes, this is the treasure map to your data quest!
Customer Lookup
Quickly find customer details to enhance your service or follow-up actions.
Time-Saver
Spend minutes, not hours, finding the info you need.
Error-Free
Say goodbye to mistakes from manual searches.
Easy-to-Use
No need to be a tech wizard to find what you need.
Email Retrieval
Pinpoint email addresses in seconds when needed for campaigns or communication.
⌾︎ If you're overwhelmed with data and need quick answers.
⌾︎ When you want to streamline your data searching process.
âś• If you prefer sorting through data manually for hours.
âś• If you never need to find specific information quickly.
âś“ Tailor search parameters to specific columns or data fields.
âś“ Customize output formats for different user requirements.
âś“ Set up automated notifications for search results.