Google Apps Script For Sheets - How to Copy, Clean and Insert Data in Sheets

[@febydysfa8693]

good job dude, thank you

[@98cactus]

great video! can you dive a little deeper into how can we can create a script that copies only the last row from a given sheet (general sheet) and then filter it for it to land into an specific sheet depending on a specific value and date? is that even posible?

[@analyticswithadam]

Use the values of the last row as a filter? It is possible

[@GoogleDrivesAdmin]

I have a spreadsheet being created on a daily basis and I have automated the upload of this data into a specific folder in my drive account. The filename of the sheet is dynamic because it contains the created date in a YYYY-MM-DD. I have been able to create a function to build the filename and find the sheetId. What I am having difficulty doing is using the last section of your script to pull the sheetId into the new function, so that I can get the data into the new sheet. Is there an easy way to get the sheetId from the one function and use it in the next function.

[@analyticswithadam]

Each sheet can be reference by sheet number. Const Sheet = ss.getSheets()[0]; reffers to the first sheets in the Spreadsheet you should be able to reference the sheet from its position.