Blog

Auto-Update Map from Google Drive Spreadsheets

When mapping locations from a spreadsheet on a Google Drive, you can set up auto-update such that changes to your spreadsheet are periodically reflected in your map.

The spreadsheets can be stored as Microsoft Excel, CSV, or Google Spreadsheet files.

To enable this, create a map using one of the “Create a Free Map” button.

Then, go to the Additions menu and select Additions -> Add (Upload) Multiple Markers -> Google Drive Spreadsheet:

[caption id="attachment_704" align="aligncenter" width="554"]Menu item to add Google Drive spreadsheet Menu item to add Google Drive spreadsheet[/caption]

In the resulting dialog, click on the Fetch My Spreadsheets button. ZeeMaps will ask you permission to access your Google Drive files in ReadOnly mode. We only ask for Read permissions, so we will never modify your Google Drive files or data in any way.

[caption id="attachment_705" align="aligncenter" width="829"]Fetch button Fetch button[/caption]

Select the spreadsheet that you want to upload, by clicking on the checkbox near the spreadsheet’s name.

Next, confirm your upload settings. Make sure at this point you assign columns appropriately, e.g, name -> Name, street address -> Street, city -> City, etc. You can double-click on the assignments to get a list of standard fields to choose from.

Check the box that says: “Regularly update from Google Drive Spreadsheet”.

[caption id="attachment_706" align="aligncenter" width="736"]Confirm spreadsheet upload settings Confirm spreadsheet upload settings[/caption]

Hit Submit, and wait for a little while. Then, refresh your map to see if the data is being uploaded.

One Trackback

Post a Comment

Your email is kept private.