DOCUMENT OPS

Extract renewal and termination dates from filed contracts and create Google Calendar reminders

After a contract is filed in Notion, parses its renewal, auto-renew, and termination-notice dates and creates Google Calendar reminders so deadlines are never missed.

CategoryDocument Ops
Enginesim
Difficultyintermediate
Triggerevent
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNew page added to Notion contract registerNotionNotion
  • ActionFetch linked Dropbox PDF and extract textDropboxDropbox
  • ActionExtract renewal, auto-renew, and notice datesOpenAI
  • LogicCompute notice-deadline reminder date
  • OutputCreate Google Calendar reminders for each deadlineGoogle CalendarGoogle Calendar
  • ActionWrite computed dates back to Notion pageNotionNotion

What it does

Closes the loop after filing by turning a contract's date clauses into calendar events. It reads the document for renewal date, auto-renewal flag, and notice-period requirement, then schedules a reminder ahead of each deadline.

When to use it

Use this when contracts auto-renew silently and you've been burned by missing a cancellation window. It guarantees someone gets a heads-up before every renewal and notice deadline.

How it works

  1. 1A new page added to the Notion contract register triggers the run.
  2. 2The linked Dropbox PDF is fetched and its text extracted.
  3. 3OpenAI extracts effective date, term length, auto-renew flag, and required notice period as structured dates.
  4. 4A logic step computes the reminder date by subtracting the notice period from the renewal date.
  5. 5A Google Calendar event is created for the renewal and a second for the notice deadline, each linking back to the Notion page.
  6. 6The Notion page is updated with the computed dates for at-a-glance tracking.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect NotionPages, databases, comments.
  2. 2
    Connect DropboxFiles and folders.
  3. 3
    Connect OpenAIModels, embeddings, files.
  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.