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); 
  }
}

@itoldusoandso Happy to hear this code go you started and you were able to build a solution without using expensive 3rd party connections.

Thank you so much for the code. It has been a life saver. I'm only having one issue and it is the names of the files. Do you have any idea on how to have it save the images with the name of the link it used to pull the image from?

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!