Automated Music cue sheet

Here you go, It's working for me, I guess it still needs a bit of testing and making sure the filter is right.
@Kitch, thank you so much, if you can, please review the code to find the faults.

/*
///////////////// Auto Music List /////////////////////

This script will:

save as.. and append _MUSIC LIST to Session name
show all tracks
hide inactive tracks
select tracks by key word in the comments section of each track, the word can be changed on the "SELECT TRACKS BY WORDS IN COMMENTS" section.
clean clip groups
delete fades
export session info as text to the session folder

filtered to include only:
session name
clip nme, start time, end time, duration of Unmuted clips on channel 1

create clean txt on session folder
soundflow will create new spreadsheet and paste (this is setup for my NeoOffice)
save as the same name as pro tools session on session folder

if you need to use adiferent spreadsheet application you need to change the "WAIT AND PASTE ON NEOOFFICE" section
and the "SAVE NEOOFFICE" for your application

Close NeoOffice and Pro tools


enjoy!

*/



sf.ui.proTools.appActivate();
sf.ui.proTools.invalidate();

sf.ui.proTools.menuClick({
    menuPath: ["File","Save As..."],
});
sf.ui.proTools.windows.whoseTitle.is('Save').first.elementWaitFor({
    failIfNotFound: true,
});



//////////////////////////////// SAVE AS SESSION NAME -OPERATOR NAME +LISTA MUSICA///////////////
var sessionPath = sf.ui.proTools.mainWindow.sessionPath;
var sessionName = sessionPath.split('/').slice(-1)[0].split('.').slice(0, -1).join('.');
var newname = sessionName + "_" + "MUSIC LIST";

sf.ui.proTools.windows.whoseTitle.is('Save').first.textFields.first.elementSetTextFieldWithAreaValue({
    value: newname,
});

sf.ui.proTools.windows.whoseTitle.is('Save').first.buttons.whoseTitle.is('Save').first.elementClick();
sf.ui.proTools.windows.whoseTitle.is('Save').first.elementWaitFor({
    waitType: "Disappear",
    timeout: -1,
});


/////////////////////////////////////////////////////SHOW All/HIDE INACTIVE TRACKS/////////////////

sf.ui.proTools.menuClick({
    menuPath: ["Options","Link Track and Edit Selection"],
    targetValue: "Enable",
});

sf.ui.proTools.menuClick({
     menuPath: ["View", "Other Displays", "Track List"],
     targetValue: "Enable",
});
sf.ui.proTools.mainWindow.buttons.whoseTitle.is('Track List pop-up').first.popupMenuSelect({
       menuPath: ["Show All Tracks"]
});  
sf.ui.proTools.mainWindow.buttons.whoseTitle.is('Track List pop-up').first.popupMenuSelect({
       menuPath: ["Hide", "Inactive Tracks"]
});  


//////////////////////////////////SELECT TRACKS BY WORDS IN COMMENTS/////////////////////////



// Make sure comments are visible
if (!sf.ui.proTools.getMenuItem("View","Edit Window Views","Comments").isMenuChecked) {
    sf.ui.proTools.menuClick({
    menuPath: ["View","Edit Window Views","Comments"],
});
}

function selecttrackbywordincomments(){

const visibleTracks = sf.ui.proTools.trackGetVisibleTracks().names;
var firstTrackFound;
let foundTracks = [];

// Make sure we're on the Edit window. Required to scroll to first selected track.
if (!sf.ui.proTools.getMenuItem("Window", "Edit").isMenuChecked) {
    sf.ui.proTools.menuClick({
        menuPath: ["Window", "Edit"],
    })
}

// Make sure comments are visible
if (!sf.ui.proTools.getMenuItem("View", "Edit Window Views", "Comments").isMenuChecked) {
    sf.ui.proTools.menuClick({
        menuPath: ["View", "Edit Window Views", "Comments"],
    });
}

while (true) {
    // Ask for search query
    const searchQuery = 
    
/// example of search list   ("word1 word2 word3")
    ("MUSICLIST")

    // Format query to RegEx
    const searchQueryRegEx = new RegExp(searchQuery.split(" ").join("|").replace(/^/, "\\b(").replace(/$/, ")\\b"), "i");

    // Deselect all tracks
    sf.ui.proTools.trackDeselectAll();

    // Search visible tracks for search query
    for (var i = 0; i < visibleTracks.length; i++) {
        var trackCommentHasSearch = sf.ui.proTools.trackGetByName({ name: visibleTracks[i] }).track.textFields.first.value.value.match(searchQueryRegEx);

        if (trackCommentHasSearch) {
            if (!firstTrackFound) { // Scroll to first track found
                sf.ui.proTools.trackGetByName({ name: visibleTracks[i], }).track.trackScrollToView();
                firstTrackFound = !firstTrackFound;
            } else {
                sf.ui.proTools.trackSelectByName({ names: [visibleTracks[i]], deselectOthers: false });
            }
            foundTracks.push(visibleTracks[i]);
        }
    }
    if (foundTracks.length !== 0) {
        break;
    } else if (!confirm("No tracks found. Try another search?")) {
        break;
    }
}
}
selecttrackbywordincomments()

//////////////////////////////////////////

 sf.ui.proTools.mainWindow.buttons.whoseTitle.is('Track List pop-up').first.popupMenuSelect({
     menuPath: ["Show Only Selected Tracks"],
 });


//////////////////////////////////////////////////////////////////////////////////////

////clean fades and clip groups


 sf.ui.proTools.selectedTrack.popupButtons.whoseTitle.is('Track View selector').first.popupMenuSelect({
     menuPath: ["waveform"],
     isOption: true,  
 });

sf.ui.proTools.menuClick({
    menuPath: ["Edit","Select All"],
});
sf.ui.proTools.menuClick({
    menuPath: ["Clip","Ungroup All"],
});

selecttrackbywordincomments();

sf.ui.proTools.menuClick({
    menuPath: ["Edit","Select All"],
});

sf.ui.proTools.menuClick({
    menuPath: ["Edit","Fades","Delete"],
});

selecttrackbywordincomments();


////////////////////////////////////////////////////////
////Close Comments so next open sessions doesn't show them
if (sf.ui.proTools.getMenuItem("View","Edit Window Views","Comments").isMenuChecked) {
    sf.ui.proTools.menuClick({
    menuPath: ["View","Edit Window Views","Comments"],
});
}

////////////////////////////////  EXPORT AS TEXT   //////////////////



sf.ui.proTools.menuClick({
    menuPath: ["File","Export","Session Info as Text..."],
});

sf.wait({
    intervalMs: 100,
});

sf.ui.proTools.windows.whoseTitle.is('Export Session Text').first.checkBoxes.whoseTitle.is('Include File List').first.checkboxSet({
    targetValue: "Disable",
});

sf.ui.proTools.windows.whoseTitle.is('Export Session Text').first.checkBoxes.whoseTitle.is('Include Clip List').first.checkboxSet({
    targetValue: "Disable",
});

sf.ui.proTools.windows.whoseTitle.is('Export Session Text').first.checkBoxes.whoseTitle.is('Include Markers').first.checkboxSet({
    targetValue: "Disable",
});

sf.ui.proTools.windows.whoseTitle.is('Export Session Text').first.checkBoxes.whoseTitle.is('Include Plug-In List').first.checkboxSet({
    targetValue: "Disable",
});

sf.ui.proTools.windows.whoseTitle.is('Export Session Text').first.checkBoxes.whoseDescription.is('').allItems[4].checkboxSet({
    targetValue: "Enable",
});

sf.ui.proTools.windows.whoseTitle.is('Export Session Text').first.radioButtons.whoseDescription.is('').first.checkboxSet({
    targetValue: "Disable",
});

sf.ui.proTools.windows.whoseTitle.is('Export Session Text').first.radioButtons.whoseTitle.is('Selected Tracks Only').first.checkboxSet({
    targetValue: "Enable",
});

sf.ui.proTools.windows.whoseTitle.is('Export Session Text').first.checkBoxes.whoseTitle.is('Show Subframes').first.checkboxSet({
    targetValue: "Disable",
});

sf.ui.proTools.windows.whoseTitle.is('Export Session Text').first.checkBoxes.whoseTitle.is('Include User Timestamps').first.checkboxSet({
    targetValue: "Disable",
});

sf.ui.proTools.windows.whoseTitle.is('Export Session Text').first.radioButtons.whoseDescription.is('').allItems[3].checkboxSet({
    targetValue: "Enable",
});

sf.ui.proTools.windows.whoseTitle.is('Export Session Text').first.popupButtons.whoseDescription.is('').first.popupMenuSelect({
    menuPath: ["Timecode"],
});

sf.ui.proTools.windows.whoseTitle.is('Export Session Text').first.popupButtons.whoseDescription.is('').allItems[1].popupMenuSelect({
    menuPath: ["UTF-8 'TEXT'"],
});

sf.ui.proTools.windows.whoseTitle.is('Export Session Text').first.buttons.whoseTitle.is('OK').first.elementClick();

sf.wait();

///////////////////////// SAVE text LOCATION  ///////////////////////////
sf.ui.proTools.invalidate();
var sessionPath = sf.ui.proTools.mainWindow.sessionPath;
var folderPath = sessionPath.split(".").slice(0,-1).join().split("/").slice(1 ,-1).join("/");
var sessionName = sessionPath.split('/').slice(-1)[0].split('.').slice(0, -1).join('.');

sf.keyboard.type({ text: '/' });

sf.keyboard.type({ text: folderPath });

sf.keyboard.press({ keys: 'enter' });

sf.ui.proTools.windows.whoseTitle.is('Save').first.sheets.first.elementWaitFor({
    waitType: "Disappear",
});

sf.ui.proTools.windows.whoseTitle.is('Save').first.getElement('AXDefaultButton').elementClick();

sf.ui.proTools.windows.whoseTitle.is('Save').first.sheets.first.elementWaitFor({
    waitType: "Disappear",
});
///////////////////////////////////////// Kitch Clean TXT /////////////////////////////
///////////////////////////////////////// Kitch Clean TXT /////////////////////////////

var sessionPath = sf.ui.proTools.mainWindow.sessionPath;
var sessionName = sessionPath.split('/').slice(-1)[0].split('.').slice(0, -1).join('.');
//const outputPath = folderPath + '/' + sessionName + '_' + 'CLEAN' + '.' + 'txt';

const inputPath =  folderPath + '/' + sessionName  + '.' + 'txt';

function convertTextFile(inputPath, outputPath) {
    let data = sf.file.readText({ path: inputPath }).text;

    let sessionNameHeading = data.toString().split(':')[0].trim() + ':';
    let sessionName = data.toString().split(':')[1].split('\n')[0].trim();

    let header = data.split('\n').filter(line => line.startsWith('CHANNEL'))[0].split('\t').map(item => item.trim()).slice(2, -1);

    let textFileLines = data.split(/\n/g).filter(line => line.endsWith('Unmuted'))
        .filter(line => line.startsWith('1'))
        .join().split('\t').map(item => item.replace(/\,/g,"").trim())
        .join().split('Unmuted');

    let filteredLines = [];

    for (let i = 0; i < textFileLines.length; i++) {
        if (textFileLines[i]) {
            filteredLines[i] = textFileLines[i].split(',').filter(item => item).slice(2).join(',').split(',');
        }
    }

    filteredLines.unshift(header);

    function convertToArrayOfObjects(data) {
        var keys = data.shift(),
            i = 0, k = 0,
            obj = null,
            output = [];

        for (i = 0; i < data.length; i++) {
            obj = {};

            for (k = 0; k < keys.length; k++) {
                obj[keys[k]] = data[i][k];
            }
            output.push(obj);
        }
        return output;
    }

    let sortArray = convertToArrayOfObjects(filteredLines);

    sortArray.sort(function (a, b) {
        var nameA = a["START TIME"]
        var nameB = b["START TIME"]
        if (nameA < nameB) {
            return -1;
        }
        if (nameA > nameB) {
            return 1;
        }
        return 0;
    });

    sortArray.forEach((e, i, array) => {
        sortArray[i] = e["CLIP NAME"] + '\t' + e["START TIME"] + '\t' + e["END TIME"] + '\t' + e["DURATION"] + '\n';
    });

    sortArray.unshift("CLIP NAME" + '\t' + "START TIME" + '\t' + "END TIME" + '\t' + "DURATION" + '\n');
    sortArray.unshift(sessionNameHeading + '\t' + sessionName + '\n');

    sf.clipboard.setText({
       // path: outputPath,
        text: sortArray.join(''),
    })
}

convertTextFile(inputPath);
/////////////////////////////////////////////////////////

////////////////////////////// WAIT AND PASTE ON NEOOFFICE  /////////////////

sf.ui.app('org.neooffice.NeoOfficeSecureEdition').appActivate();

sf.app.launch({
    path: "/Applications/NeoOffice.app",
});
sf.ui.app('org.neooffice.NeoOfficeSecureEdition').menuClick({
    menuPath: ["File","New", "Spreadsheet"],
});
 sf.wait({
    intervalMs: 2000,
})
sf.ui.app('org.neooffice.NeoOfficeSecureEdition').menuClick({
    menuPath: ["Edit","Paste Special..."],
});
sf.ui.app('org.neooffice.NeoOfficeSecureEdition').windows.whoseTitle.is('Paste Special').first.elementWaitFor({
    waitType: "Appear",
    failIfNotFound: true,
    timeout: -1,     
});
sf.keyboard.press({
    keys: "down",
    fast: true,
});

sf.keyboard.press({
    keys: "tab",
    fast: true,
});

sf.keyboard.press({
    keys: "ctrl+o",
    fast: true,
});

sf.ui.app('org.neooffice.NeoOfficeSecureEdition').windows.whoseTitle.is('Text Import').first.elementWaitFor({
    waitType: "Appear",
});

sf.keyboard.press({
    keys: "tab",
    repetitions: 2,
    fast: true,
});

sf.keyboard.press({
    keys: "ctrl+o",
    fast: true,
});

sf.wait();




////////////////SAVE NEOOFFICE FILE////////



 sf.keyboard.press({
      keys: "cmd+s",
  });

sf.ui.app('org.neooffice.NeoOfficeSecureEdition').mainWindow.sheets.first.elementWaitFor({
    waitType: "Appear",
});

////Destination

///Set Destination Folder


//////Navigate to destination Folder
sf.keyboard.type({text: `/`,}); 

sf.keyboard.type({ text: folderPath });

 sf.wait({
    intervalMs: 1000,
})
sf.keyboard.press({ keys: 'enter' });


///////Name the file
sf.ui.app('org.neooffice.NeoOfficeSecureEdition').mainWindow.sheets.first.elementWaitFor({
    waitType: "Appear",
});

sf.keyboard.type({
    text: newname,
});

sf.ui.app('org.neooffice.NeoOfficeSecureEdition').mainWindow.sheets.first.buttons.whoseTitle.is('Save').first.elementClick();

////////////////////// close neoOffice, Pro Tools Session
sf.ui.app('org.neooffice.NeoOfficeSecureEdition').appActivate();

sf.ui.app('org.neooffice.NeoOfficeSecureEdition').menuClick({
    menuPath: ["File","Close"],
});

sf.ui.proTools.appActivate();

sf.ui.proTools.menuClick({
    menuPath: ["File","Save"],
});
sf.ui.proTools.menuClick({
    menuPath: ["File","Close Session"],
});

And here is a tool to write "MUSICLIST" on all selected tracks' comments. This is a separate tool only for the already existing sessions, all the new ones I'm already adding the keyword to the comments.

sf.ui.proTools.appActivateMainWindow();

// Make sure comments are visible
if (!sf.ui.proTools.getMenuItem("View","Edit Window Views","Comments").isMenuChecked) {
    sf.ui.proTools.menuClick({
    menuPath: ["View","Edit Window Views","Comments"],
});
}



function selectTracks(trackNames = []) {


    var allNames = sf.ui.proTools.selectedTrackNames;

    var namesToSelect = allNames.filter(n => trackNames);
    

    //Make sure the first track is in view
    var firstTrack = sf.ui.proTools.trackGetByName({ name: namesToSelect[0] }).track;
    firstTrack.trackScrollToView();

    //Now select all of them
    sf.ui.proTools.trackSelectByName({
        names: namesToSelect,
        deselectOthers: true,
    });
}

selectTracks()

var size = 'small';
var f = sf.ui.proTools.selectedTrack.frame;
var popupMenu = sf.ui.proTools.selectedTrack.popupMenuOpenFromElement({
    relativePosition: { x: f.w - 10, y: 5 },    
    isOption: true,
    isShift: true,
}).popupMenu;
popupMenu.menuClickPopupMenu({
    menuPath: [size]
});


   function setComment(trackHeader, text) {
       var commentsField = trackHeader.textFields.whoseTitle.startsWith('Comments').first;
       commentsField.mouseClickElement();
       sf.keyboard.press({ keys: 'cmd+a' });
       sf.keyboard.type({ text: "MUSICLIST" });
       sf.keyboard.press({ keys: 'return' });
   }

   function setCommentsToTrackNames() {
       var tracks = sf.ui.proTools.selectedTracks.trackHeaders;
       for (var i = 0; i < tracks.length; i++) {
           var track = tracks[i];
           setComment(track, track.normalizedTrackName);
       }
   }

   setCommentsToTrackNames();

Have fun!!