Form to trigger a bot that sends a WhatsApp template to a contact, asks them to choose an option, and stores the result in Google Sheets
Collect feedback or preferences from anyone on WhatsApp with a simple form, and store everything in Google Sheets without lifting a finger.
Chasing down contacts individually to send WhatsApp templates, wait for their reply, and then update a Google Sheet by hand? It’s a nightmare of repetitive clicks that drains your energy and makes it easy to miss crucial data—especially when every response counts for reporting, sales leads, or support triage. When you’re stuck in this manual grind, missed follow-ups, slow responses, and incomplete records aren’t just annoying—they’re lost opportunities and a headache during audits or reviews.
This Botize formula completely flips the script: just fill out a simple form with your contact’s number and let automation handle the rest. Instantly, your approved WhatsApp template is sent, the recipient chooses their response from a set of options, and their selection lands neatly in Google Sheets—no more copying, pasting, or risk of human error. You’re free to tailor the frequency, customize the message template, set the available options, and choose exactly what data you want saved, ensuring the process fits your workflow while delivering consistency and speed.
Ready to ditch the busywork and boost your team’s efficiency? Follow the step-by-step guide with Botize or hit the pre-built formula link to have everything set up fast—then watch your communications and records become automatic, organized, and effortless.
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.
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
Send Targeted WhatsApp Messages, Get Real Answers – All Saved Automatically
Here’s the magic: You fill in a mini-form with a contact’s phone number. Instantly, a bot sends a pre-approved WhatsApp message to that number, asking them a question with options to choose from. As soon as they reply, their pick (plus any relevant info) gets stored in Google Sheets for you – and they get a friendly confirmation back. All customizable. Zero headaches.
| Manual | Botize | |
|---|---|---|
| Search for number and manually send WhatsApp template message | 3 | 0 Minutes |
| Wait for reply and cross-check the option selected | 2 | 0 Minutes |
| Open Google Sheets, add new row by hand | 2 | 0 Minutes |
| Reply with confirmation manually | 2 | 0 Minutes |
| Total | 9 | 0 Minutes |
Yes, this is exactly the shortcut you were looking for. Forget clunky platforms: finally, WhatsApp automation that just works (and you control it).
Automated Lead Capture for Agencies
A digital agency uses the form at events: whenever a potential client is interested, they submit their phone number. The lead gets a WhatsApp asking if they want a meeting, pricing, or project info. Selections (with contact details) pop straight into a CRM-connected Google Sheet, ready for follow-up.
Instant Feedback
No more chasing – get real answers, fast.
Zero Data Loss
Every response is saved and organized, automatically.
Frictionless Experience
No apps, no confusion – just a WhatsApp conversation.
Booking Confirmations for Clinics
A medical clinic lets reception enter patient numbers. Patients receive a WhatsApp message to choose the service they’re booking for – responses are logged automatically, minimizing paperwork and no-shows.
⌾︎ You want responses from leads, clients, or customers via WhatsApp, and hate transcribing results.
⌾︎ You handle bookings, surveys, feedback or service requests and need records you can trust.
✕ You’re after bulk WhatsApp spam (sorry, nope).
✕ You only need to chat with friends/family and aren’t collecting any info from people.
✓ Easily change the WhatsApp template text and language to match your brand or campaign.
✓ Define which multiple-choice options your contact will see and what gets stored in Google Sheets.
✓ Choose which Google Sheet and columns you want to store data in – perfect for growth or specific use cases.
This task creates a form, and you will find its URL inside the task. In the form, you enter the phone number of a contact. The bot will send a WhatsApp template message (previously approved by Meta), which is required to initiate a conversation according to WhatsApp’s rules. Next, the contact will receive a question with multiple options. When the user selects an option, their data and the selected option are stored in a Google Sheets document, and the contact receives a final confirmation message. You will need to create a message template in Meta and get it approved before running the automation. You can customize the messages, the options, and the data that will be stored in Google Sheets.
Related automations
Other ready-to-use automations you may find useful.
Apps in this automation
These are the apps this automation connects. Open any of them to discover everything you can automate with it.
Actions used
These are the exact steps this automation runs. Each action can be reused in other automations.