Organize school emails with AI, Google Calendar and Drive auto-triage system
Ready for 3.0What this workflow does
This AI workflow has 19 nodes and runs on Gmail events (plus 1 other trigger). Along the way it connects Google Calendar, Gmail, Google Drive and OpenAI Chat Model.
How it runs
Trigger: On Gmail events (plus 1 other trigger).
- Get a message (Gmail): get
- Get Tomorrow's Events (Google Calendar): get many
- Workflow Configuration (Edit Fields (Set)): sets 4 fields: photosFolderId, noticesFolderId, contactsFolderId…
- Filter: keeps only the items that match a condition
- Extract Email Info (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Chat Model
- Send Reminder Email (Gmail): uses Gmail
- Route by Category (Switch): routes items into 3 branches
- Get Email Attachments (Gmail): get
- Extract Contacts (Edit Fields (Set)): sets 3 fields: contactInfo, emailSubject, extractedDate
- Save Notice to Drive (Google Drive): create from text
…plus 6 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
- Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (When Email Arrives).
Nodes used (10)
- Switch
n8n-nodes-base.switch - Edit Fields (Set)
n8n-nodes-base.set - Google Calendar
n8n-nodes-base.googleCalendar - Gmail
n8n-nodes-base.gmail - Filter
n8n-nodes-base.filter - Google Drive
n8n-nodes-base.googleDrive - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Gmail Trigger
n8n-nodes-base.gmailTrigger - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
Overview This workflow automatically reads school-related emails from Gmail, uses AI to understand what each email is about, and then organizes everything into Google Drive and Google Calendar. It classifies messages into schedules, “what to bring” lists,…