Apps Script use Google Maps Javascript API with custom-defined script property API key

geocode.gs

// addresses "Exception: Service invoked too many times for one day: geocode" because the built-in Maps App does not support API keys
// you must create an API key in Maps API in the Google Cloud Console for insertion into Script Properties `mapsApiKey`

function doGeoCode(address) {
    var serviceUrl = `https://maps.googleapis.com/maps/api/geocode/json?address=${address}&key=${ScriptProperties.getProperty('mapsApiKey')}`;
    var response=UrlFetchApp.fetch(serviceUrl, options);
      if(response.getResponseCode() == 200) {
        var responseJSON = JSON.parse(response.getContentText());
        if (responseJSON !== null) { return responseJSON; }
      }
      return false;
}