Pull Airbnb Data into Google Sheets

/**
 * AirROI API Helper — call any endpoint from Google Sheets.
 * @param {string} endpoint  API path, e.g. "/calculator/estimate"
 * @param {Object} params    Query parameters (for GET) or body (for POST)
 * @param {string} method    "GET" (default) or "POST"
 * @return {Object}          Parsed JSON response
 */
function fetchAirROI(endpoint, params, method) {
  var API_KEY = PropertiesService.getScriptProperties()
    .getProperty("AIRROI_API_KEY");
  var BASE_URL = "https://api.airroi.com";
  method = method || "GET";

  var options = {
    method: method,
    headers: {
      "X-API-KEY": API_KEY,
      "Content-Type": "application/json",
    },
    muteHttpExceptions: true,
  };

  var url = BASE_URL + endpoint;

  if (method === "GET" && params) {
    var queryString = Object.keys(params)
      .map(function (key) {
        return encodeURIComponent(key) + "=" +
          encodeURIComponent(params[key]);
      })
      .join("&");
    url += "?" + queryString;
  } else if (method === "POST" && params) {
    options.payload = JSON.stringify(params);
  }

  var response = UrlFetchApp.fetch(url, options);
  return JSON.parse(response.getContentText());
}

/**
 * Estimate Airbnb revenue for a property.
 * Usage: =getRevenue(A2, B2, C2, D2, E2)
 * @param {number} lat       Latitude
 * @param {number} lng       Longitude
 * @param {number} bedrooms  Number of bedrooms
 * @param {number} baths     Number of bathrooms
 * @param {number} guests    Maximum guest count
 * @return {Array}           [[revenue, adr, occupancy]]
 * @customfunction
 */
function getRevenue(lat, lng, bedrooms, baths, guests) {
  var data = fetchAirROI("/calculator/estimate", {
    lat: lat,
    lng: lng,
    bedrooms: bedrooms,
    baths: baths,
    guests: guests,
    currency: "usd",
  });
  return [[data.revenue, data.average_daily_rate, data.occupancy]];
}

=getRevenue(A2, B2, C2, D2, E2)

/**
 * Get market summary metrics.
 * Usage: =getMarketSummary("us", "california", "los angeles")
 * @param {string} country   Country code (e.g., "us")
 * @param {string} region    State/region (e.g., "california")
 * @param {string} locality  City (e.g., "los angeles")
 * @return {Array}           [[occupancy, adr, revpar, revenue, listings]]
 * @customfunction
 */
function getMarketSummary(country, region, locality) {
  var data = fetchAirROI("/markets/summary", {
    market: {
      country: country,
      region: region,
      locality: locality,
    },
    currency: "usd",
    num_months: 12,
  }, "POST");

  return [[
    data.occupancy,
    data.average_daily_rate,
    data.rev_par,
    data.revenue,
    data.active_listings_count,
  ]];
}

=getMarketSummary("us", "florida", "miami")