{"product_id":"n8n-contract-clause-review-google-drive-claude-sheets","title":"n8n Contract Clause Review: Google Drive + Claude + Sheets","description":"\u003ch3\u003eAutomatically review contract clauses from Google Drive using Claude—then log results to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects new contracts\u003c\/strong\u003e: Triggers when a new file is created in a specific Google Drive folder (or you can run it manually with a provided file ID).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrepares the document for Claude\u003c\/strong\u003e: Downloads the contract from Google Drive, converts it to \u003cstrong\u003eBase64\u003c\/strong\u003e, and sends it to the \u003cstrong\u003eAnthropic Messages API\u003c\/strong\u003e to extract a structured list of clauses.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAssesses clauses in batches\u003c\/strong\u003e: Splits extracted clauses into small batches and asks Claude to evaluate each clause against your legal playbook, returning severity, explanations, and suggested redlines.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAggregates findings into one verdict\u003c\/strong\u003e: Produces a consolidated review, deterministically sets a verdict, and enforces hard-limit breaches by forcing a \u003cstrong\u003e“DO_NOT_SIGN”\u003c\/strong\u003e decision.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHuman escalation when required\u003c\/strong\u003e: If the workflow decides human review is needed, it posts decision links to your \u003cstrong\u003ewebhook endpoint\u003c\/strong\u003e and \u003cstrong\u003ewaits\u003c\/strong\u003e for the reviewer to proceed, request redlining, or reject.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuto-clears when safe\u003c\/strong\u003e: If no escalation is required, it auto-clears the contract.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs and notifies\u003c\/strong\u003e: Builds a severity-ordered report, \u003cstrong\u003eappends the full review record to Google Sheets\u003c\/strong\u003e, and sends a completion notice to the same webhook.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eContract review automation for SaaS operations teams who want consistent, playbook-driven risk checks.\u003c\/li\u003e\n  \u003cli\u003eLegal workflow triage: route only high-severity clauses to human reviewers with suggested redlines.\u003c\/li\u003e\n  \u003cli\u003eAudit-ready tracking: store every Claude-based clause finding in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google Drive, Google Sheets, Anthropic (Messages API), Webhook.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic\u003c\/strong\u003e: \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003ewait\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, Google Drive trigger and file handling.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKey behavior\u003c\/strong\u003e: deterministic verdicting with hard-limit enforcement (\u003cstrong\u003eDO_NOT_SIGN\u003c\/strong\u003e), batch clause assessment, escalation links + wait loop, and webhook completion notifications.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45905421861043,"sku":"N8N-18748","price":26.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/BgFbTvBnrJBPYeBzAiQ_u_hdomJ0IT.png?v=1787821580","url":"https:\/\/buyflowscripts.com\/products\/n8n-contract-clause-review-google-drive-claude-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}