Turn new Google Drive contracts into Notion risk briefs with Gemini

Every 30 minutes, Gemini reads new vendor and customer PDFs from Google Drive, files a structured risk brief in Notion, and pings legal in Slack for the risky ones.

Agentic Task
Google DriveGoogle GeminiNotionSlack BotOperationsFinanceDocument ProcessingNotifications & AlertsAI Reports
PromptCreate

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.

Additional information

What does this prompt do?
  • Watches a designated Google Drive contracts inbox folder every 30 minutes and picks up any new PDF that has not been reviewed yet.
  • Uses Google Gemini to read the full document and pull out counterparty, dates, contract value, payment terms, auto-renewal, liability caps, indemnity, IP, data protection, termination, and governing law.
  • Files each contract as a new row in a Notion Contract Reviews database with a link back to the original file, a list of flagged clauses, and an overall low, medium, or high risk rating.
  • Posts a short Slack alert to your legal channel only when a contract lands as medium or high risk, so the team can triage on mobile without noise.
What do I need to use this?
  • A Google Drive account with a folder set aside as your contracts inbox where new PDFs get dropped.
  • A Google Gemini account for reading and analyzing the contract PDFs.
  • A Notion workspace with a Contract Reviews database ready to receive the structured summaries.
  • A Slack workspace and a channel where your legal or ops reviewers get pinged for risky contracts.
How can I customize it?
  • Change the review cadence, for example every 15 minutes for busy legal teams or once an hour for lighter volume.
  • Adjust the risk rules so the Slack alert fires only for high risk contracts, or expand it to include specific clauses like data protection or IP.
  • Edit the extraction checklist to match your own playbook, adding fields like insurance minimums, jurisdiction preferences, or SLA credits.
  • Point it at a different Notion database or Slack channel for vendor versus customer contracts if you want separate pipelines.

Frequently asked questions

Will the same contract get reviewed twice if it sits in the folder?
No. The workflow remembers which files it has already processed by their Drive file id, so a contract only ever produces one Notion entry even if the folder is re-scanned.
Does this work for long, multi-page contracts?
Yes. Gemini can read the full PDF in one pass, so multi-page master service agreements and vendor contracts are handled without chunking.
What if I only want to be notified about high risk contracts?
Ask the workflow author to tighten the Slack rule to only fire on high risk. The Notion database will still get an entry for every contract.
Can I use this for customer contracts, not just vendor contracts?
Yes. Drop customer PDFs into the same inbox folder, or run a second copy of the workflow pointed at a separate customer contracts folder and Notion database.
Do the Notion fields stay consistent across contracts?
Yes. The extraction uses a fixed set of fields, so rollup formulas and views in your Notion database keep working across every new row.

Related templates

Braintree
Slack Bot

Daily Braintree declined-payment recovery digest to Slack

Every weekday at 8am, your billing team gets a Slack rundown of yesterday's failed Braintree charges, the revenue at risk, and who to chase first.

5d ago

Agentic Task
Prompt
Azure DevOps
Slack Bot

Weekday Azure DevOps sprint standup digest in Slack

Every weekday morning, roll up your sprint's work items into a clear per-person standup summary and post it to your team's Slack channel before you meet.

5d ago

Agentic Task
Prompt
Braintree
Zendesk
Slack Bot

Track new Braintree disputes before the deadline slips

Every three hours we scan Braintree for new disputes and chargebacks, open a tracked ticket with a tailored evidence checklist, and alert your team in Slack before the response deadline slips.

5d ago

Agentic Task
Prompt
Databricks
Slack Bot

Daily Databricks data health check with Slack alerts

Every weekday morning we check your most important Databricks tables for freshness and data problems, and ping Slack only when something actually looks wrong.

5d ago

Agentic Task
Prompt
Have I Been Pwned
Slack Bot

Monday morning employee breach exposure briefing in Slack

Every Monday, automatically find which employee accounts on your company domain turned up in data breaches and get a plain-English briefing in Slack.

5d ago

Agentic Task
Prompt
Azure DevOps
Slack Bot

Instant Slack alert when an Azure DevOps build fails

When a pipeline build fails, we post a tight Slack card naming who pushed, the likely cause, and a link to the build so on-call can triage in seconds.

5d ago

Agentic Task
Prompt

Stop reading every contract line by line.

Connect Google Drive, Gemini, Notion, and Slack once, and Geni turns every new contract into a Notion risk brief every 30 minutes.

Explore more promptsCreate