PERSONAL PRODUCTIVITY

Weekly recurring-meeting cost audit in Coda

Every Monday, scans the next 7 days of Google Calendar for recurring meetings, multiplies attendee count by duration and a per-hour cost rate.

CategoryPersonal Productivity
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly schedule fires Monday morning
  • ActionFetch next 7 days of events from Google CalendarGoogle CalendarGoogle Calendar
  • LogicKeep only recurring meetings
  • LogicCompute attendee-hours and dollar cost, sort by cost
  • ActionUpsert ranked cost rows into Coda tableCodaCoda
  • OutputWrite top-3 cost summary to Coda sectionCodaCoda

What it does

This workflow turns your shared calendar into a weekly spend report. It pulls every recurring meeting scheduled for the coming week, computes attendee-hours (people x hours) and a dollar cost using a configurable blended hourly rate, then upserts a sorted table into Coda. The result is a single, always-current view of where recurring meeting time is going.

When to use it

Run it when standing meetings have quietly multiplied and nobody can say what they cost. It is built for ops leads, chiefs of staff, and finance partners who want a recurring, low-effort artifact to drive meeting-hygiene conversations.

How it works

  1. 1A weekly schedule fires every Monday morning.
  2. 2The flow queries Google Calendar for events in the next 7 days and keeps only those flagged as recurring.
  3. 3For each meeting it calculates attendee-hours and multiplies by the configured hourly rate to get a dollar cost.
  4. 4It sorts meetings by cost, highest first.
  5. 5It upserts rows into a Coda table keyed by meeting title, so the doc always reflects the current week.
  6. 6It posts a short summary with the top three most expensive meetings to the doc's section header.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect Google CalendarEvents, attendees, availability.
  2. 2
    Connect CodaDocs, packs, automations.
  3. 3
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  4. 4
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  5. 5
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.