In Minimizing maps directionfinder api calls I showed how to make the most of your directions API quota in the context of a spreadsheet. Here's an example of calling it directly, say when you are working on a map viz and need to work on some directions and geocoding.
You can take a copy of this sheet and the code at https://docs.google.com/spreadsheet/ccc?key=0At2ExLh4POiZdFpHWXF1UGR1NnlhU21Rd0trTW45dFE&usp=sharing
Let's say we have a list of destinations and one start point, and want to sort the destinations in order of distance from the start point, and return coordinate, distance and driving time to each of these destinations. Using the functions in Minimizing maps directionfinder api calls, this becomes fairly trivial
Gives this result
See Google Apps Scripts snippets for more like this
You want to learn Google Apps Script?
Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly.
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Google Apps Scripts snippets >