{"product_id":"n8n-google-drive-contract-risk-analysis-w-ai-sheets","title":"n8n Google Drive Contract Risk Analysis w\/ AI \u0026 Sheets","description":"\u003ch3\u003eAutomatically analyze new Google Drive contracts for risk—and alert your team\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches a Google Drive folder for newly uploaded PDF contracts, extracts their text, uses AI (OpenAI, Anthropic Claude, or Google Gemini) to generate a structured risk assessment with a 0–100 score, logs results to Google Sheets, and sends a Gmail alert when the risk crosses your threshold.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors a Google Drive folder:\u003c\/strong\u003e Triggers when a new file is created in your specified folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters to PDF contracts only:\u003c\/strong\u003e Continues only if the uploaded file is a PDF.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts and prepares contract text:\u003c\/strong\u003e Downloads the PDF from Google Drive, extracts its text, and trims it to a configurable \u003cem\u003emaxCharacters\u003c\/em\u003e limit.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns AI contract risk analysis:\u003c\/strong\u003e Sends the contract text to your selected AI provider—OpenAI, Anthropic Claude, or Google Gemini—to extract structured fields, risk flags, a summary, and a \u003cstrong\u003e0–100 risk score\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes results for reporting:\u003c\/strong\u003e Converts the AI output into a single flat record, calculates a risk level, and decides whether to alert based on \u003cem\u003eriskAlertThreshold\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs to Google Sheets:\u003c\/strong\u003e Appends the normalized analysis as a new row in the selected sheet tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Gmail alert:\u003c\/strong\u003e Emails the formatted summary and risk flags when the risk score meets or exceeds your threshold.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReviewing vendor\/customer contract PDFs as they’re uploaded to Google Drive, with instant risk scoring for SaaS operator workflows.\u003c\/li\u003e\n  \u003cli\u003eAutomating contract intake for legal\/compliance teams—while maintaining a searchable audit trail in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eTriggering immediate internal review via Gmail when high-risk contract signals are detected.\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 (watch\/download), Google Sheets (append rows), Gmail (send alerts), AI provider (OpenAI \/ Anthropic Claude \/ Google Gemini).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore workflow logic:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003efilter\u003c\/em\u003e, \u003cem\u003eswitch\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, and \u003cem\u003ecode\u003c\/em\u003e nodes to control flow, normalize AI output, and implement threshold-based alerting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eIdeal for n8n automation engineers and teams building contract risk analysis pipelines with AI and Google-based reporting.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46164225917107,"sku":"N8N-20473","price":74.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/uUNwqk6Ab6ceReDG3uZNV_zexfr3Ym.png?v=1791278493","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-drive-contract-risk-analysis-w-ai-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}