CRM
Daily No-Show Digest: Cohort Report and Bulk Reschedule
Each morning this workflow rolls up the prior day's calendar no-shows into an Airtable tracker, enrolls every missed contact in a HubSpot reschedule campaign.
How it runs
The automated pipeline, trigger to output.
- TriggerMorning scheduled roll-up
- ActionGather prior-day no-show eventsGoogle Calendar
- ActionAppend no-shows to Airtable trackerAirtable
- ActionBulk-enroll contacts in HubSpot campaignHubSpot
- OutputEmail cohort digest to the teamGmail
What it does
Rather than reacting one meeting at a time, this workflow batches the previous day's no-shows into a daily cohort. It logs each missed meeting to an Airtable tracker for trend analysis, bulk-enrolls the affected contacts in a HubSpot reschedule campaign, and sends managers one clean digest of who was missed and what recovery is now in motion.
When to use it
Choose this when you'd rather manage no-shows as a daily operations rhythm than as a flurry of real-time alerts. Great for sales ops and managers who want a single source of truth on no-show rates and recovery coverage over time.
How it works
- 1A morning schedule triggers the daily roll-up.
- 2The workflow gathers all Google Calendar events from the prior day that ended as no-shows.
- 3Each no-show is appended to an Airtable tracker with meeting, owner, and contact details for cohort reporting.
- 4The matched contacts are bulk-enrolled in a HubSpot reschedule campaign in one batch.
- 5A formatted cohort digest — counts, owners, and recovery status — is emailed to the team via Gmail.
Set it up
What you configure once, before turning it on.
- 1Connect Google CalendarEvents, attendees, availability.
- 2Connect AirtableBases, tables, views, automations.
- 3Connect HubSpotCRM, deals, marketing, support.
- 4Connect GmailRead, draft, send, label.
- 5Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 6Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 7Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More CRM workflows
Dormant Account Check-In Call Scheduler
On the anniversary of an account's last touch, books a tentative check-in call on the owner's Google Calendar and emails the contact a scheduling invite.
Weekly Dormant-Anniversary Cohort Digest
Every week, groups dormant Attio accounts by which last-touch anniversary they hit that week, builds a prioritized digest.
AI-Personalized Dormant Account Win-Back
On a dormancy anniversary, an agent researches the account's history and recent public signals, drafts a genuinely personalized win-back email.
Backfill Intercom conversation topics onto stale HubSpot contacts
Finds HubSpot contacts with no recent Intercom topic, pulls their conversation history from Intercom, classifies the dominant topic with OpenAI.
Daily orphaned-opportunity sweep with manager Slack digest
Each morning this scans Salesforce for open opportunities owned by inactive users and posts a per-manager digest in Slack listing the orphaned deals that need a new owner.
Tag closed Intercom conversations onto Salesforce contacts in real time
On each Intercom conversation close, classifies the topic with OpenAI and appends it to the matching Salesforce contact's activity timeline so the topic never goes stale…
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.