HR & RECRUITING

Weekly Work-Authorization Compliance Digest

Each Monday an agent reviews the full work-authorization runway, drafts a prioritized narrative digest of at-risk cases and overdue actions, publishes it to Notion.

CategoryHR & Recruiting
Enginepaperclip
Difficultyadvanced
Triggerschedule
Steps5
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly Monday schedule
  • ActionQuery BigQuery for all active work-auth recordsGoogle BigQueryBigQuery
  • LogicAgent ranks cases by urgency, flags overdue
  • ActionPublish dated digest page to NotionNotionNotion
  • OutputEmail summary + link to leadership via OutlookOutlook

What it does

This agent-driven workflow produces a weekly executive view of work-authorization health. It reads every employee's expiry runway and re-verification status, reasons about which cases are genuinely at risk versus on track, and writes a clear prioritized brief: who needs action this week, what is overdue, and where deadlines cluster. The result is published to Notion and sent to leadership.

When to use it

Use it when HR leadership needs a recurring, readable summary rather than a raw export. It is best for organizations with enough sponsored or time-limited workers that a flat list is hard to act on and judgment about priority adds real value.

How it works

  1. 1A weekly Monday schedule starts the run.
  2. 2The agent queries BigQuery for all active work-authorization records and their statuses.
  3. 3It analyzes the data, grouping cases by urgency and flagging overdue or stalled re-verifications.
  4. 4It drafts a narrative digest with a ranked action list and risk callouts.
  5. 5It publishes the digest as a dated Notion page.
  6. 6The output emails the page link and executive summary to HR leadership via Outlook.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect BigQueryDatasets, queries, schemas.
  2. 2
    Connect NotionPages, databases, comments.
  3. 3
    Connect OutlookMail, calendar, contacts.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    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.