Nudge: Proposal aging
Daily at 9:00 AM
Stage = "Proposal Sent" AND DaysBetween([Last Stage Change], Today()) >= 7
Post task: “Follow up on proposal” + Draft email note into record; notify Owner
Prevents stalled deals; weekly reminder until stage changes
Auto-Score: New lead enrichment
On new row added
IsBlank([AI Lead Score])
Call AI pack to enrich company size/industry; update AI Lead Score (Hot/Warm/Cold)
Uses website + LinkedIn; sets Score % and label
Nudge: Stale conversation
Daily at 9:00 AM
Stage = "Conversation Opened" AND DaysBetween([Last Contacted], Today()) >= 5
Add task: “Send value add note / case study”; notify Owner
Keeps momentum and qualifies fast
Escalate: Hot lead no meeting
Hourly
"Hot" IN [AI Lead Score] AND IsBlank([Next Meeting Date]) AND DaysBetween([Created On], Today()) >= 3
Slack/Email alert to Owner + create 15‑min hold on calendar
Converts intent quickly
Forecast: Weekly rollup
Fridays at 4:00 PM
True()
Summarize pipeline by Stage + weighted revenue; email weekly forecast
Uses Score % as weight or Stage weight
Auto-close lost (quiet loss)
Daily at 6:00 PM
DaysBetween([Last Contacted], Today()) >= 30 AND NOT(Stage = "Closed Won") AND NOT(Stage = "Closed Lost")
Set Stage to "Closed Lost"; Reason = "No response"; notify Owner
Keeps pipeline clean; can be reversed manually
On Win: Spin up onboarding
On row change
Stage changed to "Closed Won"
Create Client record + kickoff checklist; schedule welcome email
Connects Sales → Delivery automatically