Get Daily Email Reports of your Google Drive Activity

The Google Drive website includes an Activity Stream to help you monitor changes to the various files and folders contained in your Drive. Whether you upload a file, move a file from one folder to another or change the sharing permissions, your actions will get logged. This is especially useful for users who have shared files in their Drive that can be edited by external users.

Google Drive Activity

The Activity Stream is however not available inside mobile apps and you’d have to log into the Google Drive website website daily to see what files and folders have changed recently.

Know What’s Changed in your Google Drive

There’s however a simple workaround. Instead of checking the activity stream manually, you can configure a Google Sheet and it’ll send you a daily email report (screenshot) of all the files in your Drive that have been created or modified in the past 24 hours. And it just takes 30 seconds to set up the monitoring.

  1. Click here to make a copy of the Drive Monitor in your Google Drive.
  2. Put your email address in the cell E1 highlighted in Yellow. This is where the daily email reports will arrive.
  3. From the file menu, choose Spreadsheet settings and choose your default Time zone. The modification time in the report will use this time zone.
  4. Go to the Google Drive Report menu in the sheet (see screenshot below) and choose Authorize. Allow the script access to your Drive - it needs to do this to know what has changed.
  5. Go to the Report menu again and choose Schedule reports. The script is now running in the background and it will email you the Drive report every 24 hours. You’ll get the first report immediately.

Related: Who can see my Google Drive files?

That’s it. Close the Google Sheet and it will monitor the file changes in the background, running once every 24 hours. If you would like to stop the daily email notifications, open the same sheet and choose Uninstall from the menu. Internally, a little Google Script is doing all the magic!

Google Drive Monitor

Amit Agarwal

Amit Agarwal

Google Developer Expert, Google Cloud Champion

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India.

Amit has developed several popular Google add-ons including Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

0

Awards & Titles

Digital Inspiration has won several awards since it's launch in 2004.

Google Developer Expert

Google Developer Expert

Google awarded us the Google Developer Expert award recogizing our work in Google Workspace.

ProductHunt Golden Kitty

ProductHunt Golden Kitty

Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards in 2017.

Microsoft MVP Alumni

Microsoft MVP Alumni

Microsoft awarded us the Most Valuable Professional (MVP) title for 5 years in a row.

Google Cloud Champion

Google Cloud Champion

Google awarded us the Champion Innovator title recognizing our technical skill and expertise.

Email Newsletter

Sign up for our email newsletter to stay up to date.

We will never send any spam emails. Promise.