Dynamic Linking of Map & Spreadsheet

The following instructions allows the map generated by GPSVisualizer to be dynamically linked with the spreadsheet that generated the original data. This means that all changes made to the 'control' spreadsheet will automatically appear in the map every time it is reloaded.  Very cool, again many thanks to: Adam Schneider.

Accessing the spreadsheet:

1. The file should be saved as a doc.google.com/spreadsheet and formatted with lat, long and other data as necessary to generate the popups
2. Open the file, Goto File, Publish to the Web, Start publishing now or Republish now (if the file is already published)
3. Copy, <ctrl>C the resulting URL for pasting into the GPSVisualizer script

Building the Map:

1. Next we go to the GPSVisualizer site and goto Make a Google map from a GPS file
2. Paste <ctrl>V the Spreadsheet URL into the Or a URL that the map will load dynamically box in the lower left corner
3. Expand the WayPoint Options section and changes as necessary, including;
4. Icon:
5. Default color marker:
6. Synthesize name: {name}
7. Synthesize description: Contact: {contact}<br>Phone: {phone} generates a custom form in the popup
8. Press Draw the Map button and cross your fingers
9. Goto the resulting map and then select the save your Google map link and save the file with an appropriate name & as a simple .HTML file
10. That file can now be opened in your browser, and ever time you update the spreadsheet, and press Republish now the map file will update with the new data (after you Reload the map page)

It's like Magic!

 
Or a URL that the map will load dynamically: Os r 


a URL that the map will load dynamica