Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Files & Cloud Storage

Files & Cloud Storage

File Email Attachments into Drive Folders by Company

When a new Gmail message from a whitelisted contact arrives, attachments are saved into company and month folders on Google Drive, with a log in Google Sheets.

Import it free Sign in to open it

What it does

# 2. Google Sheets Whitelist Config ## To filter contacts against a whitelist: ### 1. Make a copy of this spreadsheet OR create a Google Sheet with two columns: | email | company | ### 2. Add whitelisted emails and their company as rows in the sheet and configure this node Document and Sheet to point to it.

The steps

  1. Search For Folder
  2. Create Month Folder
  3. Check If Folder Exists
  4. Gmail Trigger
  5. Gmail
  6. Split Up Binary Data1
  7. YYYY/MM
  8. Loop Over Items
  9. Company Folder Exists
  10. Create Company Folder
  11. Lookup in Sheets
  12. Search Company Folder1
  13. Upload To Folder

Similar automations

Files & Cloud StorageSave Gmail Invoice Attachments into Monthly Google Drive Folders20 stepsFiles & Cloud StorageSave Gmail PDF Attachments into New Google Drive Folders7 stepsFiles & Cloud StorageBack Up Gmail Attachments to Google Drive5 stepsFiles & Cloud StorageSave LINE Files to Google Drive and Log URLs in Sheets23 steps