Uploaded June 2025 | Updated September 2026, 1 week ago

---

In this video, we're doing to walk through how to streamline getting data from Google Sheets files in a Google Drive folder into your main Google Sheets, including archiving or deleting the processed files and how to add a trigger to make the script run automatically.

You can download the final Google Sheet and Apps Script here: bit.ly/3SsY8AE

0:00 1. Intro
0:44 2. Creating the Main Google Apps Script
7:00 3. Running Our First Version
8:30 4. Adding a toast notification
10:06 5. Deleting/Archiving the Files
12:05 6. Adding a sort function to the script
12:57 7. Routing Files to Different Tabs
15:59 8. Adding a Daily Trigger
16:44 9. Conclusion