Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function checkLiveAccount() {
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var sheet = ss.getActiveSheet();
- for (var i = 2; i < 200; i++) {
- var accessToken = sheet.getRange(i, 6).getValue();
- if (accessToken.length > 0) {
- try {
- var urlApiInfoMe = 'https://graph.facebook.com/v4.0/me?fields=id%2Cname&access_token=' + accessToken;
- var response = UrlFetchApp.fetch(urlApiInfoMe);
- var responseCode = response.getResponseCode()
- // SpreadsheetApp.getUi().alert(responseCode);
- sheet.getRange(i, 11).setBackground("#00FF00")
- sheet.getRange(i, 11).setValue("LIVE");
- } catch(e) {
- sheet.getRange(i, 11).setBackground("#4267B2")
- sheet.getRange(i, 11).setValue("CHECKPOINT");
- // SpreadsheetApp.getUi().alert(e);
- }
- }
- }
- SpreadsheetApp.getUi().alert("DONE");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement