Keep your store locator in sync with a Google Sheet. Manage locations in the spreadsheet and your locator updates on its own. Great for retail stores, dealer networks, and anything else that changes often.
New to this? Start with our step-by-step guide for the walkthrough version.
On This Page
- How It Works
- Already have locations?
- Setting up the sync
- Spreadsheet fields
- Sync frequency
- What sync does
- Troubleshooting
How It Works
- Create a Google Sheet with your location data
- Share the sheet and connect it to Storepoint
- Storepoint syncs automatically on your chosen schedule (or instantly via Force Sync Now)
Already Have Locations? Bring Them Into Your Sheet First
If you already have locations in Storepoint, export them so you can include them in your new Google Sheet. Your sheet becomes the source of truth after sync starts, so anything not in the sheet won't appear in your locator.
- Go to Manage Locations
- Click More in the top-right corner
- Select Export All Locations to download a CSV
Of course, if you're starting fresh and your sheet has everything you need, you can skip this. See exporting locations for more.
Setting Up Google Sheets Sync
Step 1: Download the Template
This template includes all standard spreadsheet fields. Only name and address are required, the rest are optional. Storepoint handles geocoding automatically, but you can add lat and lng columns if you have specific coordinates.
If you've configured custom fields, download the template from the Google Sheets Sync page in your Storepoint dashboard so they're included.
Step 2: Create Your Google Sheet
The easiest approach: create a new Google Sheet and import the template or your Storepoint export. Then add or update your location data.
- Go to sheets.google.com and create a new spreadsheet
- Go to File → Import and upload the template CSV
- Add your location data (if you exported locations earlier, import that file too or copy the rows over)
Step 3: Share the Sheet
- Click the Share button in Google Sheets
- Under General access, set permissions to "Anyone with the link" and "Viewer"
- Click Copy link and you're ready for the next step
If you'd rather not make your sheet publicly accessible, you can share it directly with our sync service account instead. Contact us and we'll provide the email address to share with.
Step 4: Connect to Storepoint
- Go to Google Sheets Sync in your dashboard
- Paste your Google Sheets share link
- Select your sync frequency
- Click Save & Start Sync
Your first sync will begin shortly. The whole setup takes a few minutes.
Spreadsheet Fields
The standard template includes all the fields below. Only name and address are required, everything else is optional.
Required: name, address
Optional: description, city, state, postcode, country, phone, website, email, monday through sunday (for store hours), facebook, instagram, twitter, image_url, tags
The address field can contain the full address (e.g., 123 Main St, Boston, MA 02101, USA). The city, state, postcode, and country fields are there for convenience if your existing data already has these in separate columns, but they're not required if your address is complete.
Custom Fields
If you've set up custom fields in your Storepoint account, download the template from your Google Sheets Sync page to get a version with your custom columns included.
Store Hours
Use a simple format like 9:00am - 5:00pm or Closed. If a location has a break (like a lunch closure), separate the time ranges with a comma: 9:00am - 12:00pm, 1:00pm - 5:00pm.
See the Opening Hours guide for all supported formats and display options.
Coordinates
Storepoint automatically geocodes each location based on the address. If you have specific coordinates, add lat and lng columns to your sheet.
Tags
Use the tags column to categorize locations for filtering. Enter tags as a comma-separated list:
Coffee, WiFi, Parking, Drive-Thru
Include all relevant tags for each location in a single cell.
Just include your tags for now. You can organize them into filter groups later in your dashboard. If you've already set up filters, Storepoint automatically assigns tags to the right groups on sync. Learn more about filters and tags.
Images
The image_url column accepts a direct link to an image file. Images display on your locations in the locator.
Getting image URLs:
- From your website: Right-click an image and select "Copy image address"
- From image hosts: Services like Cloudinary provide direct image URLs
Example: https://example.com/images/store-photo.jpg
Learn more about location images
Sync Frequency
Choose how often Storepoint checks your sheet for updates:
- Daily sync is available on Pro plan and above
- Hourly, every 15 minutes, and every 5 minutes sync options are available on the Business plan
Need an immediate update? Click Force Sync Now in your sync settings to trigger a sync right away.
What Sync Does
Your sheet is the source of truth. Each sync, Storepoint matches rows to existing locations by name and address, updates anything that's changed, adds anything new, removes anything missing, and merges duplicate rows automatically. The sync log shows the count of each.
Checking Sync Status
The sync page shows when the last sync ran, how many locations were added, updated, or removed, how many duplicates were merged, and any errors. Update your spreadsheet and the locator reflects it on the next sync.
Troubleshooting
If your sync isn't working, the Google Sheets Sync page in your dashboard will show any errors. Here are common issues:
Permissions error
Your Google Sheet permissions aren't set correctly. Make sure the sheet is set to "Anyone with the link" can "View". To check: click Share in Google Sheets, then under General access, select "Anyone with the link" and set the role to "Viewer".
Using an Excel file (XLSX) instead of a Google Sheet
Google Sheets Sync only works with native Google Sheets, not Excel files stored in Google Drive. If you have an Excel file, open it in Google Sheets and save it as a Google Sheet (File → Save as Google Sheets), then use that sheet's URL.
Missing required columns
Your sheet must have at least a name column and an address column in the first row. If you're not sure about the format, download the template and use it as a starting point.
Sync seems stuck or not updating
Click Force Sync Now on the sync page to trigger an immediate sync. If it still doesn't work, check for errors in the sync status section.
Still having issues? Contact us with a link to your Google Sheet and we'll help sort it out.
Next Steps
- Learn how to view and manage your synced locations
- Set up filters and tags to let customers filter your locations
- Add custom fields for additional location data
- Customize your locator's appearance