Reports Twitter spam from a Google Sheet archive.

spamReport.gs

function reportSpam() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Archive');
  var range = sheet.getRange(2, 1,sheet.getLastRow(), sheet.getLastColumn());
  var cells = range.getValues();
  
  // Loop through the range where [i] is the ROW
  for(var i=0;i<cells.length;i++) {
    
    // Look for profile ID's matching spam websites
    if(cells[i][17] == "mmsg.net") {
      
      // Grab the User ID and Username from the archive
      var id = cells[i][0].toString();
      var user = cells[i][1].toString();
      
      // Post to the Twitter REST API to report spam.
      TwtrService.post("https://api.twitter.com/1.1/users/report_spam.json?screen_name=" + user + "&user_id=" + id);
      
      Logger.log('Spam reported for ' + user);
    } else {
      Logger.log('Not spam');
    }
  }
}