Script created with Google Apps Script, attached to a Google Sheet. Pulls location from a MyMaps page and adds it to the Google Sheet page.
This script was created with a base Google Sheet with the following structure (it was originally intended to feed a "Places to Visit" sheet, hence the column names):
| 1 | A | B | C | D | E | G |
|---|---|---|---|---|---|---|
| 2 | Country | City | Place Name | Type | Already Visited? | |
| 3 | Portugal | Porto | Clérigos | Museum | Yes/No |
To attach the code to a Google Sheet, open the sheet, go to Tools -> Script Editor and paste the code :)