I run a small dispatch office that pairs drone pilots with incoming client jobs, and I’m still juggling everything by hand. I need a clean Zapier flow that automatically pulls data from the two tools we already live in—Google Calendar (where each booked flight sits as an event) and Trello (where every assignment moves through our pipeline). The goal is simple: generate a concise report that lands in my inbox on a schedule I can tweak, summarising fresh client job requests, which pilot was assigned, and whether the task is complete. The report must capture three key data points for every job: • the client request as it arrives, • the pilot we dispatched, • the latest completion status. If you can also tap Stripe so the report shows whether payment has cleared for that job, that’s a bonus I’ll happily pay for. Here’s what I expect back: • A live Zap (or set of Zaps) that gathers the data, formats it neatly—Google Sheets, Airtable, or another lightweight store is fine—and sends a PDF or well-formatted email summary. • Clear, step-by-step documentation so I can adjust filters, date ranges, or recipients without calling you every time. • A brief hand-off session or loom video proving the automation fires correctly with sample data. You’re free to use any Zapier Formatter steps, webhooks, or code snippets required, as long as the flow stays inside the standard Zapier plan limits. If something needs an upgrade, flag it first. I’m ready to get this live quickly, so let me know your timeline and any questions you still have.