A Google Script that transforms a zip code into city, state zip via zippopotam.us

zip_code_exploder.gs

// Example use in a cell: "=map(90210)" (without quotes)
// Example output: "Beverly Hills, CA 90210"

function map(zip_code) {
  
  // Make HTTP Request
  var url = 'http://api.zippopotam.us/us/' + zip_code;
  var response = UrlFetchApp.fetch(url);
  var json = response.getContentText();
  var data = JSON.parse(json);
  places = data['places'][0];
  city_output = places['place name'];
  state_output = places['state abbreviation'];
  location = city_output + ', ' + state_output + ' ' + zip_code;
  return location;
}