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.

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.

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 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.

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.

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.

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.

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".