var apiUrlGetAccounts = 'https://graph.facebook.com/v7.0/me/accounts?access_token=' + accessToken; var responseApiGetAccounts = UrlFetchApp.fetch(apiUrlGetAccounts); var result = JSON.parse(responseApiGetAccounts.getContentText());
var apiUrl = 'https://graph.facebook.com/v7.0/'+ PageID +'?fields=instagram_business_account&access_token=' + accessToken; var responseApiGetBusinessAccount = UrlFetchApp.fetch(apiUrl); var resultBusinessAccount = JSON.parse(responseApiGetBusinessAccount.getContentText());
var apiUrl = 'https://graph.facebook.com/v7.0/'+ BusinessID +'?fields=media_count,follows_count,followers_count,media,stories&limit=1000&access_token=' + accessToken; var responseApiGetMedia = UrlFetchApp.fetch(apiUrl); var mediaResult = JSON.parse(responseApiGetMedia.getContentText());
var apiUrl = 'https://graph.facebook.com/v7.0/'+ MediaID +'?fields=comments_count,comments%7Busername%7D&access_token=' + accessToken; var responseApiComments = UrlFetchApp.fetch(apiUrl); var result = JSON.parse(responseApiComments.getContentText());
//Sort usernames usernames.sort(); //Create empty array to count usernames var usernamesArray = []; var usernamesCount = []; var current = null; var count = 0; //Start counter for(var i = 0; i < usernames.length; i++) { //Check for dubplicate names if(usernames[i] != current) { if(count > 0) { usernamesArray.push([current]); usernamesCount.push([count]); } current = usernames[i]; count = 1; } else { count++; } } //import username and count into sheet, then use query inside sheet to get data sheet.getRange(2, 17, usernamesArray.length, 1).setValues(usernamesArray); sheet.getRange(2, 18, usernamesCount.length, 1).setValues(usernamesCount);
=QUERY(Q:R, " SELECT Q,sum(R) group by Q order by sum(R) desc label Q 'Username', sum(R) 'Comments' ")