Function insertCommentsToSheet

YOuTube Comment Code with Likes.js:46–60

(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, 4);
  headerRange.setValues([['Author', 'Comment', 'Published At','Like Count']]);
  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();