I cannot create a trigger in Google sheets because google cannot load the column header names. Can I hand-write in a column name instead? Clearly the connection magic is failing, but I know what column I want. This is a google sheet automation that worked until I went to edit the trigger to change the column of trigger. Once I did that it was now unable to see any columns in the sheet.
It is a Google DRive file. I have tried both (team drive) and not (team drive) variants.