ip-api.com を利用した所在地取得

region.js

function getRegionName(ip) {
  var cache = CacheService.getPublicCache();
  var cacheKey = "api:ip-api.com:" + ip;
  var region = cache.get(cacheKey);
 
  if (region == null) {
    var geo = UrlFetchApp.fetch("http://ip-api.com/json/" + ip).getContentText();
    region = JSON.parse(geo).regionName;
    
    cache.put(cacheKey, region, 60 * 60 * 8);
  }
  
  return region;
}