PERSONAL PRODUCTIVITY
Team Meeting-Load Rollup to Airtable
Each week, aggregates calendar meeting hours and focus-block availability across a roster of team members, writes per-person and team-level metrics to Airtable for trend tracking.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly rollup schedule fires
- ActionPull each member's calendar eventsGoogle Calendar
- LogicCompute per-person load metrics
- ActionUpsert weekly rows to AirtableAirtable
- OutputPost team load summary to SlackSlack
What it does
Produces a team-wide view of meeting load. For every person on a configured roster, it tallies weekly meeting hours, count of days with no focus block, and largest average free window, then logs one row per person per week to Airtable so trends are visible over time. It also surfaces the most overloaded people in a Slack summary so managers can rebalance.
When to use it
Use it when you manage a team and need data, not anecdotes, about where meeting load is concentrated. The Airtable history makes it easy to show whether a calendar-hygiene push actually moved the numbers month over month.
How it works
- 1A weekly schedule trigger starts the rollup.
- 2The flow iterates the roster and pulls each member's events from Google Calendar.
- 3A logic step computes per-person meeting hours, focus-starved days, and free-window averages.
- 4It upserts one row per person for the week into an Airtable table.
- 5A team summary highlighting the most meeting-heavy people is posted to Slack.
Set it up
What you configure once, before turning it on.
- 1Connect Google CalendarEvents, attendees, availability.
- 2Connect AirtableBases, tables, views, automations.
- 3Connect SlackChannels, DMs, threads, mentions.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Personal Productivity workflows
Log Outlook promises to Airtable with per-recipient commitment rollups
Captures promises from sent Outlook mail into an Airtable base, linking each commitment to a recipient record so you get a running per-contact view of everything you've promised…
Turn Outlook email promises into assigned Asana tasks with due dates
When you send an email containing a commitment, an LLM extracts the promise and its deadline and creates a corresponding Asana task assigned to you with the due date set.
Auto-decline low-priority invites that collide with deep-work blocks
When a new calendar invite lands on top of a protected deep-work block, an AI scores its priority and auto-declines low-value meetings with a polite note proposing alternative…
Decline focus-block meetings and auto-propose a free slot via Notion log
When a low-priority invite hits a focus block, it declines the meeting, finds your next genuinely free slot, replies with a counter-proposal.
Monthly Meeting Cost Report by Email
On the first of each month, tallies every recurring meeting's total person-hours across the team, converts to an estimated dollar cost.
Auto-create weekly focus blocks around existing meetings and guard them
Every Sunday an agent reads next week's confirmed meetings, carves protected deep-work blocks into the open gaps, sets your Slack status to defend them.
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.