/*function myFunction() {

}*/

// the name of the sheet within your document
var sheetName = "fiat";
// the name of the Instagram account you want to track
var instagramAccountName = "fiatboliviabo";
var instagramAccountName2 = "fiatcl";
var instagramAccountName3 = "fiatcol";
var instagramAccountName4 = "fiatcr";
var instagramAccountName5 = "fiat_ecuador";
var instagramAccountName6 = "fiatguatemala";
var instagramAccountName7 = "fiatpanama";
var instagramAccountName8 = "fiatpy";
var instagramAccountName9 = "fiatperuoficial";
var instagramAccountName10 = "fiat.uy";

function insertFollowerCount() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName(this.sheetName);
 accountdata = getInstagramData(this.instagramAccountName);
 accountdata2 = getInstagramData(this.instagramAccountName2);
 accountdata3 = getInstagramData(this.instagramAccountName3);
 accountdata4 = getInstagramData(this.instagramAccountName4);
 accountdata5 = getInstagramData(this.instagramAccountName5);
 accountdata6 = getInstagramData(this.instagramAccountName6);
 accountdata7 = getInstagramData(this.instagramAccountName7);
 accountdata8 = getInstagramData(this.instagramAccountName8);
 accountdata9 = getInstagramData(this.instagramAccountName9);
 accountdata10 = getInstagramData(this.instagramAccountName10);

  sheet.appendRow([Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd"), accountdata.followerCount, accountdata2.followerCount, accountdata3.followerCount, accountdata4.followerCount, accountdata5.followerCount, accountdata6.followerCount, accountdata7.followerCount, accountdata8.followerCount, accountdata9.followerCount, accountdata10.followerCount ]);
 };

function getInstagramData(username) {
  var r = new RegExp('<script type="text\/javascript">' +
                   '([^{]+?({.*profile_pic_url.*})[^}]+?)' +
                   '<\/script>');
  var url = "https://www.instagram.com/" + username
  var source = UrlFetchApp.fetch(url).getContentText();
  var jsonStr = source.match(r)[2];
  var data = JSON.parse(jsonStr);
  console.log('data', data);
  var oldVariantOfData = data['entry_data']['ProfilePage'][0];
  console.log('oldVariantOfData', oldVariantOfData);

  return {
    followerCount : oldVariantOfData.graphql.user.edge_followed_by.count,
    followCount : oldVariantOfData.graphql.user.edge_follow.count,
    mediaCount : oldVariantOfData.graphql.user.edge_owner_to_timeline_media.count
  };
}