DruFine

palumbo / Download Images.gs

Created June 9, 2022 23:55

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

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