I have a spreadsheet containing hotel names, their longitude and latitude, and their age. I want to create a Geo Chart that has markers on their coordinates. Also, if the Hotel Age is below 5 years, the marker is green. If the Hotel Age is above 5 years, the marker turns red. I would like to create this either in Google Sheets or Looker Studio. Can someone help?

I’ve tried creating it in Google Sheets using the Geo Chart with Markers, but I can’t zoom in on my Country (Only continents). In Looker Studio, I can’t zoom in and can’t change the marker’s colours.