Simple Gmail Audit with Google Sheets: Code Walkthrough Copy The Sheet: https://docs.google.com/spreadsheets/d/1HUS8Nd7sRfam-zQEVz-AS88atfx7KplwfL50Q7eCuQY/copy In this video, learn how to conduct a basic Gmail audit using a simple Google Sheets and Apps Script. The tutorial includes a walkthrough of the code, which you can find in the description. You will see how to set the number of days to go back, count the total number of emails, unread emails, and emails with specific subject characteristics such as all-capital words or specific keywords. Additionally, you will see how to reset the audit, generate summary sheets, and analyze the data gathered. The video also shows you how to handle errors and check the execution status in Apps Script. Follow the steps to run your own Gmail audit, customize it for your needs, and gain insights into your email patterns. 00:00 Introduction to Gmail Audit 00:09 Overview of Gmail Audit Features 00:42 Exploring Better Sheets 00:55 Setting Up the Gmail Audit Script 01:34 Running the Gmail Audit 01:59 Analyzing the Script Functions 03:10 Customizing the Audit Parameters 03:57 Executing and Reviewing the Audit 04:35 Conclusion and Next Steps