I have been looking into the Google Maps Engine and I have noticed that you can import data (points) based on a Google Sheets.

This got me thinking, could this be used as a way to auto update a webmap?

From a quick test it seems like the import creates an embedded file, and looses the link to the sheet.

Has anyone looked at the option of using Google Sheets with Maps Engine as a system for adding data to a sheet, and seeing the live update on the map?

  • 1
    Not Google Sheets, so I'm not putting it as an answer, but instead you may want to look at using Google Fusion table instead of and spread sheet and then you could just use the fusion table data directly in the map (either as a layer in the map, see Google Maps API, or by creating a specific map for that data via the Google Fusion Table interface directly). You create a new table via Google Drive. Some more info on fusion tables at support.google.com/fusiontables/answer/2571232?hl=en – John Mar 11 '14 at 21:33
  • Would this require an enterprise version of Google? – Ryan Garnett Mar 11 '14 at 21:38
  • I can do it with my free personal Google Account... you'd have to look into the license restrictions if using it for commercial purposes, I don't know those as well. But technically, you should be able to. You would probably have to have beta functionality turned on for Google Drive for your domain to do it as technically it's still a beta product (but it's been out for several years if memory serves correct, so...). Sorry i don't know the license restrictions. – John Mar 11 '14 at 22:23
  • To do it though, go to google drive, click create, and one of the listed options should be "Fusion table (experimental)" or something of that sort. – John Mar 11 '14 at 22:24
  • Thanks so much. I am trying it now. Is there an option for polygons and lines, or just points? – Ryan Garnett Mar 11 '14 at 22:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.