Auto Refresh your File/Folder list
Drive Explorer Google Add-on
This guide is for the official Drive Explorer add-on. Install it to list, export, and audit Google Drive files and folders directly in your spreadsheet or browser.
You need to enable a config to auto refresh the list in your Google Sheet™ whenever you open it. Select Extensions → Drive Explorer → Configuration, check "Autorefresh on open" and click on Save. You may also want to check Scheduled refresh.
If you constantly update the files/folders in the folders you have picked for listing in the sheet, you will find this config much useful. You can also manually update the list by selecting Extensions → Drive Explorer → Refresh.
Ready to list and audit Google Drive?
Install Drive Explorer from the Google Workspace Marketplace today and start exporting file metadata, folder sizes, and sharing permissions directly inside Google Sheets or on your browser.