Building Secure Email Parsing Flow
Worked on a project where security and observability were critical. The goal was to ingest emails from multiple vendors and transform them into a single, unified maintenance-ticket format. Tools Postmark: Stream inbound emails to a webhook Hookdeck: Reliable webhook solution that handles retries, request logging, and data transformation Google Cloud Storage: Secure storage solution Google Cloud Vertex AI: Security-compliant enterprise AI solution Auth & Verification - Postmark→Hookdeck: Basic Auth - Hookdeck→Xano: SHA-256 HMAC header to verify payload integrity - Xano email whitelist to reject unapproved senders - Caches and refreshes Google Cloud token every hour in Xano Data Flow 1. Receive & Persist: Receives email --> Postmark --> Hookdeck --> Xano, save Hookdeck event + inbound-email record in Xano 2. Upload Attachments: DB triggers upload email attachments to GCS 3. AI Parsing: Invoke Vertex AI (Gemini) to extract data from email content and attachment 4. Ticket Creation: Save “maintenance ticket” in Xano using the structured JSON output from Gemini Result A secure end-to-end pipeline that processes vendor emails into standardized maintenance tickets. Feel free to reach out if you're looking to build secure AI solutions that can transform your workflow https://www.onedev.cc/