https://www.pbainbridge.co.uk/2018/12/set-column-url-link-to-doc.html

Set Column Doc Link.gs

function setUrlLink(docUrl, name) {
  
  // existing document Url - remove this line when you incorporate into your script
  var docURL = 'https://docs.google.com/document/d/1vo_mGPR_n54PoLDhgXOfYwkHCC3qb9J1JA_icbneMm4/';
  
  // suitable name for text to display in spreadsheet - remove this line when you incorporate into your script
  var name = 'Finance Spreadsheet';
  
  // get relevant spreadsheet items
  var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var numCols = ss.getLastColumn();
  var lastRow = ss.getLastRow();
  
  // set 'URL' column with link to newly created doc
  ss.getRange(lastRow+1, numCols).setFormula('=HYPERLINK("' + docURL + '","' + name + '")');
  
}