DOCUMENT OPS

Scan the contract index nightly and alert on upcoming renewals

Runs on a nightly schedule, queries the Postgres contract index for agreements with renewal or expiry dates inside a configurable window.

CategoryDocument Ops
Enginesim
Difficultybeginner
Triggerschedule
Steps4
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNightly schedule fires
  • ActionQuery Postgres index for upcoming renewals/expiriesPostgreSQLPostgres
  • LogicBucket by urgency and owning team; skip if empty
  • OutputPost grouped renewal digest to SlackSlack

What it does

This workflow keeps your contract index honest by acting on it. Each night it queries Postgres for contracts whose renewal or expiration date falls inside a lookahead window, groups them by owning team, and posts a clean digest to Slack so nothing auto-renews or lapses unnoticed.

When to use it

Use it once you already have an indexed contract repository and want proactive renewal management. Ideal for finance and ops teams that have been burned by silent auto-renewals or missed cancellation windows.

How it works

  1. 1A nightly schedule triggers the run.
  2. 2The workflow queries the Postgres contract index for renewal or expiry dates within the configured window (e.g. next 60 days).
  3. 3A logic step buckets results by urgency — cancellation-deadline-soon versus renews-soon — and by owning team.
  4. 4If no contracts fall in the window, the run ends quietly with no noise.
  5. 5Otherwise a grouped digest, with counterparty, dates, value, owner, and source link, is posted to the relevant Slack channel.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect PostgresAny Postgres URL — query, write, migrate.
  2. 2
    Connect SlackChannels, DMs, threads, mentions.
  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.