Skip to main content
All CollectionsFrequently Asked Questions
How to use the Google Sheets Sync Tool
How to use the Google Sheets Sync Tool
Updated over a week ago

What is the Google Sheets Sync Tool?

Would you like to save time on managing multiple locations? Look no further than our Google Sheets Sync Tool! With this tool, you can easily add, edit, or remove your locations in bulk, with minimal effort.

Create the linked spreadsheet

You can find the Google Sheets Sync Tool on this page.

If you still don't have your linked spreadsheet, click "Create Google Spreadsheet".

Once it's done, you will receive an email with the link to your spreadsheet. During the creation process, the tool will export all your current locations to the spreadsheet.

Add access to the linked spreadsheet

You can add access directly from this page in the "ACCESS TO GOOGLE SPREADSHEET" section. Enter the email addresses of the people you want to give access to and click "Send Invitation".

The sync process

When you manually run the Sync by pressing on the "Sync from Sheets" button or during the automatic daily sync, this will be the process:

  1. Every row of your sheet corresponds to a location. If the row has a valid StoreRocket ID that matches one of your locations, the location on StoreRocket will be updated with the data from the row. If there is no StoreRocket ID, the location will be created.

  2. After your locations have been created/updated on StoreRocket, StoreRocket will geocoded them (get latitude and longitude based on the provided address).

  3. When the geocoding process is finished, the sheet is completely cleared and StoreRocket exports all your locations to the sheet, along with their latitude and longitude information.

  4. The sync process is done and the data on StoreRocket reflects the data on the sheet.

The spreadsheet rules

  • The spreadsheet will have a specific template and even if you don't plan on using all the columns, you should not remove any of the columns that were created for you.

  • You cannot create custom columns in the sheet because they will be erased during the sync process.

  • When the tool is syncing, please don't edit the spreadsheet or it might lead to data conflicts.

Editing your locations

From now on, you are encouraged to use the spreadsheet whenever you want to make changes to your locations.

Whenever you are done editing your locations, click "Sync from Sheets" on this page.

Syncing from the spreadsheet

When you sync from the spreadsheet, the spreadsheet becomes the source of truth and all data will be copied to your StoreRocket project. If you have enabled the option to delete the locations that are not on the spreadsheet, the tool will mirror each and every location from the spreadsheet to your project, and it will remove any "orphan" locations that are not existing in the spreadsheet.

Syncing from the spreadsheet should be your main way to use the sync tool.

On average, expect the Sync Tool to process 1500 locations per minute. That means ~15000 locations per 10 minutes. Unless you have a large number of locations (more than 50000 locations), the Sync Tool will be quite fast.

Exporting to the spreadsheet

Sometimes you may want to quickly edit a location directly from the StoreRocket dashboard. This is totally fine but you should remember to export your locations to the spreadsheet, otherwise your data will be up to date on your StoreRocket project but it will be out of date in your spreadsheet.

You can export your locations from this page.

By clicking "Export to Sheets", all your locations will be copied to your spreadsheet.

Unlink and create a new spreadsheet

If you wish to unlink the old spreadsheet and create a new one, click "Unlink Spreadsheet" on this page and then click "Create new spreadsheet".

Tips & Tricks

  • Add new rows for adding new locations.

    • Don't fill up the columns StoreRocket ID, Full Address, Lat and Lng – they will be automatically generated.

  • Edit existing rows for editing existing locations.

    • Don't change the StoreRocket ID of the row you want to edit – that's needed to reference the existing location.

  • Delete rows for removing locations.

    • Delete the entire row in order to properly delete the location on the StoreRocket too.

  • Geocode again an existing location by deleting the values of the columns Full Address, Lat and Lng – the location will be geocoded again with the new values from the address columns (Address Line 1, Address Line 2, City, State, Postcode and Country).

  • Hours: to use our real-time hours feature (to show the open/close label for your locations), please format the hours in the columns monday, tuesday, wednesday, thursday, friday, saturday, sunday as follow:

    • for closing days, enter closed

    • for opening days, enter (for example) 09:00-18:00 (opens at 9 AM and closes at 6 PM)

    • for 24 hours operations, enter for 00:00-23:59 (24 hours open)

  • Filters: separate search filters with commas. For example: Search Filter One, Search Filter Two, Search Filter Three

  • Markers: use the Marker ID column in the sheet. Find the IDs of your markers from this page (you need to upload your custom markers first) and then you can set them in the sheet.

Did this answer your question?