GET PHOTOS unsplash

/*
  Get you're ACCESS_KEY here: https://unsplash.com/developers
*/

/**
* Returns image url(s)
*
* @param {A1:A5} range - Input range.
* @return {array} ImageUrls.
* @customfunction
*/
function GETPHOTOS(searchQuery) {
  const ACCES_KEY = 'Nl-yyyyyy1wYTS0Laxxxxxx'
  if (!Array.isArray(searchQuery)) {
    searchQuery = [searchQuery]
  }

  const urls = searchQuery.flat().map(q => {
    return {
      url: `https://api.unsplash.com/search/photos?per_page=1&query=${q}`,
      headers: {
        Authorization: `Client-ID ${ACCES_KEY}`
      }
    }
  });

  const responses = UrlFetchApp.fetchAll(urls);
  const imageUrls = responses.map(res => {
    const json = JSON.parse(res.getContentText());
    const imageUrl = json.results[0].urls.small;
    return imageUrl
  });

  return imageUrls
}