MyMaps Combiner


Back in March 2017 I was working with a math teacher using the Very Large Array (see map)in New Mexico to study Area using maps.  The students explored the VLA to discover things like the size of each satellite dish, the distance between each dish, and to measure the farthest distance that a dish could be send down each of the 3 sets of tracks.  The students had lots of fun exploring the VLA and using the various tools in Google MyMaps.


We worked with 3 classes that day, creating nearly 100 student MyMaps.  That was when I realized there was a problem, the teacher would have need to look through each of these maps to measure students understanding of the tools and underlying mathematical principals.  Each MyMap to around 30 seconds to load and then some additional time to explore.  If the teacher took a combined total of 1 minute for each student they would need over 1 1-/2 hours to look at these maps.  Reality is, no teacher has that time.


To save teacher the time necessary to explore a classroom worth of MyMaps, I have developed the MyMaps Combiner (available at  This tool assumes that you are collecting MyMaps into a single folder (for example using a Google Classroom assignment to collect the students MyMaps).  After choosing to make a copy of the file

You will be greeted by the OTT-o-matic MyMaps Combiner tool!

Which also added the “OTT-o-matic Functions” menu to the menubar

Step 1

From the OTT-o-matic Functions menu choose “Step 1) Select Drive Folder with MyMaps”.  You will select the folder from your Google Drive that contains the MyMaps you would like to combine.  The first time you run this you will be asked for permission to run this script.

  and then  

You will then be prompted to select the folder

  and then  

Select the folder that contains your MyMaps

The script will collect the MyMaps information contained within that folder and will add them to the Spreadsheet.  You will get a summary of that was done.

Step 2)

Caution: You must own the Google MyMaps for this part of the process.
Have your students submit the assignment, or individually set you as the owner of the file.

From the OTT-o-matic Functions menu choose “Step 2) Create MyMaps combine KML file”. This will take a few moments to combine all of the MyMap information into one KML (Keyhole Markup Language) file that can saved and opened into Google Earth.  The file will be named after the folder you selected and will end in kml.  This file will be located in your Google Drive and should automatically be placed in the selected MyMaps folder (based on permissions).

Step 3)

Using Google Earth Pro or Google Earth For Chrome open the KML file.  The combined KML will load into Google Earth as a single map, with each MyMap being contained in a subfolder.  From here you can turn on and off layers and explore your students MyMaps.

Step 4)

When you want to refresh your view in Google Earth of the MyMaps, you can simply reload the combined KML file.  This file uses network linking to access each MyMaps, so when you reload the combined KML file, new data is pulled from each map.  If you need additional MyMaps to be included, re-run steps 1 and 2 to create a new combine KML file.