Skip to content

README.md

Latest commit

 

History

History
32 lines (19 loc) · 1.56 KB

README.md

File metadata and controls

32 lines (19 loc) · 1.56 KB

Gmail to Google Sheet Downloader

Overview

The emailToSheet function downloads new Gmails with a matching label to a Google Sheet. Each email's details, including sender, subject, and body, are saved to the sheet. Additionally, if an email contains attachments, their links are saved in a new column.

Based on script from this forum post: https://www.googlecloudcommunity.com/gc/Tips-Tricks/APPS-SCRIPT-Download-Gmails-to-GSheet-using-Gmail-Filters-Labels/m-p/362574

Usage

To use the function:

  1. Create Filter Rule in Gmail: Set up a filter rule in Gmail to apply a custom named label to emails you want to download.

  2. Modify Script Parameters:

    • Replace 'YOUR_CUSTOM_LABEL' with the name of the custom label applied to matching emails.
    • Replace 'GSHEET_ID' with the ID from the Google Sheet URL where you want to save the emails.

  3. Run Script and Authorize: Save the script and click run. Follow the authorization prompts to grant necessary permissions.

  4. Install Timed Trigger (Optional): Optionally, install a timed trigger for the script to automate the download process at regular intervals.

Behavior

  • Matching emails are downloaded to the Google Sheet.
  • The custom label is removed from the downloaded emails.
  • Emails are moved to the archive and marked as read.
  • Optionally, emails can be moved to a new label after download by uncommenting and configuring the moveToLabel variable.

Attachments

Attachments are saved to the same folder as the Google Sheet in a subfolder named with the timestamp and subject of the email.