Hi all,

I'm not sure this forum is the right place for a question like this, but then maybe you can point me in the right direction.

I have a sheet with a number of different locations, which I would like to create a Google map with. It needs to connect the locations with a marker and lines in the order of appearance. I don't need directions, it just needs to connect "as the crow flies".

The ideal end result is a link that I can open with all markers and lines pre-filled. Much like my static example below. I've tried to look at the documentation and other people's issues, but my coding experience is rather limited, so I'm having a hard time connecting the dots. Here's what I've looked at so far:

https://stackoverflow.com/questions/...ng-java-script
https://developers-dot-devsite-v2-pr.../marker-simple
https://developers-dot-devsite-v2-pr...olyline-simple

I managed to create a static map (without lines) with the Google API which I already obtained.

3T6K7wP.png

https://maps.googleapis.com/maps/api...ptype=roadmap\
&markers=size:mid%7Ccolor:red%7CLondon,UK%7CNew+York,US%7Cape+Town,ZA%7Copenhagen,DK&key=myapikey
Name Latitude Longitude
London, UK 51.5074 -0.1278
New York, US 40.7128 -74.006
Cape Town, ZA -33.918861 18.4241
Copenhagen, DK 55.676098 12.568337

https://docs.google.com/spreadsheets...it?usp=sharing

I'm unsure what is needed for me to be able to generate the map. Am I able to generate a simple link (like the static example), or do I need a bit of coding, where I would need to host the code?

Thanks in advance for any guiding help.