Get map coordinates based on City, State cell data

google-sheets-get-coordinates.js

/*
 * Uses Google Code built in Maps Geocoder to obtain coordinates for a place in the US, for example: Tucson, AZ
 * Usage: On a sheet, select "Tools" -> "Script editor" and paste below (modify output as necessary)
 *        Then set the value for a blank column to =getCoords(locationCell)
 *        ie. =getCoords(B2)
 *        Expected format: City, State
 *        Format example: Tucson, AZ
 */

function getCoords(value) {
  var response = Maps.newGeocoder().geocode(value);

  Utilities.sleep(1000);
  
  var coords = response.results[0].geometry.location.lat + ", " + response.results[0].geometry.location.lng;
 
  return coords;
}