INVOICE PROCESSING

Open a Linear Ticket When a Vendor's Cumulative Creep Crosses a Cap

Runs weekly, tracks each recurring vendor's cumulative price increase since a fixed contract anchor date.

CategoryInvoice Processing
Enginesim
Difficultyintermediate
Triggerschedule
Steps4
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly schedule fires the creep check
  • ActionPull vendor invoices since contract anchor datePostgreSQLPostgres
  • LogicCompute cumulative creep and compare to renegotiation cap
  • OutputOpen Linear ticket for vendors over the capLinearLinear

What it does

Small per-invoice increases are easy to wave through, but they compound. This workflow watches the cumulative drift since each vendor's contract anchor date rather than just the latest jump. Every week it recomputes how far above baseline each vendor now sits in total. When a vendor's accumulated creep crosses your cap, it opens a Linear ticket assigned to the contract owner so the increase gets formally reviewed and renegotiated rather than quietly normalized.

When to use it

Use this when individual increases stay under per-invoice alert thresholds but add up over months. Best for teams managing renewals and vendor contracts who want action items, not just notifications.

How it works

  1. 1A weekly schedule triggers the run.
  2. 2The workflow pulls each recurring vendor's invoices since their anchor date from Postgres.
  3. 3It computes cumulative drift from the anchor baseline to the latest invoice.
  4. 4A logic step compares cumulative creep against the renegotiation cap.
  5. 5Vendors under the cap are skipped to avoid ticket spam.
  6. 6For vendors over the cap with no open ticket, a Linear issue is created with the creep history and contract owner as assignee.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect PostgresAny Postgres URL — query, write, migrate.
  2. 2
    Connect LinearIssues, projects, cycles, triage.
  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.