Overview
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, general notices, and contact information, creates calendar events when needed, saves text files in Drive, and sends you a daily reminder email about tomorrow’s important events. Email Auto-Triage and Organizat… Email Auto-Triage and Organization Hub Who this is for Parents or caregivers who get lots of school emails and want everything organized automatically Busy families who often forget dates, deadlines, or 持ち物 (things to bring) Anyone who wants school communication stored in a structured, searchable way in Drive and Calendar How it works Trigger: Gmail watch for new emails A Gmail Trigger node watches your inbox and starts the workflow whenever a new email arrives. It then loads the full message content (subject, body, metadata). Email Auto-Triage and Organizat… AI classification and extraction The email text is sent to an AI model, which returns a structured JSON object with: category: “Schedule”, “What to Bring”, “Notice”, or “Contacts” eventTitle, eventDescription, eventDate (ISO format) itemsToBring, contacts, subject, id, and hasAttachments This turns messy school emails into clean structured data. Email Auto-Triage and Organizat… Routing by category A Switch node routes each email based on its category and whether it has attachments: Schedule / What to Bring → create a calendar event and also save a notice file Notice → save a notice file only Any email with attachments → send to the attachment branch for optional photo storage Email Auto-Triage and Organizat… Save notices to Google Drive For all categorized emails, the workflow creates a text file in Google Drive containing: Title, date, category, items to bring, and a short description of the event or notice. Email Auto-Triage and Organizat… Create calendar events For “Schedule” and “What to Bring” emails, the workflow builds a summary and description (including 持ち物) and creates a Google Calendar event. If no end time is given, it defaults to one hour after the start. Email Auto-Triage and Organizat… Save photo attachments (optional) If the email has image attachments, the workflow: Downloads the attachments from Gmail Filters to only image files Saves the photos in a specified Google Drive folder, using the original file name Email Auto-Triage and Organizat… Extract and archive contact information The workflow also pulls out the sender’s contact info (From), links it to the email subject and timestamp, and saves it as a separate contact text file in Google Drive for easy reference. Email Auto-Triage and Organizat… Daily reminder for tomorrow’s events Every morning at a set time, a Schedule Trigger runs: It fetches all events from Google Calendar for “tomorrow” Filters down to events whose description includes “持ち物” Sends you an email summarizing tomorrow’s events and what you need to bring, so you can prepare in advance. Email Auto-Triage and Organizat… How to set up Connect your Gmail, Google Calendar, and Google Drive credentials in the respective nodes. In the Workflow Configuration node, set: photosFolderId – Drive folder for saved photos noticesFolderId – Drive folder for notice text files contactsFolderId – Drive folder for contact text files reminderEmail – email address that will receive the daily reminder Make sure the Gmail Trigger is pointing to the correct mailbox and is set to poll as often as you like. Confirm that the Google Calendar node uses the calendar where you want school events to appear. Turn the workflow on and test it with a few real school emails (schedules, what to bring, general notices). Email Auto-Triage and Organizat… Customization ideas Adjust the AI prompt in Extract Email Info to better match your school’s typical email style or to add more categories. Change the logic for calendar events (all-day events, different default times, or additional fields like location). Modify file naming patterns or folder structure in Google Drive (e.g., separate folders per child, per school year, or per class). Add logging to Google Sheets for a timeline view of all school communication. Forward or mirror important events/notices to other tools such as Slack, Notion, or a family LINE group. An n8n automation workflow template by SOLOVIEVA ANNA.
SOLOVIEVA ANNA
web
free
Others in the same category, ranked by how often they are opened.
