Powerful Features:

1. Automated Attachment Downloader:

• • Description: Streamline the attachment downloading process by introducing a one-click button in Google Sheets. Users can input criteria such as email, from date, and to date in the Config sheet, and with a click of the button, the system will download all relevant attachments from Gmail to a designated Google Drive folder.

  • How it works: Users input the required parameters in the Config sheet and press the designated button. The system fetches emails meeting the specified criteria and downloads attachments to the specified Google Drive folder.

  • Benefits: Enhances user convenience by automating the attachment download process directly from Google Sheets.

2. Comprehensive Email Data Tracker:

• • Description: Capture and organize email details comprehensively in a separate sheet named Data. This feature not only records basic information like sender, date, subject, and body but also provides a link to open the Google Drive folder where the corresponding attachment resides.

  • How it works: The system automatically populates the Data sheet with relevant email details and includes a link to the Google Drive folder containing the associated attachment.

  • Benefits: Facilitates easy reference and retrieval of email-related information, creating a centralized data hub for better organization.

3. Dynamic Year-Based Folder Structure:

• • Description: Enhance folder organization by automatically creating subfolders within the targeted Google Drive folder based on the year of email receipt. This ensures a structured hierarchy for storing attachments, making it easy for users to locate files based on the year of correspondence.

  • How it works: When attachments are downloaded, the system checks the year of the email and creates a corresponding subfolder within the designated Google Drive folder.

  • Benefits: Improves the overall organization of attachments, making it intuitive for users to navigate and manage their files.

Easy to Use:

Just a few clicks, and you're on your way to a more streamlined email management process.

Benefits:

• Save hours of manual work each week

• Improve your productivity and efficiency

• Reduce errors and mistakes

• Free up your time to focus on more important things