[Replace Links] grab a drive link from a spreadsheet and replace it with an embeddable url #gsuite #gas #sheets

replaceLinks.js

function replaceLinks() {
  const trainingSheet = SpreadsheetApp.getActive().getSheetByName('Data');
  const trainingRange = trainingSheet.getRange(3, 3, trainingSheet.getLastRow() - 2);
  const values = trainingRange.getValues();
  
  values.forEach(([link], ind) => {
    const matches = /\/([\w-_]{15,})\/(.*?gid=(\d+))?/.exec(link); 
    
    if(!matches) {
      return;
    }
    
    values[ind] = ['https://drive.google.com/uc?export=view&id=' + matches[1]];
  });
  
  console.log(values);
  trainingRange.setValues(values);
}