Keep your location list in Google Sheets. Storepoint can check the sheet and update the locations on your website. This is called a sync.
See the Google Sheets integration overview for examples of the finished locator.
Before you start: You need a Storepoint account and a Google Sheet you can share. Scheduled syncing starts on Pro. If your file is Excel, save it as a Google Sheet first.
What a sync changes
These instructions create a named source in Imports & syncs. A source connects one location list to Storepoint.
| Change in your sheet | Result after a successful sync |
|---|---|
| Add a location row | Storepoint adds the location. |
| Change details such as a phone number | Storepoint updates the matching location. |
| Delete a location row | Storepoint removes that source's location. |
| Change a location's name or address | Storepoint treats it as a replacement for the old location. |
Storepoint matches locations by name and address. It also merges duplicate rows. Locations managed by other sources stay in place.
Before connecting an existing list: Export a backup. Decide which source will manage the locations to avoid keeping duplicate lists.
Older Google Sheets connections can replace the entire location list. If you use an older connection, contact us before combining it with other sources.
1. Prepare your sheet
- Put the column headings in the first row.
- Put one location in each row below it.
- Give each location a name and full address.
- Keep the location list on one tab.
You can keep address parts in separate columns. Storepoint reads the first tab unless your link points to another tab.
See Prepare a location sheet for an example. You can also download our template.
2. Share your sheet
Before changing access: Anyone with a general sharing link can read the sheet. Keep confidential information outside the sheet you share this way.
In Google Sheets:
- Select Share.
- Under General access, select Anyone with the link.
- Set the permission to Viewer.
- Copy the sharing link.
- Select Done to save the sharing settings.
To keep general access restricted, ask us for the sync account email. Share the sheet with that account instead.
3. Match columns and import
Connect the sheet
- In Storepoint, open Imports & syncs.
- Select New source.
- Select Google Sheets.
- Enter a Source name, such as
Retailer locations. - Paste the link into Google Sheet link.
- Choose how often Storepoint should check for changes.
- Select Continue.
Match your columns
Matching tells Storepoint what each spreadsheet column contains. For example, your Store name column belongs in the Name field.
- Match your location name column to Name.
- Match your address column to Address.
- Match the other columns you want to import.
- Choose Do not import for columns you want to skip.
- Select Preview import.
| Sheet column | Storepoint field | Example |
|---|---|---|
| Store name | Name | Casa Giulina |
| Full address | Address | 100 King Street West, Toronto, Ontario, Canada |
| Products | Tags | Coffee, Tea |
| Monday hours | Monday | 9:00am - 5:00pm |
Review the import
- Check the sample locations.
- Check the counts of locations to add, update, and remove.
- Correct any unexpected changes before continuing.
- Select Import locations.
- Wait for the import to finish.
4. Check the result
- Open All locations.
- Compare several locations with their rows in your sheet.
- Open Preview locator.
- Check that the locations appear at the expected map positions.
To test a later change, update a detail in your sheet. Use Sync now for the source in Imports & syncs. Complete the review if prompted. After the update finishes, check the changed detail in Storepoint.
When your locations are ready, add your locator to your website. Future syncs update the same locator.
Where to make future edits
Make lasting changes in Google Sheets. If you delete a row, its location is removed after a successful sync.
In Storepoint, a notice identifies the connected source. Edit anyway can unlock the fields, but the next sync may replace your dashboard edits. Update the sheet to keep the change.
Setup questions
How often can Storepoint sync my Google Sheet?
Pro supports daily checks. Business also supports hourly checks, every 15 minutes, or every 5 minutes. Only when I ask lets you run updates manually. Changes appear after an update completes.
How do I add product or service filters?
Put values such as Coffee, Tea, Parking in a column. Match that column to Tags. Then create filter groups in Storepoint. Product tags describe what a location carries; they do not track live stock.
How do I add images, hours, or extra details?
For images, match a column of direct image-file links to Image URL.
For each day's hours, use 9:00am - 5:00pm or Closed. For a midday closure, use 9:00am - 12:00pm, 1:00pm - 5:00pm.
Create custom fields in Storepoint before matching extra columns. You can also match phone, email, website, description, and supported social fields.
Can I use exact map coordinates?
Yes. Match both Latitude and Longitude columns. Keep an address for the public listing too. Without coordinates, Storepoint uses the address to place the location on the map.
If your updates do not appear
Start with the source in Imports & syncs. Check its latest update time and any error message.
| Problem | What to check |
|---|---|
| Storepoint cannot read the sheet | Check the sharing permission and saved sheet link. |
| The wrong rows appear | Check that the link points to the correct tab. |
| A column stopped updating | If its heading changed, update the column match in Storepoint. |
| A location will not import | Check that its row has a name and full address. |
| The sheet changed, but the map did not | Run Sync now and check the result after it finishes. |
Contact our team with the source name and error message if you need help.