title: Reverse geocode in Google docs
body: <p>I am trying to get countries and cities from Geocodes location (i.e.: 51.5665,-1.2410)  in a Google Spreadsheet. I found a code to get Latitude and Longitude from a city with the country but I cannot manage to change it to use the reverse function.</p>
  
  <pre><code>function onOpen() {
      // Add the Geocode menu
      SpreadsheetApp.getActiveSpreadsheet().addMenu("Geocoder", [{
          name: "Geocode addresses",
          functionName: 'geocode'
      }]);
  }
  
  function geocode() {
      // Get the current spreadsheet, sheet, range and selected addresses
      var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
      var sheet = SpreadsheetApp.getActiveSheet();
      var range = SpreadsheetApp.getActiveRange();
      var addresses = range.getValues();
  
      // Determine the first row and column to geocode
      var row = range.getRow();
      var column = range.getColumn();
  
      // Set default destination columns
      var destination = new Array();
      destination[0] = column + 1;
      destination[1] = column + 2;
  
      // Prompt for latitude and longitude columns
      var response = Browser.inputBox("Coordinate Columns",
          "Please specify which columns should contain the latitude " +
          "and longitude values [ie. 'C,D', 'A,F', etc]. Leave blank to " +
          "insert new columns.",
          Browser.Buttons.OK_CANCEL);
      if (response == 'cancel') return;
      if (response == '')
          sheet.insertColumnsAfter(column, 2);
      else {
          var coord_columns = response.split(',');
          destination[0] = sheet.getRange(coord_columns[0] + '1').getColumn();
          destination[1] = sheet.getRange(coord_columns[1] + '1').getColumn();
      }
  
      // Initialize the geocoder and set loading status
      var geocoder = Maps.newGeocoder();
      var count = range.getHeight();
      spreadsheet.toast(count + " addresses are currently being geocoded. " +
                        "Please wait.", "Loading...", -1);
  
      // Iterate through addresses and geocode
      for (i in addresses) {
          var location = geocoder.geocode(
              addresses[i]).results[0].geometry.location;
          sheet.getRange(row, destination[0]).setValue(location.lat);
          sheet.getRange(row++, destination[1]).setValue(location.lng);
          Utilities.sleep(200);
      }
  
      // Remove loading status
      spreadsheet.toast("Geocoding is now complete.", "Finished", -1);
  }
  </code></pre>
  
  <p>To be more precise I would like to find a script that take a latitude and longitude and returns the city in a column and the country in another one.</p>