In the process of building a Google My Maps map, I found that it's quite handy to import spreadsheets from your Google Drive to use it as a source for your map layers. As using spreadsheets is pretty much the only option to add data to your map, I assumed that the map would update whenever I add new data to the spreadsheet. I just can't find the option to update from the source/spreadsheet. The idea that this was possible has its origins in …
- Reading "updated" in the "The Walking Dead Map" and other custom maps
- The reason that a spreadsheet is a must-have to get data into the map
Now I can only see that I have something like a Google Fusion Table after importing the data (once), but no real link to the original data, so no Spreadsheet-as-Database behind it, only one directional route to go. As far as I can see, the original spreadsheet could simply be empty (aside from the headline) as well and I could add the data than in the data table in Google Maps. Adding data to the spreadsheet does do nothing to the data in Maps so far. The same goes for adding data to the data table in Maps, which updates nothing in the Spreadsheet.
The help pages do not offer really any help on that topic as they only explain the "move data into maps" process and have nothing covering updates.
Questions: Is there a way (or a reasonable workaround) to update the my-maps-data/layer-data from the spreadsheet? Or can I update the spreadsheet from the data table in Maps?