n8n Contract Clause Review: Google Drive + Claude + Sheets

Automatically review contract clauses from Google Drive using Claude—then log results to Google Sheets

This n8n workflow watches your Google Drive for newly uploaded contracts, uses Anthropic Claude to extract and assess each clause against your legal playbook and hard limits, and produces a single, deterministic sign/hold verdict. It escalates to a human only when needed, records everything in Google Sheets, and notifies your system via webhook.

What this workflow does

• Detects new contracts: Triggers when a new file is created in a specific Google Drive folder (or you can run it manually with a provided file ID).
• Prepares the document for Claude: Downloads the contract from Google Drive, converts it to Base64, and sends it to the Anthropic Messages API to extract a structured list of clauses.
• Assesses clauses in batches: Splits extracted clauses into small batches and asks Claude to evaluate each clause against your legal playbook, returning severity, explanations, and suggested redlines.
• Aggregates findings into one verdict: Produces a consolidated review, deterministically sets a verdict, and enforces hard-limit breaches by forcing a “DO_NOT_SIGN” decision.
• Human escalation when required: If the workflow decides human review is needed, it posts decision links to your webhook endpoint and waits for the reviewer to proceed, request redlining, or reject.
• Auto-clears when safe: If no escalation is required, it auto-clears the contract.
• Logs and notifies: Builds a severity-ordered report, appends the full review record to Google Sheets, and sends a completion notice to the same webhook.

Use cases

• Contract review automation for SaaS operations teams who want consistent, playbook-driven risk checks.
• Legal workflow triage: route only high-severity clauses to human reviewers with suggested redlines.
• Audit-ready tracking: store every Claude-based clause finding in Google Sheets.

Technical details

• Integrations: Google Drive, Google Sheets, Anthropic (Messages API), Webhook.
• n8n nodes/logic: if, set, code, wait, sticky note, Google Drive trigger and file handling.
• Key behavior: deterministic verdicting with hard-limit enforcement (DO_NOT_SIGN), batch clause assessment, escalation links + wait loop, and webhook completion notifications.