Every Google Drive File Created in Last 24 Hours in Google Sheets
How to Track Newly Created and Modified Files in Google Drive
In this video, we demonstrate how to use Google Apps Script to track every new and modified file in Google Drive over the last 24 hours. We explain how to create Google Sheets to store these reports and modify the original script from Digital Inspiration to suit our needs. Additionally, we show how to automate these reports to run daily and how to set up a custom menu for easier access. The script modifications and process enable efficient file management and time tracking.
00:00 Introduction to Google Drive File Tracking
00:04 Setting Up the Initial Script
00:49 Understanding the Original Function
01:45 Modifying the Script for Created Files
04:55 Creating a Custom Menu
06:43 Automating the Report Generation
09:21 Testing and Troubleshooting
10:12 Conclusion and Additional Resources
