An Example of Pulling Twitter Followers using Apps Script

example.gs

var sheetName = "_Example";
var screenName = "imgracehuang";

function populateFollowerCount() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName(sheetName);
  var response = fetch("https://cdn.syndication.twimg.com/widgets/followbutton/info.json?screen_names=" + screenName);
  var followerCount;
  if (response && response[0]) {
    followerCount = response[0].followers_count
  }

  sheet.appendRow([Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd"), followerCount]);
};

function fetch(url) {
  var ignoreError = {
    "muteHttpExcecptions": true
  };
  var source = UrlFetchApp.fetch(url, ignoreError).getContentText();
  var data = JSON.parse(source);
  return data;
}