Weekday Outlook meeting prep brief with HubSpot context

Build me a weekday morning meeting prep brief that runs on a cron schedule, every Monday through Friday at 7:30am in my local time zone.

Step 1: Pull the next 24 hours of meetings from Microsoft Outlook using List Calendar View (not List Events) so recurring series are expanded into actual instances. Use my primary calendar.

Step 2: For each event, identify external attendees by comparing each attendee's email domain against my internal domain (or domains) which I will configure at setup. Skip meetings that have no external attendees, and skip 1:1s where the single external attendee has no HubSpot match.

Step 3: For every external attendee, look them up in HubSpot using Get Contact with idProperty=email. If Get Contact misses, fall back to Search Contacts by email. From the contact, pull associated company (Get Company), open deals (Get Deal or List Deals filtered by association), and the three most recent notes (List Notes filtered to that contact). Capture company name, contact title, last activity date, deal name, deal stage, deal amount, and a short snippet from the most recent note.

Step 4: Draft a single prep brief covering every qualifying meeting in chronological order. For each meeting include: time and title, attendees with roles and companies, deal stage and amount where applicable, recent context (last touch and most relevant note), three suggested talking points tailored to the deal stage and recent activity, and any open tasks or action items I owe them. Keep it skimmable. Bullets, not paragraphs. Bold the meeting titles.

Step 5: Deliver the brief via Microsoft Outlook Send Mail to my own email address with the subject "Meeting prep · {today's date}". If I prefer to review before sending, use Create Draft Message instead so it lands in my Drafts folder.

Skip the entire run gracefully if there are no qualifying meetings (don't email me an empty brief). Log which meetings were skipped and why, so I can audit the filter rules.