Copy and paste from google sheets?

Thanks, @Dane_Butler!

I now understand we were working in slightly different modalities. I was assuming the first row of a CSV would be a row of "column name headers," - so when I was referring to "Column Name," I was referring to the name of that header in Row 1 ("Name," "Scene," etc.). However, I think you thought it was referring to the column's letter, which ALSO makes a lot of sense.

Anyway, here's a new version of the script to try out. I'll also shoot you a quick email reply with a little demo video of how it is working on my system.

/* DEFINE VARIABLES */
const filePath = sf.interaction.selectFile({ prompt: "Select a CSV File" }).path;
const targetColumn = sf.interaction.popupText({ title: "What Column?" }).text.toUpperCase();
const appendIndex = true;
const nameClipOnly = true; 

let lookUp = {
    "A": 0,
    "B": 1,
    "C": 2,
    "D": 3,
    "E": 4,
    "F": 5,
    "G": 6,
    "H": 7,
    "I": 8,
    "J": 9,
    "K": 10,
    "L": 11,
    "M": 12,
    "N": 13,
    "O": 14,
    "P": 15,
    "Q": 16,
    "R": 17,
    "S": 18,
    "T": 19,
    "U": 20,
    "V": 21,
    "W": 22,
    "X": 23,
    "Y": 24,
    "Z": 25,
}

/* THE CODE */

// Rename Clips
// Define Source Array and whether to append index number 
// Append Index can help remove possibility of duplicate names. 
function renameClips(source, appendIndex) {
    //Make sure we have no search in Clips list - if we had, Clip Rename won't work (Pro Tools bug)
    sf.keyboard.press({ keys: 'cmd+shift+d' });

    //Open Rename window
    sf.ui.proTools.menuClick({ menuPath: ['Clip', 'Rename...'] });

    //Reference for Rename Window
    const win = sf.ui.proTools.windows.whoseTitle.is('Name');

    //Wait for rename Window
    win.first.elementWaitFor();

    //Set the clip name to Track name
    win.first.groups.first.textFields.first.elementSetTextFieldWithAreaValue({
        value: appendIndex ? `${i}_` + source[i] : source[i],
    });

    if(nameClipOnly && sf.ui.proTools.windows.whoseTitle.is("Name").first.groups.whoseTitle.is("Name").first.radioButtons.whoseTitle.is("name clip only").first.exists){
        sf.ui.proTools.windows.whoseTitle.is("Name").first.groups.whoseTitle.is("Name").first.radioButtons.whoseTitle.is("name clip only").first.elementClick();
    }

    // Click OK
    sf.ui.proTools.windows.whoseTitle.is("Name").first.buttons.whoseTitle.is("OK").first.elementClick();

    // Wait for Window to leave
    sf.ui.proTools.windows.whoseTitle.is("Name").first.elementWaitFor({ waitType: "Disappear" });

}

//Convert CSV to Text
let csvAsText = sf.file.readText({ path: filePath }).text

// Extract each rows
let rows = csvAsText.split(/(?:\r\n|\n)+/).filter(function (el) { return el.length != 0 });

// Extract the headers 
// let headers = rows.splice(0, 1)[0].split(",");

// Complex gobbledegook to filter the CSV 
let valuesRegExp = /(?:\"([^\"]*(?:\"\"[^\"]*)*)\")|([^\",]+)/g;

// Create an array to hold our rows with key value pairs
let cells = [];

// Add our row objects to the array with keys
for (let i = 0; i < rows.length; i++) {
    let element = {};
    let j = 0;

    var matches;
    while (matches = valuesRegExp.exec(rows[i])) {
        var value = matches[1] || matches[2];
        value = value.replace(/\"\"/g, "\"");

        if (j == lookUp[targetColumn]) {
            element[lookUp[targetColumn]] = value;
        }
        j++;
    }

    cells.push(element);
}

// Let's narrow our focus to one column
let filteredColumn = cells.filter(x => x[lookUp[targetColumn]]);

// Let's get just the content in the cells of this column
let filteredColumnContents = filteredColumn.map(x => x[lookUp[targetColumn]]);

sf.ui.proTools.appActivateMainWindow();
sf.ui.proTools.mainWindow.invalidate();

let i = 0;

// Do for each selected clip
while (i < filteredColumnContents.length) {
    // Rename our Clips
    renameClips(filteredColumnContents, appendIndex)

    // Go to Next Clip
    sf.keyboard.press({ keys: "control+tab" });

    // Increment i
    i++;
}