DOCUMENT OPS

Deal-Room Intake Checklist from Google Drive Signed Folder

Audits each signed document dropped into a Google Drive folder against a Notion required-documents checklist for that deal, marks items received.

CategoryDocument Ops
EngineSim + Paperclip
Difficultyintermediate
Triggerevent
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNew signed file in Google Drive deal folderGoogle DriveGoogle Drive
  • ActionClassify file to deal and checklist itemOpenAI
  • ActionMark checklist item received in NotionNotionNotion
  • LogicAll required documents present?
  • OutputSet Notion deal-room status to ready or keep openNotionNotion

What it does

Monitors a Google Drive folder where countersigned documents are deposited per deal. For every new file it identifies which deal it belongs to and which checklist item it satisfies (master agreement, each exhibit, W-9, board consent), updates that deal's required-documents checklist in Notion, and computes whether the packet is now complete. When the last required item arrives, it flips the deal room status to ready.

When to use it

Use it when each deal has a defined set of required documents and you track completeness in Notion, but matching incoming files to checklist items by hand is slow and error-prone.

How it works

  1. 1A new file in the Google Drive signed-docs folder triggers the run.
  2. 2The file is read and classified to a deal and a specific checklist item via OpenAI.
  3. 3The matching item on the deal's Notion checklist is marked received with the file link.
  4. 4A branch evaluates whether all required items are now checked off.
  5. 5If complete, the Notion deal-room page status is set to ready; if not, it stays open with remaining items listed.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect Google DriveDocs, sheets, slides, files.
  2. 2
    Connect NotionPages, databases, comments.
  3. 3
    Connect OpenAIModels, embeddings, files.
  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.