Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Update Google Map automatically when Google spreadsheet is updated?

Tags:

google-maps

I'm using Google Maps Engine Lite and placing markers on the map from a Google spreadsheet. At the moment I'm importing these manually into a layer.

Is there a way to automatically update the pins when the spreadsheet is updated?

There very little out there on this or is it because this needs to be done via the API with a coded solution?

like image 727
Rob Avatar asked Sep 25 '13 08:09

Rob


People also ask

Can Google My Maps automatically update?

How often is your maps data updated? The map is updated constantly–literally, every second of every day! We're constantly collecting new information about the world, whether from satellite imagery and Street View cars, or Google Maps users and local business owners, and using that information to update the map.

How do I automatically update the date in Google Sheets when a cell is updated?

Type "=DATE()" into a cell and press "Enter" to display the current date. Similarly, to display the current time, use the NOW function by typing "=NOW()" to display the current date and time in a cell. With either of these functions, whenever the sheet is recalculated, the date or time is recalculated as well.


1 Answers

I actually found that using Google Fusion tables solved this problem so that when that was updated, so was the map.

like image 170
Rob Avatar answered Jan 02 '23 11:01

Rob