The code I used to download images into a Google Sheets cell or download images into a Google Drive folder.

Download Images.gs

function insertImage() {

  let sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); 
  let lastRow = sheet.getLastRow(); 

  for (let i = 0; i < lastRow-1; i++) {
    let url = sheet.getRange(2+i,1).getValue(); 
    let image = SpreadsheetApp.newCellImage().setSourceUrl(url); 
    sheet.getRange(2+i,2).setValue(image); 
  }
}

function downloadImage() {
  let sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); 
  let lastRow = sheet.getLastRow(); 

  let folder = DriveApp.getFolderById("1W4pv0RW7DB_yh8pqChc8YPNyq0ETQ_1m"); 

  for (let i = 0; i < lastRow-1; i++) {
    let url = sheet.getRange(2+i,1).getValue(); 
    let blob = UrlFetchApp.fetch(url).getBlob(); 
    folder.createFile(blob); 
  }
}

For me it downloads the file exactly as it is saved in Airtable. Airtable exports automatically to Google Sheets via automation by creating temp download links and then this GS Script downloads the files with the original file name. What do you mean save the name of the link. I doubt you can save file name with forward slash or http:// .

@itoldusoandso The things that you tweaked the code for sound exactly like what I need. I'm working on an automation using Make that posts to Instagram from a Google Sheet that was populated by a form filled out on a Wix site. Would you mind sharing your tweaked code with me?

@palumbo Thanks for making the YouTube video and sharing the code!