I'm going to admit I'm a newbie at scripting. I've managed to write the script that I want but I want it to automatically run after importing the CSV file onto Google Sheets.
I have tried a simple trigger of onEdit(e) when combining it with "Replace current sheet" when importing but this doesn't work. It is only triggered when I edit the cell even though the full sheet has been edited. I've tried appending and replace data at selected cell but it's not doing what I want.
Is there another way to achieve this?
For context the current script I have built deletes columns with a specific header.
I was thinking about using a script that would automatically run after detecting a specific string but I haven't found anything online to suggest I can do this.
Any help would be greatly appreciated :)