WhatsApp bot that checks if the phone number of the user who is writing to it appears on a Google Sheets document
Get a quick answer if you're in the list with just a message!
Manually checking if someone’s WhatsApp number is in your Google Sheets list every time they message you is not just tedious—it’s a total productivity killer. The wasted minutes pile up fast, especially as your list grows or messages spike. Worse, mistakes creep in, causing embarrassing mix-ups or lost opportunities to connect, leaving your operation looking disorganized and costing you valuable time and trust.
This Botize automation instantly connects your WhatsApp account to your Google Sheet: whenever a user writes in, it cross-checks their number against your database in real time. Within seconds, they receive a personalized reply confirming whether they’re on your list or not, all without you lifting a finger. Customize which column holds the numbers, adapt your responses, and never worry about missing or duplicating a check again. The transformation? Immediate responses, zero manual searching, and total peace-of-mind that your data is accurate—so your business looks both professional and reliable.
Take back your day by following the step-by-step setup for this formula and see just how seamless managing your growing WhatsApp contacts can be. Ready to make it even easier? You can use the pre-built automation through Botize and start saving time (and headaches) right away.
Automate this task with 5 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
Begin the automation whenever a specific trigger starts the process.
Copy and paste this prompt into the AI editing tool.
Set the automation to start instantly when the main trigger is activated. ⤵
Click the 'Apply this task' button to confirm.
-
4
Detect incoming WhatsApp messages from users to the bot.
Copy and paste this prompt into the AI editing tool.
Add a step that listens for and captures incoming text messages sent to the WhatsApp bot. ⤵
Click the 'Apply this task' button to confirm.
-
5
Check if the user’s phone number appears in a Google Sheets document.
Copy and paste this prompt into the AI editing tool.
Search column A of the specified Google Sheets document for a row that matches the exact phone number of the user who just sent a message. ⤵
Click the 'Apply this task' button to confirm.
-
6
If the phone number is found in the spreadsheet, reply to the user confirming they are in the database.
Copy and paste this prompt into the AI editing tool.
If the user’s phone number was found in the sheet, send them a WhatsApp message saying: 'Hola {{from_name}}, ¡Tu número figura en mi base de datos!' ⤵
Click the 'Apply this task' button to confirm.
-
7
If the phone number is not found in the spreadsheet, inform the user they are not in the database.
Copy and paste this prompt into the AI editing tool.
If the user’s phone number was NOT found in the sheet, reply on WhatsApp with: 'Lo siento {{from_name}}, tu número no figura en mi base de datos.' ⤵
Click the 'Apply this task' button to confirm.
-
8
Your automation is ready to use. Click the 'Save changes' button.
Save changes
Instant WhatsApp Number Checker Bot
Just send a WhatsApp message and let our bot do the heavy lifting. It checks a Google Sheets document to see if your phone number is there, and promptly informs you.
| Manual | Botize | |
|---|---|---|
| Searching Google Sheets manually | 5 minutes | 0 Minutes |
| Communicating back and forth | 10 minutes | 0 Minutes |
| Total | 15 minutes | 0 Minutes |
Yes, this is exactly what you need! Instantly verify if your number is on a Google Sheets list.
Membership Verification
A club can verify if a person is a registered member by checking their WhatsApp number.
Instant Feedback
Get immediate answers about your number's status.
Seamless Process
No need to dig through lists manually.
Time Saver
Reduce stress and streamline your workflow.
Customer Support
Support teams can instantly check if a customer's number is in their database for assistance.
⌾︎ This system is ideal if you're managing a membership list.
⌾︎ Perfect for businesses tracking customer engagements.
âś• Not useful if your numbers aren't in Google Sheets.
âś• No sense if you don't need to verify phone numbers.
âś“ Personalize response messages to include more details.
âś“ Use different columns for different types of checks.
âś“ Incorporate multimedia responses for a richer experience.
This bot activates every time a user sends it a message, checks on a Google Sheets document if there's any row in column A that contains exactly the same phone number as the user who is writing, and responds to the user indicating whether it appears or not in the database. This automation assumes you have a Google Sheets document with phone numbers in column A. You will need to provide the URL of your spreadsheet in the automation and specify the letter of the column if the numbers are in a column other than column A.
