Function insertCommentsToSheet

YouTube_Comments.js:47–61

(comments)

// Helper function to insert comments into Google Sheets
function insertCommentsToSheet(comments) {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  // Insert header at row 5 and apply formatting
  const headerRange = sheet.getRange(5, 1, 1, 3);
  headerRange.setValues([['Author', 'Comment', 'Published At']]);
  headerRange.setFontWeight('bold'); // Make headers bold
  headerRange.setBackground('#f0f0f0'); // Light grey background for headers
  headerRange.setHorizontalAlignment('center'); // Center align headers
  
  // Insert comments starting from row 5
  if (comments.length > 0) {
    sheet.getRange(6, 1, comments.length, comments[0].length).setValues(comments);
  }
}

function auth() {
  cache = CacheService.getUserCache();