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
- Receive & Persist: Receives email --> Postmark --> Hookdeck --> Xano, save Hookdeck event + inbound-email record in Xano
- Upload Attachments: DB triggers upload email attachments to GCS
- AI Parsing: Invoke Vertex AI (Gemini) to extract data from email content and attachment
- 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