dab2020/gist:7ac83cbd79dbf22c989e9aa061dfceac

function getFileDetailsAndGenerateLink() {
  // Get the active Google Spreadsheet
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  // Get the data range of the sheet
  var dataRange = sheet.getDataRange();
  var data = dataRange.getValues();
  
  // Iterate through each row starting from the second row (assuming headers in the first row)
  for (var i = 1; i < data.length; i++) {
    // Get the File ID from the third column (column index 2)
    var fileId = data[i][2];
    
    // Check if the fileId is not empty
    if (fileId) {
      // Get the file extension from the fileId
      var fileExtension = getFileExtension(fileId);
      
      // Generate the direct download link for the fileId
      var downloadLink = "https://drive.google.com/uc?export=download&id=" + fileId;
      
      var name = getFilenam(fileId)
      // Update the fourth and fifth columns (columns index 3 and 4)
      sheet.getRange(i + 1, 4).setValue(fileExtension);
      sheet.getRange(i + 1, 5).setValue(downloadLink);
      sheet.getRange(i + 1, 6).setValue(name);
      console.log("Executing");
      console.log("Data Row #" + i + "Picture Name: " + name );
      console.log("***************")
    }
  }
}

// Function to get the file extension from the fileId
function getFileExtension(fileId) {
  var file = DriveApp.getFileById(fileId);
  var fileName = file.getName();
  var fileExtension = fileName.split('.').pop();
  return fileExtension;
}

function getFilenam(fileId) {
  var file = DriveApp.getFileById(fileId);
  var fileNam = file.getName();
  return fileNam;
}