Email triage system that watches Gmail, extracts message text, summarizes it, classifies by keyword, and logs each message to emergency, volunteer, donation, or uncategorized Google Sheets tabs, with error-tab logging and emergency alerts enabled.
Make · workflow canvasproduction build
Context
Marine and operations teams needed to quickly sort incoming email into actionable emergency, volunteer, or donation cases versus uncategorized traffic without manual reading and tagging.
Approach
Built a single Make.com scenario that watches Gmail, extracts and summarizes the message body, categorizes it by keyword into emergency, volunteer, donation, or uncategorized, logs each to its own Google Sheet, sends an emergency alert when needed, and pairs every branch with an error‑entry write to a shared error tab.
Architecture
Gmail - Watch Incoming Emails
Build Scanned Text
Build Message Summary (150 chars)
Categorize by Keywords
Emergency: Log to Sheet - Emergency + Send Emergency Alert
