DOCUMENT OPS

Maintain a Coda obligation register from a contracts drive

On a daily schedule, scans new agreements in Google Drive, extracts party, value, term, and obligation details with an LLM.

CategoryDocument Ops
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily schedule
  • ActionList and read new agreements from Google DriveGoogle DriveGoogle Drive
  • ActionExtract terms and obligations with OpenAIOpenAI
  • LogicDe-duplicate against already-processed contracts
  • ActionUpsert one row per obligation into Coda registerCodaCoda
  • OutputReturn new and updated row counts

What it does

This workflow keeps a living obligation register in Coda. Each day it picks up agreements added to a Google Drive folder, has an LLM parse the key commercial terms and every recurring or one-time obligation, and writes one normalized row per obligation into a Coda table that your team filters, sorts, and reports on.

When to use it

Use it when you need a single source of truth for who owes what and when across a contract portfolio, and you want that register to stay current without anyone manually transcribing terms from PDFs.

How it works

  1. 1A daily schedule fires the run.
  2. 2Recently added files in the target Google Drive folder are listed and their text read.
  3. 3OpenAI extracts counterparty, contract value, term dates, and an array of obligations with due dates and owners.
  4. 4A logic step de-duplicates against contracts already processed so re-runs are safe.
  5. 5Each obligation is upserted as a row in the Coda obligation register, keyed by contract ID plus clause.
  6. 6The run returns a count of new and updated rows.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect Google DriveDocs, sheets, slides, files.
  2. 2
    Connect OpenAIModels, embeddings, files.
  3. 3
    Connect CodaDocs, packs, automations.
  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.