ROW1 — FIND MY FLIGHTS WITH MY AI ASSISTANT ================================================================= Don't use Flighty or TripIt? If your AI assistant (Claude, ChatGPT, or Gemini) can read your email, it can reconstruct your entire flight history for you and build a file you can import into Row1. Three steps: (1) connect your email to your AI, (2) give it the prompt below, (3) email the result to flights@row1.app. ----------------------------------------------------------------- STEP 1 — CONNECT YOUR EMAIL TO YOUR AI ASSISTANT ----------------------------------------------------------------- Your assistant needs permission to read your inbox. If you've already connected it, skip ahead. • Claude (claude.ai): Settings -> Connectors -> connect Google/Gmail. (Or use the Claude for Chrome extension while you're in Gmail.) • ChatGPT (Plus/Pro): Settings -> Connectors (Apps) -> connect Gmail or Outlook, then enable it for the chat. • Gemini: it's already on your Google account — just mention "@Gmail" or enable the Google Workspace / Gmail extension. No way to connect email? You can still forward individual confirmation emails to flights@row1.app — see row1.app/import. ----------------------------------------------------------------- STEP 2 — GIVE YOUR AI THIS PROMPT ----------------------------------------------------------------- Upload this whole file to your assistant and say "do this," OR copy everything between the lines below into the chat. ================ COPY FROM HERE ================ You are helping me rebuild my personal flight history from my email inbox. Search my email for airline and travel-booking confirmations, extract every flight segment you can find, and output a single CSV that I can import into the Row1 app. Search as far back as my mailbox allows. WHERE TO LOOK — match the sender domain OR any subdomain of it (e.g. "no-reply@e.delta.com" matches delta.com). Airline confirmation senders: US Majors: t.delta.com, delta.com, united.com, aa.com, americanairlines.com, southwest.com, alaskaair.com, jetblue.com, spirit.com, frontier.com, hawaiianairlines.com, suncountry.com, allegiantair.com, flybreeze.com, aveloair.com Canada: aircanada.com, westjet.com, flyporter.com, airtransat.com, lynxair.com, flyflair.com Europe: britishairways.com, email.britishairways.com, lufthansa.com, airfrance.com, klm.com, iberia.com, swiss.com, austrian.com, brusselsairlines.com, flytap.com, ita-airways.com, itaairways.com, flysas.com, finnair.com, thy.com, turkishairlines.com, lot.com, aerlingus.com, icelandair.com, norwegian.com, virginatlantic.com, ryanair.com, easyjet.com, wizzair.com, vueling.com, eurowings.com, airserbia.com, croatiaairlines.com, tarom.ro, airbaltic.com, playairlines.com Middle East: emirates.com, email.emirates.com, qatarairways.com, etihad.com, etihadairways.com, saudia.com, gulfair.com, omanair.com, rj.com, mea.com.lb, flydubai.com, airarabia.com, kuwaitairways.com Asia-Pacific: singaporeair.com, cathaypacific.com, qantas.com, qantas.com.au, virginaustralia.com, ana.co.jp, jal.co.jp, skymark.co.jp, koreanair.com, flyasiana.com, jinair.com, twayair.com, jejuair.net, china-airlines.com, evaair.com, starlux-airlines.com, malaysiaairlines.com, thaiairways.com, bangkokair.com, garuda-indonesia.com, vietnamairlines.com, airindia.com, airindia.in, vistara.com, goindigo.in, spicejet.com, akasaair.com, philippineairlines.com, cebupacificair.com, airnewzealand.co.nz, airasia.com, flyscoot.com, jetstar.com, csair.com, ceair.com, airchina.com, hainanairlines.com, xiamenair.com, shenzhenair.com, srilankan.com, batikair.com Latin America: latam.com, latamairlines.com, aeromexico.com, avianca.com, copaair.com, voeazul.com.br, voegol.com.br, volaris.com, vivaaerobus.com, aerolineas.com.ar, jetsmart.com, skyairline.com Africa: ethiopianairlines.com, flysaa.com, kenya-airways.com, egyptair.com, royalairmaroc.com, airmauritius.com, rwandair.com, flyairlink.com Travel booking / OTA platforms (only count an email if its subject or body clearly refers to a flight, itinerary, e-ticket, booking, or PNR — these senders also send hotels and cars, which you should ignore): expedia.com, expediagroup.com, travelocity.com, orbitz.com, cheaptickets.com, ebookers.com, hotwire.com, booking.com, bookingemail.com, priceline.com, agoda.com, trip.com, tripadvisor.com, kayak.com, kiwi.com, skyscanner.net, gotogate.com, mytrip.com, edreams.com, opodo.com, travelgenio.com, travelup.com, studentuniverse.com, hopper.com, tripactions.com, navan.com, travelperk.com, concur.com, ctrip.com Also try these searches in case a confirmation came from another sender: "flight confirmation", "e-ticket", "itinerary", "boarding pass", "booking confirmation", "your trip", "record locator", "PNR". OUTPUT — for EACH flight segment, write one CSV row with EXACTLY these columns, in this order (include the header row first): Date,Airline,Flight,From,To,Canceled,Seat,Aircraft,DepartureTime,ArrivalTime,DepartureTimeActual,ArrivalTimeActual,CreatedDate Column rules: • Date — departure date as YYYY-MM-DD. • Airline — the airline's full name (e.g. "Delta Air Lines", "United Airlines", "British Airways"). • Flight — airline code + number, no space (e.g. DL123, UA456, BA2490). • From / To — 3-letter IATA airport codes (ATL, LAX, LHR). ONE segment per row: split connections and round trips into separate rows. • Canceled — true or false. Use true only if the email says it was canceled. • Seat — seat number if shown (e.g. 12A), else leave blank. • Aircraft — aircraft type if shown (e.g. "Boeing 737-900"), else blank. • DepartureTime / ArrivalTime — scheduled times in ISO 8601 WITH timezone offset, e.g. 2024-01-15T08:30:00-05:00. If you only know the date, put the date with no time. Use each airport's local time. • DepartureTimeActual / ArrivalTimeActual — leave blank. • CreatedDate — leave blank. Important: • One row per flight segment. A round trip with one connection each way = 4 rows. • De-duplicate: the same segment often appears in several emails (booking, reminder, check-in, boarding pass) — include it only ONCE. • Ignore hotels, car rentals, trains, seat upgrades, and marketing emails. • If a value contains a comma, wrap that value in double quotes. • Output ONLY the CSV — the header row plus one row per flight. No commentary, no explanations, no markdown code fences. If you find no flights, tell me. When you're done, give me the CSV as a downloadable .csv file (or in a single code block I can copy) so I can save it. ================ COPY TO HERE ================ ----------------------------------------------------------------- STEP 3 — SEND IT TO ROW1 ----------------------------------------------------------------- Save your assistant's output as a file (e.g. my-flights.csv) and email it as an ATTACHMENT, from the email address on your Row1 account, to: flights@row1.app Row1 will import your flights, award XP and badges, and silently skip any duplicates of flights you've already added. You can re-run this anytime to pull in new trips. Covers 155 airline & booking sender domains. · row1.app