Run the weekly pipeline review and flag every deal at risk

<context>
I want to run a weekly pipeline review before my team standup. I need to know which deals have a risk signal worth flagging: not from CRM health scores, but from what's actually happening at the prospect accounts right now.

My pipeline:
- Deal list: [PASTE DEAL NAME, COMPANY, STAGE, ACV, OWNER, one per line OR "pull from my calendar"]
- Team size: [NUMBER OF REPS]
- Focus: [ALL DEALS / CLOSE THIS QUARTER / SPECIFIC STAGE]
- What I want to flag: [ALL RISKS / STUCK DEALS / MISSING MEETINGS / STRUCTURAL CHANGES]
</context>

<task>
1. For each deal in the list, use Lusha to scan the prospect account for structural changes in the last 30 days:
   - Executive departure or new hire in the buying function (CFO, CTO, CRO, VP of the relevant department)
   - M&A activity where the prospect is the acquired party
   - Significant headcount contraction in the team being sold into
   - Any signal that typically re-routes or freezes vendor decisions

2. For each deal, check Google Calendar for meeting activity:
   - When was the last meeting with this account?
   - Is there a next meeting scheduled?
   - Flag any deal where the last meeting was more than 21 days ago with nothing on the calendar. That's a stuck deal.

3. Rate each deal on two axes:

   ACCOUNT RISK (from Lusha signals):
   - RED: structural change that directly threatens the deal
   - AMBER: signal worth watching but not immediately threatening
   - GREEN: no structural signals detected

   ENGAGEMENT RISK (from Calendar):
   - RED: no meeting in 21+ days, nothing scheduled
   - AMBER: last meeting 11-20 days ago, next meeting not confirmed
   - GREEN: active meeting cadence, next meeting on the calendar

4. Return a pipeline health report:
   - Summary line: X deals reviewed, X RED, X AMBER, X GREEN
   - RED deals first: account risk, engagement risk, and one recommended action for each
   - AMBER deals: flagged with the specific signal or gap
   - GREEN deals: listed only, no detail needed
   - One question to ask each RED deal owner in the standup

5. Flag any deal where both account risk and engagement risk are RED. These are the deals most likely to slip the quarter.
</task>

<constraints>
- Flag only signals Lusha actually returns. Don't infer risk from deal age or rep tenure.
- The standup question for each RED deal must be specific to the risk. Not "how's this deal going?" but "who's your relationship with now that Marcus left?"
- Keep the report to one screen. This is a standup tool, not a board deck.
- If a deal has no Lusha signal and an active meeting cadence, it's GREEN. Don't manufacture risk.
</constraints>

The situation: A sales manager at a B2B SaaS company runs the prompt Monday morning before a 9am standup. Eight deals in the pipeline, close this quarter focus, five reps on the team.

Output: 2 RED deals, 3 AMBER, 3 GREEN. One deal is double-RED. Standup runs in 12 minutes with specific questions per rep.

Pipeline health report — Week of May 19

8 deals reviewed · 2 RED · 3 AMBER · 3 GREEN

Run: Monday May 19, 7:58am. Signals via Lusha. Meeting cadence via Google Calendar.

RED DEALS — act before standup

Meridian Logistics · $148K · Negotiation · Owner: Sarah K.

• Account risk: 🔴 RED — CFO departed 18 days ago. Finance owns sign-off on contracts above $100K at this account. No replacement confirmed in Lusha.
• Engagement risk: 🔴 RED — Last meeting 26 days ago. Nothing on calendar.
• ⚠ Double RED — highest slip risk this week
• Recommended action: Sarah needs to get back in front of someone in Finance this week — either the interim owner or a direct ask to the CRO about who’s signing.
• Standup question for Sarah: “Who’s your current relationship with on the finance side at Meridian — and have you spoken to anyone there since the CFO left?”

Cartway Technologies · $92K · Proposal · Owner: James R.

• Account risk: 🔴 RED — Acquired by a larger competitor 12 days ago as the target entity. Contracts at acquired companies typically go under review during integration.
• Engagement risk: 🟡 AMBER — Last meeting 14 days ago. Next call not confirmed.
• Recommended action: James needs to ask directly on the next call whether the acquisition affects their vendor review process — before the proposal goes further into integration limbo.
• Standup question for James: “Have you spoken to anyone at Cartway since the acquisition was announced — and do you know if their procurement process has changed?”

AMBER DEALS — watch this week

GREEN DEALS — no action needed

Brightfield Co · $112K · Proposal · Owner: Sarah K. — active cadence, no signals Corelink SaaS · $95K · Closing · Owner: James R. — next meeting Thursday, no signals Novela Group · $48K · Discovery · Owner: Dana P. — meeting last week, no signals

Account signals via Lusha connector, May 19. Meeting cadence from Google Calendar live session.