-
-
Save jonathanzuniga/589d533e35473f37a37e702d16530a81 to your computer and use it in GitHub Desktop.
The code I used to download images into a Google Sheets cell or download images into a Google Drive folder.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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); | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment