How to sync Google maps and Google Sheets?

Question

Google Maps

The essence of the subject is in the following. There is a google spreadsheet with addresses and there is a google map. Everyone knows that you can automatically upload addresses to the map from the table, very convenient and cool. How to make it so that when the data in the tables is automatically changed, the data on the map changes (new addresses are added or old ones are deleted)? Now it turns out that you need to reload the table every time, delete and load the documents again.
Thank you all, I need a working version, the topic is very relevant for me.

Answer 1

There is still no such possibility.
Put an asterisk here https://issuetracker.google.com/issues/35820262 and wait like everyone else.

Answer 2

You can use third-party developers to display Google Sheets data in Google maps.
I will modestly offer my own version:
https://gsuite.google.com/marketplace/app/map_for_...
https://apps.myrout.es/mfw
Demo examples are available in addition:
- Add-ons - Map for Web - Show ideas - Markers - Complex markers.
- Add-ons - Map for Web - Show ideas - Markers - Markers clustering for clustering markers.
- Add-ons - Map for Web - Show ideas - Markers - infoWindow to show popup window.
- Add-ons - Map for Web - Show ideas - Maps - Map options and controls for styling your map.
To publish the map you created, you need:
- your own Google Maps API key under Add-ons - Map for Web - Settings;
- Subscribing to the add-on after the trial period.