DOCUMENT OPS

Reconcile contract amendments and supersede stale renewal dates

Detects amendment and addendum documents in Dropbox, links them to the original contract in Airtable.

CategoryDocument Ops
Enginepaperclip
Difficultyadvanced
Triggerevent
Steps5
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNew amendment or addendum PDF added to DropboxDropboxDropbox
  • ActionExtract original reference and changed dates with OpenAIOpenAI
  • ActionMatch and update parent contract record in AirtableAirtableAirtable
  • LogicCheck whether the renewal date actually changed
  • OutputReplace stale Google Calendar reminder with corrected dateGoogle CalendarGoogle Calendar

What it does

It keeps renewal dates correct when contracts get amended. When an amendment or addendum is uploaded, it extracts the referenced original agreement and any changed dates, matches it to the existing contract record in Airtable, and if the renewal or term date moved, it deletes the outdated calendar reminder and seeds a new one so you never act on a superseded date.

When to use it

Use it when contracts change after signature through addenda and your reminders drift out of sync with reality. Built for legal and ops teams managing long-lived agreements that get renegotiated mid-term.

How it works

  1. 1A new amendment or addendum PDF is added to the Dropbox contracts folder and triggers the run.
  2. 2OpenAI extracts the referenced original contract, the amendment type, and any new renewal or term dates.
  3. 3The workflow matches the amendment to its parent record in Airtable and updates that record.
  4. 4A logic step checks whether the renewal date actually changed; unchanged amendments stop here.
  5. 5When the date moved, the stale Google Calendar reminder is removed and a corrected renewal event is created against the new date.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect DropboxFiles and folders.
  2. 2
    Connect OpenAIModels, embeddings, files.
  3. 3
    Connect AirtableBases, tables, views, automations.
  4. 4
    Connect Google CalendarEvents, attendees, availability.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    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.