What This Automation Does:
ā
Auto-Trigger: Monitors inbound supplier emails via Gmail instantly
ā
Smart Extraction: Uses Gemini Vision/OCR to parse complex data (Dimensional Reports, Balloon Drawings, Material Certs, PSW)
ā
AI Validation: Custom JavaScript logic verifies spec tolerances & flags non-conforming parts automatically
ā
Centralized Storage: Conforming data ā PostgreSQL + Google Drive + Airtable
ā
Real-Time Alerts: Non-conforming submissions trigger instant email alerts to the Quality Engineering team