Geocoding Postal Addresses with Google Maps API

Let’s say you have a bunch of postal address in a spreadsheet and you wish to geocode these addresses (get the latitude and longitude information).

While there are several web apps available that that can geocode addresses, one of the easier options is available inside Google Apps Script.

Just past the list of postal address in a column in Google Docs spreadsheet and then run the following Google Apps Script to transform them into latitudes and longitudes.

function geocode_Addresses() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var locationInfo = sheet.getRange(1, 1, sheet.getLastRow() - 1, 1).getValues();
  var geoResults, lat, lng;

  for (var i = 0; i < locationInfo.length; i++) {
    geoResults = Maps.newGeocoder().geocode(locationInfo[i]);

    // Get the latitude and longitude
    lat = geoResults.results[0];
    lng = geoResults.results[0].geometry.location.lng;
    sheet.getRange(i+1, 2, 1, 1).setValue(lat + "," + lng);    

Important: The sleep function is important else Google Apps Script might return an error saying Service Invoked Too Many Times.