All Collections
Frequently Asked Questions
How to use the Google Sheets Sync Tool
How to use the Google Sheets Sync Tool
Adriano avatar
Written by Adriano
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 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 can create your own columns for internal use and the tool will ignore them.

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?