Parse flight and hotel confirmation emails into structured itinerary data

Steps

1. Set up an email ingestion pipeline using IMAP, a dedicated forwarding address, or a Gmail/Outlook API integration to receive forwarded confirmation emails from travelers.
2. Apply an LLM or trained extraction model to each email body to extract structured fields: confirmation number, carrier/supplier name, origin, destination, departure datetime, arrival datetime, passenger name, and booking status.
3. Normalize extracted datetimes to UTC and validate them against each other (e.g., departure must precede arrival); flag low-confidence extractions for human review.
4. Deduplicate by matching confirmation numbers against existing itinerary records; update existing segments rather than creating duplicates when re-confirmations arrive.
5. Enrich the parsed segments with IATA codes and timezone data from a reference dataset to ensure consistency across bookings parsed from different email formats.
6. Store the raw email alongside the parsed data for audit; extracted itinerary items should link back to their source email for dispute resolution.