Got your locations in a Google Sheet? Connect it to Storepoint and your spreadsheet becomes a live store locator, dealer locator, or any kind of location map. Edit the sheet, your locator updates with it.
You'll need a Storepoint account on the Pro plan or above. If you're new, follow the Quick Start Guide first.
Start your free trial See examples
Prepare Your Google Sheet
Every row needs a name for the location and an address. Storepoint handles the rest, including geocoding your addresses into map coordinates.
Your column names are yours to keep. Store Name, Retailer, Street, Zip Code, Tel, whatever your team already uses. You point your columns at Storepoint fields when you connect the sheet, so nothing needs renaming and extra columns can stay put.
Optional fields cover phone, website, hours, tags, images, and more. See spreadsheet fields for the full list.
Of course, if you're starting from a blank sheet, our template gives you every field with an example row to work from.
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 Storepoint checks for updates: daily on Pro, down to every 5 minutes on Business
Match Your Columns
Storepoint reads your sheet and shows you which of its fields each of your columns lines up with. Most are matched for you.
Check the matches, pick a field from the dropdown for anything left over, and skip the columns you don't need. Name and Address are the two that need a column. A preview of your first row shows the result.
Click Connect & Sync and your first sync runs right away. Within a few seconds, your locations appear on the map.
Storepoint saves the mapping, so this is the last time you'll think about columns.
Your store locator is now wired up to your Google Sheet. Edit the spreadsheet and your locator updates on the next sync. Need an instant update? Click 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?
They stay where they are. Your sync manages the locations it brings in from the sheet and leaves the rest alone. To have the sheet manage everything in one place, export your locations first from Manage Locations (click More → Export All Locations) and paste those rows in.
Do I have to use your template?
No. Your own sheet works as it is. The template is there if you want a starting point or a formatting reference.
Do I need exact coordinates?
No. Storepoint geocodes your addresses automatically. If you do have latitude and longitude values, add those columns and match them during setup.
Can I add store hours?
Yes. Add a column for each day with hours like 9:00am - 5:00pm or Closed. See opening hours for formatting details.
What about categories and filters?
Add a column of comma-separated values like Coffee, WiFi, Parking and match it to Tags. Then set up filters in your dashboard to let customers filter by those tags.
Can I keep editing locations in the dashboard?
Locations from your sheet are read-only, so the two never disagree. Edit the row in your sheet and the next sync carries it through. Any locations you added by hand stay editable as always.
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