We have a spreadsheet with 2 tabs:
- Running Campaigns
- Pool Health
[login to view URL]
I need a Google Map visualising these 2 tabs on a map, like shown in the attached screenshot/mockup.
A big circle shows the pool health as area (green, yellow, red) and the little campaign icons show where campaigns are currently running.
The spreadsheet above can change anytime, which should then reflect the latest data on the map without the need to import data anew.