Bibliothek / Dateien & Cloud-Speicher
Dateien & Cloud-Speicher
Neue Gmail-Nachrichten anhand einer Whitelist in Google Sheets filtern und in Drive speichern
Prüft jede neue Gmail-Nachricht anhand einer in Google Sheets geführten Whitelist mit Kontakten, speichert passende Einträge in Google Drive und protokolliert sie im Sheet.
Was sie bewirkt
# 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.
Die Schritte
- Search For Folder
- Create Month Folder
- Check If Folder Exists
- Gmail Trigger
- Gmail
- Split Up Binary Data1
- YYYY/MM
- Loop Over Items
- Company Folder Exists
- Create Company Folder
- Lookup in Sheets
- Search Company Folder1
- Upload To Folder
- Error Handler
Ähnliche Automatisierungen
Dateien & Cloud-SpeicherSave, extract, and log email invoices with Gmail, Drive, Sheets, Claude, and PDF.co29 SchritteDateien & Cloud-SpeicherReconcile and approve CSV imports with Google Sheets, Drive, and Gmail45 SchritteDateien & Cloud-SpeicherRun a Gemini Live voice support assistant with Google Drive and Sheets35 SchritteDateien & Cloud-SpeicherPassende Gmail-PDF-Anhänge mit OpenAI in Drive speichern16 Schritte