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!

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.

Customize and save

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

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.

Automate my WhatsApp now

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.

Stop wasting time on manual entry

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.