Turn new Google Drive contracts into Notion risk briefs with Gemini

Build me an agent workflow that reviews new vendor and customer contract PDFs dropped into a specific Google Drive folder and turns each one into a structured risk brief in Notion. Trigger: cron, every 30 minutes.

On each tick, use Google Drive List Files against a designated Contracts Inbox folder to find PDFs added since the last run. Filter on mimeType = application/pdf and modifiedTime newer than the last successful run. Dedupe by Google Drive file id so the same PDF is never re-reviewed, even if the folder is re-scanned or a file is renamed.

For every new file, use Google Drive Download File Content to pull the binary, then pass the PDF bytes to Google Gemini Generate Content using gemini-2.5-pro for its long context window. The Gemini prompt should extract a stable, structured schema so downstream Notion rollups keep working: counterparty name, contract type (vendor or customer), effective date, end date, total contract value and currency, payment terms, auto-renewal window and notice period, liability cap, indemnity summary, IP and data-processing terms, termination for convenience clause, and governing law. It should also flag any clause that departs from our standard playbook and assign an overall risk rating of low, medium, or high with a one-sentence rationale, plus a short list of the top two or three flagged clauses.

Use Notion Create a Page to log a row in a Contract Reviews database with all of those fields plus a link back to the original Drive file. Keep the field names and shape stable across runs so Notion rollup formulas and saved views do not break.

Then use Slack Bot Send a Message to post to a legal review channel, but only for contracts rated medium or high risk. Keep the Slack message compact and left-aligned so legal can triage on mobile: counterparty, risk rating, top two flagged clauses inline, and a link to the Notion page. Skip Slack entirely for low risk contracts.

Ask me for the Drive folder id, the Notion database id, and the Slack channel when you set this up. If anything fails, log the error against the Notion row so we can retry the file manually rather than silently dropping it.