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.
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.
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
andLng
β 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
andLng
β the location will be geocoded again with the new values from the address columns (Address Line 1
,Address Line 2
,City
,State
,Postcode
andCountry
).
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
Custom Fields: please check this guide
Calls To Action: please check this guide