Importing DataUpdated 2026-08-25

Sync stores with Google Sheets

What this article helps you do

Connect a Google Sheet to Mapstore. Mapstore updates store locations from the sheet at the times that you select. You can also start a sync manually.

Before you start

  • You have a Google Sheet with your store data.
  • Use the CSV import column structure. name and address are required.
  • Publish the sheet to the web as a CSV export.

Step-by-step instructions

1. Format your Google Sheet

Configure columns like a CSV file. Include name and address, and add the necessary optional columns.

2. Publish the sheet to the web

  1. In Google Sheets, go to File -> Share -> Publish to web.
  2. Select the sheet or range you want.
  3. Set the format to Comma-separated values (.csv).
  4. Click Publish.
  5. Copy the URL that Google generates.

The URL must be the published CSV export link, not the normal edit link. A correct URL:

  • Is from docs.google.com
  • Includes /pub in the path
  • Has output=csv as a query parameter

Correct example:
https://docs.google.com/spreadsheets/d/.../pub?output=csv

Incorrect example:
https://docs.google.com/spreadsheets/d/.../edit — this edit link does not work.

4. Configure the sync in Mapstore

  1. In Mapstore, go to Stores.
  2. Open Bulk.
  3. Find the Google Sheets sync section.
  4. Paste the published CSV URL.
  5. Click Test sheet to preview ready rows, skipped rows, and planned changes. The test does not change stores. You can test a new URL before you save it.
  6. Select one or more sync times. You can add up to five times in 15-minute steps. Mapstore uses your shop timezone.
  7. Enable automatic sync.
  8. Save the changes.
  9. To import the sheet immediately, use Run manual sync.

What a sync changes

Mapstore reconciles the sheet with locations from the same sync:

  • Mapstore updates a synced location when its row stays in the sheet.
  • Mapstore creates a location for each new row.
  • If you remove a row, Mapstore removes its Google Sheets-synced location.
  • Mapstore does not match locations that you created with other methods.

Before you remove rows, keep a backup of the sheet. Use the same location name in each sync.

How to verify it worked

  1. After the first sync, check Stores.
  2. Make sure that you can see your locations.
  3. Change one value in the sheet, such as a phone number.
  4. Start a manual sync.
  5. Make sure that you can see the change in Mapstore.

Troubleshooting

Issue Fix
“This looks like a Google Sheets edit link” Use the published CSV export URL from File -> Share -> Publish to web, not the browser edit URL.
“Please enter a valid Google Sheets CSV export URL” Make sure that the URL has output=csv and the /pub path. Publish the sheet again if necessary.
Sync shows no stores Check that the sheet has name and address columns. Make sure that rows have values in the two columns.
Sync fails or times out Make sure that the published URL is available and correct.