getImageURLsfromDrive.js

function getImages() {
    const sheet = SpreadsheetApp.openById(ID);

    const db = DriveApp.getFolderById(ID)
    const dbFiles = db.getFiles();
    while (dbFiles.hasNext()) {

        const file = dbFiles.next()
        const driveURL = file.getUrl()
        const {
            origin,
            pathname
        } = new URL(driveURL)
        const imageID = pathname.split('/')[3]

        const imageURL = `${origin}/uc/export=view&id=${imageID}`

        const imageResponse = UrlFetchApp.fetch(imageURL);


    }

}