WhatsApp question with options and automatic logging to Google Sheets
Turn every WhatsApp reply into organized data, zero hassle, no code, just results.
Every time a customer messages you on WhatsApp with a simple question—like choosing a service location—you have to reply, wait for their answer, manually record their choice, and then update your records in Google Sheets. This tedious back-and-forth eats up precious time, opens the door to accidentally missed responses, and can quickly become a nightmare as your business scales. If you keep doing this manually, you’re not just wasting hours each week—you’re also risking costly mistakes and losing the timely insights that streamlined data capture brings.
This Botize formula changes the game: when someone messages your WhatsApp bot, it immediately sends them a friendly, customizable menu of options to choose from—like different cities or services. When the user selects their choice, Botize seamlessly logs their response (plus their name and phone number) straight into a Google Sheets file you specify, all in real time. No delays, no copy-pasting, and every detail is always up to date, giving you both instant organization and peace of mind.
Ready to streamline your workflow and never lose track of critical customer info again? Follow the simple step-by-step guide to set up this formula or jump straight in with Botize’s prebuilt automation, where messages, option lists, and update frequency can all be tailored to your needs. Start saving time and build a more professional, responsive brand—let’s make it automatic!
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
Set up the initial trigger for the automation to start when a new message is received.
Copy and paste this prompt into the AI editing tool.
Start this automation whenever the WhatsApp bot receives a new message from a user. ⤵
Click the 'Apply this task' button to confirm.
-
4
Capture incoming text messages sent to your WhatsApp Business number.
Copy and paste this prompt into the AI editing tool.
As soon as a user sends a text message to your WhatsApp Business number, capture that message and the user's details. ⤵
Click the 'Apply this task' button to confirm.
-
5
Ask the user to choose from a list of city options in WhatsApp.
Copy and paste this prompt into the AI editing tool.
Send the user a message on WhatsApp saying: '👋 ¡Hola! Por favor, selecciona una de las siguientes ciudades.' Present a list with the following options: Tokyo, Madrid, and New York. Let the user select one, and save which option they chose. ⤵
Click the 'Apply this task' button to confirm.
-
6
Acknowledge the user's selection and thank them.
Copy and paste this prompt into the AI editing tool.
Once the user makes a selection, automatically send them a WhatsApp message saying: '¡Genial! 🙌' ⤵
Click the 'Apply this task' button to confirm.
-
7
Log the user's selection and details into a Google Sheets file.
Copy and paste this prompt into the AI editing tool.
Add a new row at the end of the specified Google Sheets document with the following information: the user's phone number, their name, the value of the selected city, and the city label they chose. ⤵
Click the 'Apply this task' button to confirm.
-
8
Your automation is ready to use. Click the 'Save changes' button.
Save changes
Stop Guessing. Start Tracking WhatsApp Answers – Instantly In Google Sheets
Here’s how it works: whenever someone writes to your WhatsApp bot, they get a friendly question with several options to choose from. As soon as they pick one, their response, plus their contact info, is sent straight to your Google Sheet. Effortless tracking, zero risk of error, and you’re free to get on with your day.
| Manual | Botize | |
|---|---|---|
| Checking WhatsApp messages to see who replied | 15 | 0 Minutes |
| Copying response, name and phone number to Sheet | 5 | 0 Minutes |
| Fixing errors or duplicates | 5 | 0 Minutes |
| Total | 25 | 0 Minutes |
Looking to collect and record answers from WhatsApp into Google Sheets, automatically? You’ve just landed in the right spot. Forget spreadsheets headaches, manual copy-pastes, or lost messages. This automation does it for you.
Event RSVP Tracker
Ask your WhatsApp group to confirm attendance – see their responses and details fill your Sheet automatically. No more collecting confirmations one by one.
No More Manual Copying
Get every answer in your Sheets, instantly, without lifting a finger.
Ultra-Friendly Experience
Your users get clear options, you get organized data – everyone wins.
Customize Everything
Edit questions, options, and target Sheet in seconds. Total control.
Simple Customer Poll
Send a quick question: 'Which product do you like most?' See customer preferences appear instantly in your tracking spreadsheet.
⌾︎ You want to collect structured answers from customers, leads or team via WhatsApp.
⌾︎ You’re tired of retyping, misspelling, or losing data between chats and spreadsheets.
✕ If you want to do complex surveys or forms with ten pages of logic (try Google Forms instead).
✕ If your use case doesn’t involve WhatsApp or you hate organized data.
✓ Change the question and answer options to fit your team, event, or business.
✓ Connect to any Google Sheets spreadsheet – use your own layout and columns.
✓ Personalize the confirmation message back to users (add emojis, branding, whatever you want!).
This automation is triggered when your WhatsApp bot receives a message from a user. It then presents a set of options and asks the user to select one. The selected option, along with the user’s details (phone number, name, etc.), is saved in a Google Sheets document. You will need to customize the options and the messages sent by the bot, and provide the URL of the Google Sheets file where the data should be stored.
