Script in Google Sheet to automatically run after importing CSV files to replace current sheet

Question

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 :)

Answer 1

The simple trigger onEdit only works when a user manually edit one or more cells, more specifically when the user:

• Type directly on a cell
• Type directly on the formula bar
• Paste over one or more cells (the paste action should modify the cells, pasting an image over the grid will not make the onEdit function to be executed)
• Paste over the formula bar

Try using the installable trigger change for spreadsheets. For details on how triggers works, the differences between simple and installable triggers, how to create installable triggers and the Google Apps Script event objects please read https://developers.google.com/apps-script/guides/triggers, https://developers.google.com/apps-script/guides/triggers/installable and https://developers.google.com/apps-script/guides/triggers/events

NOTE: A change installable trigger listen to changes to the associated spreadsheet, so you might need to make use of JavaScript control statements like if or switch.

Related

• How do you create an installable trigger for a Google Apps Script?
• Diference between onEdit or onChange trigger?
• Run a Script When Tab Programmatically added to a Google Spreadsheet