KazooTTT

function onOpenFunc() {
  PropertiesService.getScriptProperties().setProperty("accessToken", ScriptApp.getOAuthToken());
}

function getVideoViews(videoid) {
  var accessToken = PropertiesService.getScriptProperties().getProperty('accessToken');
  
  // Check if the access token exists
  if (!accessToken) {
    Logger.log('No access token found.');
    return 'Error: No access token';
  }
  
  try {
    var videoStatsResponse = YouTube.Videos.list('statistics', {
      'id': videoid, 
      'access_token': accessToken
    });
    
    // Check if the response contains the expected data
    if (videoStatsResponse.items && videoStatsResponse.items[0] && videoStatsResponse.items[0].statistics) {
      return videoStatsResponse.items[0].statistics.viewCount;
    } else {
      Logger.log('No statistics found for video ID: ' + videoid);
      return 'Error: No statistics';
    }
  } catch (error) {
    Logger.log('Error fetching statistics for video ID ' + videoid + ': ' + error.toString());
    return 'Error: ' + error.toString();
  }
}

function recordYouTubeViewCount() {
  // Get the active spreadsheet
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  // Get the ID from the second row
  var videoId = sheet.getRange(2, 2).getValue();   
  
  // Get the current time
  var currentTime = new Date();
  
  try {
    // Get the view count
    var viewCount = getVideoViews(videoId);
    
    // Get the last row of the current spreadsheet
    var lastRow = sheet.getLastRow();
    
    // Insert a new row after the last row and fill in the time and view count
    sheet.insertRowAfter(lastRow);
    sheet.getRange(lastRow + 1, 3).setValue(currentTime); // Set time
    sheet.getRange(lastRow + 1, 4).setValue(viewCount); // Set view count
  } catch (error) {
    // Error handling
    Logger.log('Error processing video ' + videoId + ': ' + error.toString());
    
    // If an error occurs, record the error message
    var lastRow = sheet.getLastRow();
    sheet.insertRowAfter(lastRow);
    sheet.getRange(lastRow + 1, 3).setValue(currentTime); // Set time
    sheet.getRange(lastRow + 1, 4).setValue('Error: ' + error.toString()); // Set error message
  }
}