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!
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
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.
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.