I scraped data through Python and add the raw data as sheets in a worksheet in Google sheets every time I run the script. I want to automatically add a new column where I do a function on the raw data on a main sheet everytime a new sheet is added to the worksheet.
So is there a way to make a function that notices if a new sheet is made it then adds a column in the main worksheet?