App Script example for Google Sheet

fetchProfile.js

// example on sheet https://res.cloudinary.com/capung-ggwp/image/upload/v1639101873/ss_example_sheet_vs929r.png

function getProfile(username) {
  const url = 'https://instagram-profile1.p.rapidapi.com/getprofile/'+username
  const options = {
    'method' : 'get',
    'headers': {
      'x-rapidapi-host': 'REPLACE_IT_X_RAPIDAPI_HOST',
      'x-rapidapi-key': 'REPLACE_IT_X_RAPIDAPI_KEY'
    }
  };

  const profile = UrlFetchApp.fetch(url, options)
  const profileJSON = JSON.parse(profile.getContentText())
  const last3Media = profileJSON.lastMedia.media.slice(0, 3)
  profileJSON.lastMedia.media = last3Media
  return JSON.stringify(profileJSON)
}

function getFollowers(rawJSON){
  const profileJSON = JSON.parse(rawJSON)
  const followers = profileJSON.followers
  return followers
}

function getBio(rawJSON) {
  const profileJSON = JSON.parse(rawJSON)
  const bio = profileJSON.bio
  return bio
}