View all of your Google Contacts on a Map
If you keep all of your contacts in Google like I do, you might be interested in seeing a map showing their location. Tech weblog Digital Inspiration shows how you can use their script to connect to your Google account and display a map of your contacts in Google Maps or Google Earth.
You’ll need to copy the spreadsheet to your Google Drive account. Inside the spreadsheet you’ll see a custom menu labelled as Google Contacts. Click on that, choose Initialize, and authorize the script to run. When that is done click again on the Google Contacts menu and choose Generate KML file. The file will be generated and automatically emailed to your Gmail address.
If you have Google Earth installed you can just open the file on your computer to view the map but if you’d prefer to use online Google Maps you’ll just need to upload the file and then copy the link into Google Maps. You can use for example Dropbox.
You’ll see a standard Google map with all of your contacts that have an address listed on their contact entry. For me it’s just fun, but for some of you it might be a simple geomarketing tool to visualize customers location and do some simple analysis.
source: Digital Inspirations