Step 25

Enter the actual data for your Google Map.

Step 26

The information in each cell matches the information at the top of the column.

Step 27

Go to the Publish tab (1) and re-publish the document (2) to update the information.

This updates the information to every instance of this spreadsheet. 

Step 28

Switch to Google Earth and control+click "Link to spreadsheet" (1) and select refresh (2).

Step 29

The new location points with the changed color and changed label color are displayed. 

Step 30

Click any location icon or sidebar list item to see the custom information and graphics displayed in the template.