Logging WhatsApp users' locations in Google Sheets
Stop chasing people for their locations. One simple form, one WhatsApp, and all your records—organized and ready.
Trying to collect accurate location data from WhatsApp users is a manual nightmare: you have to message each contact individually, follow up, and then painstakingly copy every response—hoping they actually share their location—into a spreadsheet. Without automation, you waste countless hours on repetitive outreach, risk losing vital data with human error, and end up with scattered records that undermine real-time decision making and operational efficiency.
This Botize formula transforms your workflow by instantly sending a WhatsApp request for location whenever you enter a user's phone number into a simple web form. Users receive a one-tap location share button in WhatsApp, and as soon as they respond, their coordinates—with phone number and name—are captured and neatly recorded as a new row in Google Sheets. You stay fully in control: use the form as often as you need, tailor the fields, and filter recipients, while the heavy lifting happens in the background and your database updates itself in real time.
Ready to leave the tedious manual steps behind? Follow the step-by-step guide to set up this process with Botize, personalizing it to match your use-case. Or, if you want instant results, use the provided formula link and start organizing your WhatsApp location data in minutes—with zero coding and total peace of mind!
Automate this task with 4 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
Start by setting up the initial trigger, which activates whenever a new request is made.
Copy and paste this prompt into the AI editing tool.
Create a main trigger that starts the automation whenever a new entry is submitted through the form. ⤵
Click the 'Apply this task' button to confirm.
-
4
Now add a form where you can enter a user's phone number.
Copy and paste this prompt into the AI editing tool.
Build a simple web form that asks for the user's phone number, making this field required. ⤵
Click the 'Apply this task' button to confirm.
-
5
After the form is submitted, send a WhatsApp message to the entered number, asking them to share their location.
Copy and paste this prompt into the AI editing tool.
Add a step to send a WhatsApp message to the phone number provided, requesting the user to share their location with a single tap button. ⤵
Click the 'Apply this task' button to confirm.
-
6
Finally, store the user's phone number and shared location in a Google Sheets spreadsheet.
Copy and paste this prompt into the AI editing tool.
When the user shares their location, automatically add a new row to a Google Sheet with their phone number and location data (latitude and longitude). ⤵
Click the 'Apply this task' button to confirm.
-
7
Your automation is ready to use. Click the 'Save changes' button.
Save changes
Get Everyone’s Location in Seconds—Directly from WhatsApp to Google Sheets
Here’s how easy it is: Type in someone’s phone number. They instantly get a WhatsApp asking to share their location with just one tap (no explanations, no confusion). As soon as they respond, their phone and exact coordinates go straight into your Google Sheet. No tech headaches, no manual chasing.
| Manual | Botize | |
|---|---|---|
| Create manual contact request | 5 | 0 Minutes |
| Send WhatsApp message asking for location | 3 | 0 Minutes |
| Wait, chase, or remind until the person responds | 10 | 0 Minutes |
| Manually enter details into Google Sheets | 5 | 0 Minutes |
| Total | 23 | 0 Minutes |
Yes, this is the shortcut you needed: If you want people to send you their location, sorted and stored with zero hassle, you’re home.
Event Check-In
Easily log where your event staff or attendees are as they arrive—no WhatsApp group chaos needed.
Ultra Fast
Collect locations within seconds, not hours.
Zero Confusion
No tricky app installs—everyone knows WhatsApp.
Always Organized
Clean, structured data in Google Sheets—ready to use.
Delivery Confirmation
Get delivery partners or field staff to share exactly where they are, right now, with no drama.
⌾︎ You need to know where your contacts, teams, or clients are, right now.
⌾︎ You’re tired of asking for locations over and over and just want a single, reliable system.
✕ You never need to know anyone’s realtime location.
✕ Your users refuse to use WhatsApp—even under threat of karaoke.
✓ Change the WhatsApp request message to match your brand voice.
✓ Send the location request to multiple numbers in bulk, not just one by one.
✓ Add more fields to the Google Sheet (like timestamps, names, emails) with just a tweak.
This task creates a simple web form with a field called “Phone number.” Each time you enter a phone number in the form, the automation is triggered and sends a WhatsApp message to that number requesting the user to share their location. The user will receive a message in WhatsApp with a button that allows them to share their location with a single tap. When the user presses the button and shares their location, the system receives the coordinates. Once the location is received, the automation automatically stores the user’s phone number and location data in a Google Sheets spreadsheet, creating a record for each response. This allows you to easily collect and organize the locations shared by WhatsApp users.
