Most Google Sheets syncs finish in a few seconds. These are typical times from real syncs over the last 30 days:
Rows in your sheet | Usually finishes in | 9 in 10 finish within |
Up to 100 | 2 seconds | 3 seconds |
100 to 1,000 | 8 seconds | 22 seconds |
1,000 to 5,000 | 26 seconds | about 1 minute |
5,000 to 20,000 | about 1 minute | about 3 minutes |
A sync takes longer when it has many new addresses to place on the map, for example the first sync after you paste in a big list. New addresses are placed on the map during the sync, so your locations are ready as soon as it finishes.
When does daily auto-sync run?
Every day at 4:00 AM New York time (US Eastern Time). That's 08:00 UTC from the second Sunday in March to the first Sunday in November, and 09:00 UTC the rest of the year. It usually finishes within 2 minutes.
The time can't be changed. You can click Sync FROM Sheets on the Google Sheets Sync page whenever you like.
Sync seems stuck?
Refresh the page. If it still says Sync in progress after 30 minutes, message us on live chat.
Don't unlink the sheet to stop a sync. Unlinking disconnects your sheet, and a new sheet starts from your current StoreRocket locations, so changes you haven't synced stay behind in the old sheet.
Auto-sync didn't pick up my changes?
Check that Auto-sync spreadsheet daily is on, in the Settings section of the Google Sheets Sync page.
Changes made after 4:00 AM Eastern Time wait until the next morning.
Auto-sync runs only while your Business plan or free trial is active.
For everything else, see How to use the Google Sheets Sync Tool. Questions? Message us on live chat.