Search one level of Google Drive folders and extract creation, last updated and folder names into a Google Sheet.
The following Google Apps Script is designed to search through one level of Google Drive folders and extract the following information into a Google Sheet:
- The folder name as a direct clickable link,
- The folder creation date,
- The folder last updated date,
- The folder ID.
I use Google Apps Script to support staff and students in my job. I enjoy dabbling with creating tools to help with automation and I freely share my learning experiences on my blog: www.pbainbridge.co.uk