Have location data in a Google Sheet? You can turn it into a store locator, dealer locator, or any kind of location map in just a few minutes. ✨ Connect your spreadsheet to Storepoint and any changes you make automatically update your locator.
Before You Start
You'll need a Storepoint account on the Pro plan or above. Storepoint is a store locator and location map widget that embeds on your website. If you're new, start a free trial and follow the Quick Start Guide to get set up.
Start Your Free Trial See Examples
Prepare Your Google Sheet
Your sheet needs at minimum a name column and an address column. Storepoint handles the rest, including geocoding your addresses into map coordinates.
The easiest way to get the right format is to download our template and add your data to it, or adjust your existing sheet to match.
The template includes optional columns for phone, website, hours, tags, and more. Use what you need, leave the rest blank. If you have specific coordinates, add lat and lng columns to your sheet. See spreadsheet fields for the full list.
Share Your Sheet
Storepoint needs read access to sync your locations.
- Open your Google Sheet and click Share in the top right
- Under General access, change it to "Anyone with the link" with "Viewer" permissions
- Click Copy link
You can share your sheet directly with our service account instead of making it public. Contact us for the email address to share with.
Connect Your Sheet to Storepoint
- Go to Google Sheets Sync in your dashboard
- Paste your Google Sheets link
- Choose how often you want Storepoint to check for updates (daily, hourly, or more frequent on Business plan)
- Click Save & Start Sync
Your first sync runs automatically. Within moments, your locations appear on the map. 🙌
That's It! 🎉
Your store locator is now connected to your Google Sheet. Edit the spreadsheet, and your locator updates automatically on the next sync. Need an immediate update? Click Force Sync Now in your dashboard.
From here you can:
- Embed the locator on your website
- Set up filters so customers can filter by location type
- Customize the look and feel
Common Questions
What if I already have locations in Storepoint?
Export them first from Manage Locations (click More → Export All Locations). Add those rows to your Google Sheet before syncing. Each sync replaces your locator data with what's in the sheet.
Do I need exact coordinates?
No. Storepoint geocodes your addresses automatically. If you do have specific lat/lng values, you can add lat and lng columns to your sheet.
Can I add store hours?
Yes. Add columns for each day (monday, tuesday, etc.) with hours like 9:00am - 5:00pm or Closed. See opening hours for formatting details.
What about categories and filters?
Add a tags column with comma-separated values like Coffee, WiFi, Parking. Then set up filters in your dashboard to let customers filter by those tags.
Learn More
- Google Sheets Sync documentation for all options, troubleshooting, and advanced setup
- Quick Start Guide for a full overview of setting up Storepoint
- Filters & Tags for organizing locations by type