How can I update a map I created with data imported from google spreadsheet?

Google Maps tips & tricks
1

Hi,

I created a map with information imported from a google spreadsheet.

It worked great, but people are updating the spreadsheet occasionally.

When I press “open data table” on the map layer, I can manually change info from the imported table, but it seems like the import was a one time thing and that the spreadsheet can’t be updated and show in the map with the changes or additions. Is this so?

How can the map be updated with the new rows or updated information from the spreadsheet?

Thanks!

9 Likes
2

That is correct @Hadasul the import is one time. The Map and spreadsheet don’t maintain any kind of link. The only way to update is to import again. You probably only want to import the changed rows.

If you want a more live integration you can do that through the API. You will need a license key, for personal development that is free (there are limits) for production use they aren’t expensive.

1 Like
3

Thanks @PaulPavlinovich , at least I can stop trying to get it to update :grin:.

1 Like