Using the Google Drive Spreadsheet Sync feature

Below video describes Drive Sync functionality. An awesome Premium feature, with which you can link your Storemapper to Google Sheets and sync with just a simple button click or by automatic schedule.

If you prefer to read rather than watch a video see below:

From inside your Storemapper account navigate to Settings > Integrations

drivesync

Click on Connect to Google this will redirect you to sign in with Google – select the account where you would like your spreadsheet to reside and Allow.

You will then be redirected back to Storemapper and you will see a notice with the message of success that the sheet was created, as well as the direct link to the sheet.

Sheet Created Succesfully

You can click that link to open the spreadsheet. You can also access the spreadsheet at any time by clicking Stores> Drive Sync > Open Spreadsheet

Open Spreadsheet

From there you can open your spreadsheet and add in the store information directly on the google spreadsheet. Keep in mind to NOT change the headers generated by Storemapper – this will break the data sync.

You can then manually sync the stores when needed by selecting the Sync stores button, or from Settings> Integrations you can schedule a time of day for the integration to run every 24 hours.

24 hour sync

*It is not possible to remove a synched spreadsheet in app, if you need to disconnect and remake the integration reach out to help@storemapper.co

Was this article helpful?

Related Articles