Skip to main content

Store Locator That Syncs With Google Sheets

StoreRocket keeps a store locator in step with a Google Sheet: edit locations in the sheet, then sync on demand or once a day. How it works and what to check.

StoreRocket is a store locator that syncs with Google Sheets. It creates a Google Sheet holding your locations, your team edits the rows, and the locator on your website updates when you press Sync from Sheets or automatically once a day. New rows become new locations, edited rows change the matching location, and new or changed addresses are placed on the map for you.

That suits a business whose location list already lives with operations or sales people who work in spreadsheets: they keep editing a sheet, and nobody has to touch the website. We make StoreRocket, so weigh our view with that in mind.

Related: Store locator with CSV import | Store locator for 1,000+ locations | Store locator with an API | Best store locator software

The short answer

  • StoreRocket creates the linked Google Sheet with your locations, one row each, and shares it with you. You invite anyone else who should edit it.
  • Sync on demand with Sync from Sheets, or turn on daily sync and the sheet's changes reach the locator once a day.
  • Rows without a StoreRocket ID become new locations, and a blank cell clears that detail.
  • Deleting locations that are no longer in the sheet is a separate switch, off until you turn it on. A sync that would delete more than half of your locations stops instead.
  • Google Sheets sync depends on the plan, see pricing. For a handful of locations that rarely change, a free tool can be enough: see the free store locator options.

Create your locator →

How Google Sheets sync works in StoreRocket

  1. Get your locations in. Import a spreadsheet, add locations by hand, or start with an empty list.
  2. Create the sheet. Open Google Sheets Sync in the dashboard and press Create Google Spreadsheet. StoreRocket builds the sheet, shares it with you and emails you its link.
  3. Invite your editors. Type the email addresses of the people who should edit the sheet. Google emails each of them a link.
  4. Edit in the sheet. Change opening hours, phone numbers or addresses, hide a location, or add a row for a new store.
  5. Sync it back. Press Sync from Sheets. A confirmation says what the sync will do before anything changes. Or turn on daily sync, which runs once a day, around 4 AM New York time.

Once a sync ends, the locator on your website shows the new list through the embed code already on your page. There is nothing to re-publish.

Going the other way

Export to Sheets replaces the sheet with what is in StoreRocket. Use it when the dashboard holds the newest version, for example after an import. It clears the sheet first, including edits not yet synced and any columns you added yourself, so it asks before it runs.

Pick one place to edit

With daily sync on, the sheet wins every morning: edits made in the dashboard are overwritten by the next sync. Teams that sync daily edit in the sheet only. Teams that edit in the dashboard sync by hand, when they choose.

What the sheet holds

Each location is one row. The columns cover:

  • the name and the address, split into lines, city, state, postcode and country, plus latitude and longitude
  • phone, email, website and social links
  • opening hours for each day of the week, with the location's time zone
  • filters, so a store's products or services are a comma-separated list in one cell
  • your custom fields and location buttons, one column each
  • whether the location is visible, its marker and its type
  • the StoreRocket ID that ties the row to its location

Keep the StoreRocket ID column as it is. A row without an ID is read as a new location, so a deleted ID turns an edit into a duplicate.

Unlinking stops the sync. The sheet stays in Google Sheets with everything in it, and your locations stay as they are in StoreRocket.

What to check when comparing Google Sheets sync

Several store locators sync from Google Sheets. Storepoint, for example, documents connecting a sheet, matching its columns and choosing a sync schedule. These checks work on any of them, StoreRocket included, and a free trial is the place to run them.

  • How often it syncs. On demand, on a schedule, or both. Ask what "real-time" means before relying on it: a daily sync is predictable, and you can still press sync when a change cannot wait.
  • Which direction. Can the locator write back to the sheet, for example after a bulk import, or does the sheet only feed the locator?
  • What happens to a deleted row. Some tools delete the location, some keep it. A safe default keeps it, and a guard stops a half-empty sheet from wiping your map.
  • Whether addresses are placed for you. New rows need coordinates. Check that the tool finds them, and that a row with its own latitude and longitude keeps them.
  • Which fields map. Hours per day, filters, custom fields and buttons matter as much as the address.
  • Whose sheet it is. StoreRocket syncs with the sheet it creates for you, so rows from an existing sheet are pasted or imported into it once. A tool that reads a sheet another system writes to suits a different setup.
  • Who can press sync. In StoreRocket, the owner and administrators sync and change the settings. Anyone you invite can edit the sheet.

A free option

Google My Maps can import a Google Sheet into a map layer at no cost. It does not keep the map in step with the sheet: when the sheet changes, you reimport the layer by hand, and Google asks you to keep each import under 2,000 rows. That is fine for an internal map or a short list that rarely changes. A locator on your own site, with search and your brand, is a different job.

Frequently Asked Questions

Which store locator costs less to run over time with Google Sheets?

Count the subscription, the map provider's bill and the hours someone spends keeping the list right. A free map costs nothing to license, but every change means a manual reimport. With StoreRocket, the sheet sync, the hosted locator and its updates are part of the subscription. After the trial you connect your own Google Maps or Mapbox key and pay that provider directly. Plans are on the pricing page.

Does StoreRocket sync with Google Sheets in real time?

No. It syncs when you press Sync from Sheets, or once a day when daily sync is on. A change that cannot wait for the daily run goes live with one press.

Can my team edit the sheet without a StoreRocket login?

Yes. Invite them from the Google Sheets Sync page and Google shares the sheet with them. With daily sync on, their edits reach the locator the next day without anyone opening the dashboard.

Will deleting a row delete the location?

Only if you turn on deleting. It is off until you switch it on, and a sync that would delete more than half of your locations stops and changes nothing.

Can I import a CSV or Excel file instead?

Yes. StoreRocket imports CSV, TSV, TXT, XLS and XLSX files, and shows what will change before you publish. See store locator with CSV import and bulk upload.

StoreRocket gives businesses with several locations a store locator for their own website: import your locations from a spreadsheet, match it to your brand and paste one embed code. Create your locator with a free trial, no credit card needed.

Create your locator →

Put a store locator on your site today

Import your locations, make the locator match your website, and add it to a page the way you would add a video. No developer required.

Create your locator

7 days free · No card · No automatic charge · see a live locator first

Related Articles