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

Filter new Gmail messages against a Google Sheets whitelist and save to Drive

Checks each new Gmail message against a whitelist of contacts kept in Google Sheets, then saves matching items to Google Drive and logs them to the sheet.

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]({{ $env.WEBHOOK_URL }} 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
  14. Error Handler

Similar automations

Email AutomationFilter Spam and Marketing Gmail with Gemini17 stepsWeb Scraping & ResearchRead a Sitemap and Filter URLs12 stepsWeb Scraping & ResearchRead a Sitemap and Filter URLs6 stepsTasks & Project ManagementFilter Open Notion Tasks and Send Them to Slack on a Schedule12 steps