WhatsApp bot that asks the user for their age and email and saves it to Google Sheets
Get your users’ age and email on autopilot. No more chasing, no more typing. Effortless, human, and finally painless data entry.
Manually collecting user information over WhatsApp—asking for age and email, then copying every answer into Google Sheets—quickly turns into a time-consuming headache. Errors creep in, responses get lost in message threads, and valuable leads slip through the cracks. This tedious process drains your focus and costs you more than just time: missed data means fewer qualified leads, lost opportunities, and less visibility for your business.
With this Botize formula, you can fully automate the user data collection process: whenever your WhatsApp bot receives a message, it instantly asks for the user’s age and email, then records each answer straight into your chosen Google Sheets file—without you lifting a finger. Easily customize the questions, update the Google Sheet’s URL, and set the trigger frequency to match your workflow. The transformation? You go from juggling manual entry and chasing incomplete info to a seamless, reliable flow of validated contacts—ready for nurturing or reporting.
Ready to turn your WhatsApp into a true data-capturing powerhouse? Follow the simple Botize step-by-step or use this formula as your fast track to automated results—fully customizable and up and running in minutes. Let’s get you set up and freeing your time for what matters most!
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
Detect when the WhatsApp bot should start the process
Copy and paste this prompt into the AI editing tool.
Set the automation to start whenever the main trigger is activated ⤵
Click the 'Apply this task' button to confirm.
-
4
Listen for incoming text messages on WhatsApp from any user
Copy and paste this prompt into the AI editing tool.
Create a trigger that immediately activates when a WhatsApp message is received ⤵
Click the 'Apply this task' button to confirm.
-
5
Ask the user for their age using WhatsApp
Copy and paste this prompt into the AI editing tool.
Send a WhatsApp message to the user asking: '👋 ¡Hola! ¿Cuál es tu edad?' and wait for their response ⤵
Click the 'Apply this task' button to confirm.
-
6
Ask the user for their email address after they've replied with their age
Copy and paste this prompt into the AI editing tool.
Once you receive the user's age, reply with another WhatsApp message asking: '¡Genial! Ahora la última pregunta, ¿cuál es tu email?' and wait for the user's answer ⤵
Click the 'Apply this task' button to confirm.
-
7
Thank the user after collecting their age and email
Copy and paste this prompt into the AI editing tool.
After the user responds with their email, send a final WhatsApp message saying: '¡Muchas gracias! 💪' ⤵
Click the 'Apply this task' button to confirm.
-
8
Save the collected user information to a Google Sheets file
Copy and paste this prompt into the AI editing tool.
Add the user's phone number, name, age, and email as a new row in your Google Sheets file ⤵
Click the 'Apply this task' button to confirm.
-
9
Your automation is ready to use. Click the 'Save changes' button.
Save changes
Collect WhatsApp Leads—Zero Stress, Pure Automation
Whenever someone sends a message to your WhatsApp bot, it politely asks for their age and email—one by one, like a real person would. Their answers instantly appear as new rows in your Google Sheet, ready for you to use. You only need to set up your questions and your Google Sheet link. That’s it! Say goodbye to manual copy-paste forever.
| Manual | Botize | |
|---|---|---|
| Ask for age via chat | 2 | 0 Minutes |
| Ask for email via chat | 2 | 0 Minutes |
| Copy answers to a spreadsheet | 3 | 0 Minutes |
| Total | 7 per lead | 0 Minutes |
Let’s be honest: you need an easy way to ask people on WhatsApp for their info—and you want everything neatly saved in your Google Sheets. Here’s exactly what you’ve been searching for.
Grow Your Event Guest List
Let your WhatsApp bot collect sign-ups for your next event—with age and email in seconds, right into Google Sheets. No more lost papers, no more missed messages.
Save Hours
Let your bot do the busywork—focus your energy on what matters most.
Human Touch
Conversations feel natural—no robotic surveys here.
All in Sheets
Everything organized instantly, no typos, no lost messages.
Easy Qualification for Product Demos
Auto-collect basic info from every prospect who messages you, so your sales team enters calls pre-qualified and ready.
⌾︎ You’re tired of losing leads because you couldn’t respond fast enough.
⌾︎ You want more than cold, clunky forms—real conversations, real info.
✕ You don’t use WhatsApp to talk to your clients or leads.
✕ You like exporting and importing CSVs by hand and have plenty of free time.
✓ Edit the questions to collect any info you need, not just age or email.
✓ Choose which Google Sheet and columns to save each answer in.
✓ Personalize the bot’s voice and style to totally match your brand.
This automation runs every time your WhatsApp bot receives a message from a user. The bot then asks two questions and saves the user’s responses in a Google Sheets document. You will need to customize the questions to your needs and provide the URL of the Google Sheets file where the responses should be stored.
