kltng

function extractTextOnOpen() {

    //ADD YOUR VALUES BELOW
    var folderName = "[YOUR PROJECT FOLDER]";
    var sheetId = "[YOUR SHEET ID]";

    //Define folder
    var folder = DriveApp.getFoldersByName(folderName).next();
    var folderId = folder.getId();