n8n Google Drive Contract Risk Analysis w/ AI & Sheets

Automatically analyze new Google Drive contracts for risk—and alert your team

This 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.

What this workflow does

• Monitors a Google Drive folder: Triggers when a new file is created in your specified folder.
• Filters to PDF contracts only: Continues only if the uploaded file is a PDF.
• Extracts and prepares contract text: Downloads the PDF from Google Drive, extracts its text, and trims it to a configurable maxCharacters limit.
• Runs AI contract risk analysis: 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 0–100 risk score.
• Normalizes results for reporting: Converts the AI output into a single flat record, calculates a risk level, and decides whether to alert based on riskAlertThreshold.
• Logs to Google Sheets: Appends the normalized analysis as a new row in the selected sheet tab.
• Sends a Gmail alert: Emails the formatted summary and risk flags when the risk score meets or exceeds your threshold.

Use cases

• Reviewing vendor/customer contract PDFs as they’re uploaded to Google Drive, with instant risk scoring for SaaS operator workflows.
• Automating contract intake for legal/compliance teams—while maintaining a searchable audit trail in Google Sheets.
• Triggering immediate internal review via Gmail when high-risk contract signals are detected.

Technical details

• Integrations: Google Drive (watch/download), Google Sheets (append rows), Gmail (send alerts), AI provider (OpenAI / Anthropic Claude / Google Gemini).
• Core workflow logic: if, filter, switch, set, and code nodes to control flow, normalize AI output, and implement threshold-based alerting.

Ideal for n8n automation engineers and teams building contract risk analysis pipelines with AI and Google-based reporting.