Contract Risk Summary

{ "edges": [ { "to": "a518d2ee-a14b-4696-9d66-0c9f63bad53a", "from": "94721676-0968-4cbf-8177-75e245c96fcd", "toPort": "0", "fromPort": "0" }, { "to": "36c8c170-5ed0-423f-a3ce-d1c7a2f8374e", "from": "27ac6f18-01b7-4bdb-986d-8f35566e055a", "toPort": "0", "fromPort": "0" }, { "to": "ca506624-1189-41eb-8cb7-5d88932a4827", "from": "161ea93f-db54-4723-af64-110088549671", "toPort": "0", "fromPort": "0" }, { "to": "2b3a4dbe-5e5e-4c6b-8e57-67fcaa8e3652", "from": "144bba7f-04e4-41ee-b901-07b90b8f4c41", "toPort": "0", "fromPort": "0" }, { "to": "144bba7f-04e4-41ee-b901-07b90b8f4c41", "from": "c6f6459d-6438-45db-9e61-b7b11dc5f5b6", "toPort": "0", "fromPort": "0" }, { "to": "94721676-0968-4cbf-8177-75e245c96fcd", "from": "f0c7f8f7-e5e4-4b49-baa3-885c2453a0bd", "toPort": "0", "fromPort": "0" }, { "to": "27ac6f18-01b7-4bdb-986d-8f35566e055a", "from": "2b3a4dbe-5e5e-4c6b-8e57-67fcaa8e3652", "toPort": "0", "fromPort": "0" }, { "to": "161ea93f-db54-4723-af64-110088549671", "from": "2b3a4dbe-5e5e-4c6b-8e57-67fcaa8e3652", "toPort": "0", "fromPort": "1" }, { "to": "c6f6459d-6438-45db-9e61-b7b11dc5f5b6", "from": "a518d2ee-a14b-4696-9d66-0c9f63bad53a", "toPort": "0", "fromPort": "0" }, { "to": "89317dde-a623-4865-b85b-434d877ed5d6", "from": "36c8c170-5ed0-423f-a3ce-d1c7a2f8374e", "toPort": "0", "fromPort": "0" }, { "to": "89317dde-a623-4865-b85b-434d877ed5d6", "from": "ca506624-1189-41eb-8cb7-5d88932a4827", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "94721676-0968-4cbf-8177-75e245c96fcd", "name": "Download file1", "type": "integration", "params": { "fileId": { "__rl": true, "mode": "list", "value": "" }, "options": {}, "service": "googleDrive", "operation": "download" }, "position": [ 6608, 4736 ] }, { "id": "a518d2ee-a14b-4696-9d66-0c9f63bad53a", "name": "Extract Text From Downloaded File1", "type": "code", "params": { "jsCode": "/**\n * This node extracts readable text from a downloaded file.\n * Works best for TXT / HTML / MD files.\n * For PDF/DOCX it forwards base64 content to AI (still usable by OpenAI).\n */\n\nconst items = $input.all();\n\nreturn items.map(item => {\n let extractedText = '';\n let fileName = '';\n let mimeType = '';\n\n // Google Drive download puts file in binary\n const binaryKeys = Object.keys(item.binary || {});\n\n if (binaryKeys.length === 0) {\n extractedText = 'No file found in binary data.';\n } else {\n const binaryData = item.binary[binaryKeys[0]];\n fileName = binaryData.fileName || 'unknown';\n mimeType = binaryData.mimeType || 'unknown';\n\n // Convert base64 → string\n const buffer = Buffer.from(binaryData.data, 'base64');\n\n if (\n mimeType.includes('text') ||\n fileName.endsWith('.txt') ||\n fileName.endsWith('.md') ||\n fileName.endsWith('.html')\n ) {\n // Clean readable text files\n extractedText = buffer.toString('utf-8');\n } else {\n // For PDF / DOCX / others → pass raw content to AI\n extractedText =\n `The following is raw extracted content from a ${fileName} contract file.\\n` +\n `Analyze and summarize key terms, risks, and obligations:\\n\\n` +\n buffer.toString('utf-8');\n }\n }\n\n return {\n json: {\n fileName,\n mimeType,\n contractText: extractedText\n }\n };\n});\n" }, "position": [ 6784, 4736 ] }, { "id": "c6f6459d-6438-45db-9e61-b7b11dc5f5b6", "name": "AI Contract Analysis1", "type": "llm", "params": { "modelId": { "__rl": true, "mode": "list", "value": "model-name", "cachedResultName": "GPT-4O-MINI" }, "options": {}, "provider": "openai", "responses": { "values": [ { "role": "system", "content": "=You are a senior legal contract analyst AI with expertise in commercial, SaaS, vendor, and enterprise agreements.\n\nYour role is to analyze contract language, identify explicit terms, and intelligently infer potential risks based on standard industry practices and legal norms.\n\nYou are allowed to infer risks when they are not explicitly stated, but only when the inference is logically supported by the contract structure, missing safeguards, or commonly accepted contract standards.\n\nYou must:\n- Clearly distinguish between explicitly stated risks and inferred risks\n- Avoid speculation or extreme assumptions\n- Base all inferences on the actual contract text and widely accepted industry practices\n- Use professional, cautious, and neutral language\n- Never fabricate clauses that do not exist\n\nIf a risk is inferred due to missing protections, clearly label it as an \"Inferred Risk\".\n" }, { "content": "=Analyze the following contract text in detail.\n\nYour tasks:\n1. Extract key commercial and legal terms.\n2. Identify all payment-related clauses (fees, billing cycle, late fees, penalties).\n3. Identify renewal, termination, and notice period clauses.\n4. Detect financial, legal, and operational risks using both:\n - Explicit contract language\n - Reasonable risk inference based on missing safeguards or standard industry expectations\n5. Extract obligations and responsibilities for each party.\n6. Identify important dates, deadlines, and milestones.\n7. Highlight penalties, liabilities, indemnities, or breach consequences.\n8. Identify hidden or implied risks caused by:\n - Liability limitations\n - Auto-renewal clauses\n - Missing SLAs, compliance terms, or data protection obligations\n\nRisk Inference Rules:\n- If a risk is explicitly stated, classify it as \"Explicit Risk\".\n- If a risk is not stated but reasonably implied, classify it as \"Inferred Risk\".\n- Do NOT infer risks that cannot be reasonably justified by the contract text.\n- Avoid fear-based or exaggerated language.\n\nOutput Rules:\n- Return ONLY valid JSON.\n- Do NOT include explanations, markdown, or commentary.\n- Never return empty arrays.\n- If no explicit risk exists, infer potential risks where reasonable.\n- Clearly label each risk entry with either \"Explicit Risk\" or \"Inferred Risk\".\n\nUse clear, business-friendly language.\n\nOutput format:\n{\n \"contractOverview\": {\n \"contractType\": \"\",\n \"partiesInvolved\": [],\n \"effectiveDate\": \"\",\n \"contractDuration\": \"\"\n },\n \"keyTerms\": {\n \"scopeOfServices\": \"\",\n \"pricingSummary\": \"\",\n \"governingLaw\": \"\"\n },\n \"paymentClauses\": {\n \"fees\": \"\",\n \"billingCycle\": \"\",\n \"latePaymentPenalties\": \"\"\n },\n \"renewalAndTermination\": {\n \"renewalType\": \"\",\n \"noticePeriod\": \"\",\n \"terminationConditions\": \"\"\n },\n \"obligations\": {\n \"partyA\": [],\n \"partyB\": []\n },\n \"risksAndPenalties\": {\n \"financialRisks\": [],\n \"legalRisks\": [],\n \"operationalRisks\": []\n },\n \"importantDatesAndDeadlines\": [],\n \"overallRiskLevel\": \"Low | Medium | High\",\n \"summaryForStakeholders\": \"\"\n}\n\nContract Text:\n{{ $json.contractText }}\n" } ] }, "builtInTools": {} }, "position": [ 6960, 4736 ] }, { "id": "144bba7f-04e4-41ee-b901-07b90b8f4c41", "name": "Format AI Output1", "type": "code", "params": { "jsCode": "/**\n * This code:\n * 1. Extracts AI text from LangChain output format\n * 2. Parses JSON safely\n * 3. Flattens data for alerts & Google Sheets\n */\n\nfunction safeJsonParse(text) {\n try {\n return JSON.parse(text);\n } catch (e) {\n const match = text.match(/\\{[\\s\\S]*\\}/);\n if (!match) throw new Error(\"No JSON found\");\n return JSON.parse(match[0]);\n }\n}\n\nreturn $input.all().map(item => {\n let rawText = \"\";\n\n try {\n rawText =\n item.json.output?.[0]\n ?.content?.find(c => c.type === \"output_text\")\n ?.text || \"\";\n } catch (e) {\n rawText = \"\";\n }\n\n let parsed;\n try {\n parsed = safeJsonParse(rawText);\n } catch (err) {\n return {\n json: {\n error: \"Failed to parse AI response\",\n rawResponse: rawText\n }\n };\n }\n\n function formatRisks(risksArray) {\n if (!Array.isArray(risksArray) || risksArray.length === 0) {\n return \"No significant risks identified\";\n }\n \n return risksArray\n .map(r => {\n if (typeof r === \"string\") return r;\n if (typeof r === \"object\") {\n return `${r.classification}: ${r.risk}`;\n }\n return \"\";\n })\n .filter(Boolean)\n .join(\"; \");\n }\n\n return {\n json: {\n // Contract Overview\n contractType: parsed.contractOverview?.contractType || \"\",\n partiesInvolved: (parsed.contractOverview?.partiesInvolved || []).join(\", \"),\n effectiveDate: parsed.contractOverview?.effectiveDate || \"\",\n contractDuration: parsed.contractOverview?.contractDuration || \"\",\n\n // Key Terms\n scopeOfServices: parsed.keyTerms?.scopeOfServices || \"\",\n pricingSummary: parsed.keyTerms?.pricingSummary || \"\",\n governingLaw: parsed.keyTerms?.governingLaw || \"\",\n\n // Payment\n fees: parsed.paymentClauses?.fees || \"\",\n billingCycle: parsed.paymentClauses?.billingCycle || \"\",\n latePaymentPenalties: parsed.paymentClauses?.latePaymentPenalties || \"\",\n\n // Renewal & Termination\n renewalType: parsed.renewalAndTermination?.renewalType || \"\",\n noticePeriod: parsed.renewalAndTermination?.noticePeriod || \"\",\n terminationConditions: parsed.renewalAndTermination?.terminationConditions || \"\",\n\n // Obligations\n obligationsPartyA: (parsed.obligations?.partyA || []).join(\"; \"),\n obligationsPartyB: (parsed.obligations?.partyB || []).join(\"; \"),\n\n // Risks (FIXED)\n financialRisks: formatRisks(parsed.risksAndPenalties?.financialRisks),\n legalRisks: formatRisks(parsed.risksAndPenalties?.legalRisks),\n operationalRisks: formatRisks(parsed.risksAndPenalties?.operationalRisks),\n\n // Dates\n importantDatesAndDeadlines: (parsed.importantDatesAndDeadlines || []).join(\" | \"),\n\n // Summary\n overallRiskLevel: parsed.overallRiskLevel || \"Unknown\",\n stakeholderSummary: parsed.summaryForStakeholders || \"\"\n }\n };\n});\n" }, "position": [ 7264, 4736 ] }, { "id": "2b3a4dbe-5e5e-4c6b-8e57-67fcaa8e3652", "name": "Alert Teams Automatically1", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "14c22811-06fc-4758-93b9-83d2513ad061", "operator": { "type": "string", "operation": "equals" }, "leftValue": "={{ $json.overallRiskLevel }}", "rightValue": "Medium" }, { "id": "c3ad5d74-b204-460b-9f4c-a22ea8d6494e", "operator": { "type": "string", "operation": "notContains" }, "leftValue": "={{ $json.financialRisks }}", "rightValue": "No significant risks identified" }, { "id": "5ae54f3d-0691-44fc-aabd-2ce44a5f7a82", "operator": { "type": "string", "operation": "notContains" }, "leftValue": "={{ $json.operationalRisks }}", "rightValue": "No significant risks identified" } ] } }, "position": [ 7456, 4736 ] }, { "id": "27ac6f18-01b7-4bdb-986d-8f35566e055a", "name": "Send a message2", "type": "integration", "params": { "sendTo": "gmail-id", "message": "=\n\n\n\n \n Contract Risk Summary\n\n\n\n \n \n \n\n```\n\n

\n \n\n```\n \n \n \n \n\n \n \n \n \n\n \n \n \n \n\n

AI Contract Risk Summary

\n {{$json.contractType}} • Risk Level: {{$json.overallRiskLevel}}\n

\n\n

Hello Team,

\n Below is the AI-generated analysis of the contract. \n This summary highlights key terms, obligations, risks, and deadlines for quick review.\n

\n\n \n

📄 Contract Overview

\n \n \n \n \n \n \n

Contract Type	{{$json.contractType}}
Parties	{{$json.partiesInvolved}}
Effective Date	{{$json.effectiveDate}}
Duration	{{$json.contractDuration}}
Governing Law	{{$json.governingLaw}}

\n\n \n

💼 Scope & Commercial Terms

Scope of Services:
{{$json.scopeOfServices}}

Pricing Summary:
{{$json.pricingSummary}}

\n\n \n

💰 Payment Details

Fees: {{$json.fees}}
Billing Cycle: {{$json.billingCycle}}
Late Payment Penalties: {{$json.latePaymentPenalties}}

\n\n \n

🔄 Renewal & Termination

Renewal Type: {{$json.renewalType}}
Notice Period: {{$json.noticePeriod}}
Termination Conditions: {{$json.terminationConditions}}

\n\n \n

🧾 Key Obligations

Service Provider:
{{$json.obligationsPartyA}}

Client:
{{$json.obligationsPartyB}}

\n\n \n

⚠️ Risk Assessment

Overall Risk Level:\n {{$json.overallRiskLevel}}\n

\n\n

Financial Risks:
{{$json.financialRisks}}

Legal Risks:
{{$json.legalRisks}}

Operational Risks:
{{$json.operationalRisks}}

\n\n \n

⏰ Important Dates & Deadlines

\n\n \n

📝 Stakeholder Summary

\n\n

\n If any risks require immediate attention, please review and advise on next steps.\n

\n\n

\n Regards,
\n AI Contract Summary Bot
\n Automated Contract Intelligence\n

\n\n

\n This email was generated automatically by an AI-powered contract analysis workflow.\n

\n\n\n\n", "options": {}, "service": "gmail", "subject": "=Contract Risk Summary – {{$json.contractType}} | Risk Level: {{$json.overallRiskLevel}}", "operation": "read" }, "position": [ 7664, 4640 ] }, { "id": "36c8c170-5ed0-423f-a3ce-d1c7a2f8374e", "name": "Get The Data To Save In google Sheet2", "type": "code", "params": { "jsCode": "/**\n * Get data from Alert Teams Automatically node\n * This works regardless of which path (true/false) was taken\n */\n\n// Get data from the IF node (Alert Teams Automatically)\nconst alertData = $('Alert Teams Automatically1').first().json;\n\nreturn [{\n json: {\n // Add timestamp\n processedDate: new Date().toISOString(),\n processedDateTime: new Date().toLocaleString('en-IN', { timeZone: 'Asia/Kolkata' }),\n \n // Contract basic info\n contractType: alertData.contractType || '',\n partiesInvolved: alertData.partiesInvolved || '',\n effectiveDate: alertData.effectiveDate || '',\n contractDuration: alertData.contractDuration || '',\n \n // Financial details\n fees: alertData.fees || '',\n billingCycle: alertData.billingCycle || '',\n latePaymentPenalties: alertData.latePaymentPenalties || '',\n \n // Risk assessment\n overallRiskLevel: alertData.overallRiskLevel || 'Unknown',\n financialRisks: alertData.financialRisks || '',\n legalRisks: alertData.legalRisks || '',\n operationalRisks: alertData.operationalRisks || '',\n \n // Renewal & termination\n renewalType: alertData.renewalType || '',\n noticePeriod: alertData.noticePeriod || '',\n terminationConditions: alertData.terminationConditions || '',\n \n // Obligations\n obligationsPartyA: alertData.obligationsPartyA || '',\n obligationsPartyB: alertData.obligationsPartyB || '',\n \n // Other details\n scopeOfServices: alertData.scopeOfServices || '',\n pricingSummary: alertData.pricingSummary || '',\n governingLaw: alertData.governingLaw || '',\n importantDatesAndDeadlines: alertData.importantDatesAndDeadlines || '',\n stakeholderSummary: alertData.stakeholderSummary || '',\n \n // Email path taken\n emailType: alertData.overallRiskLevel === 'Medium' ? 'Risk Alert' : 'Info Only'\n }\n}];" }, "position": [ 7872, 4640 ] }, { "id": "161ea93f-db54-4723-af64-110088549671", "name": "Send a message3", "type": "integration", "params": { "sendTo": "gmail-id", "message": "=\n\n\n\n \n Contract Review Summary\n\n\n\n\n \n \n```\n\n \n

\n \n\n```\n \n \n \n \n\n \n \n \n \n\n \n \n \n \n\n

Contract Review Completed

\n {{$json.contractType}} • Risk Level: {{$json.overallRiskLevel}}\n

Hello Team,

\n\n

\n The contract has been successfully reviewed by the AI Contract Summary Bot.\n Based on the analysis, no immediate action is required at this time.\n

\n\n

📄 Contract Snapshot

Parties: {{$json.partiesInvolved}}
Effective Date: {{$json.effectiveDate}}
Duration: {{$json.contractDuration}}
Governing Law: {{$json.governingLaw}}

\n\n

⚠️ Risk Overview

Overall Risk Level: {{$json.overallRiskLevel}}
Financial Risks: {{$json.financialRisks}}
Legal Risks: {{$json.legalRisks}}
Operational Risks: {{$json.operationalRisks}}

\n\n

📝 Summary

\n\n

\n This contract has been recorded for reference. \n Please reach out if a deeper review is required.\n

\n\n

\n Regards,
\n AI Contract Summary Bot
\n Automated Contract Intelligence\n

\n Informational notification only — no action required.\n

\n\n\n\n", "options": {}, "service": "gmail", "subject": "=Contract Review Completed – No Immediate Action Required | {{$json.contractType}}", "operation": "read" }, "position": [ 7664, 4832 ] }, { "id": "ca506624-1189-41eb-8cb7-5d88932a4827", "name": "Get The Data To Save In google Sheet3", "type": "code", "params": { "jsCode": "// Loop over input items and add a new field called 'myNewField' to the JSON of each one\nfor (const item of $input.all()) {\n item.json.myNewField = 1;\n}\n\nreturn $input.all();" }, "position": [ 7872, 4832 ] }, { "id": "f0c7f8f7-e5e4-4b49-baa3-885c2453a0bd", "name": "Google Drive Trigger1", "type": "trigger", "params": { "kind": "n8n-nodes-base.googleDriveTrigger", "event": "fileCreated", "options": {}, "pollTimes": { "item": [ { "mode": "everyHour" } ] }, "triggerOn": "specificFolder", "folderToWatch": { "__rl": true, "mode": "list", "value": "" } }, "position": [ 6448, 4736 ] }, { "id": "89317dde-a623-4865-b85b-434d877ed5d6", "name": "Append row in sheet1", "type": "integration", "params": { "columns": { "value": { "Fees": "={{ $json.fees }}", "Email Type": "={{ $json.emailType }}", "Legal Risks": "={{ $json.legalRisks }}", "Renewal Type": "={{ $json.renewalType }}", "Billing Cycle": "={{ $json.billingCycle }}", "Contract Type": "={{ $json.contractType }}", "Notice Period": "={{ $json.noticePeriod }}", "Effective Date": "={{ $json.effectiveDate }}", "Processed Date": "={{ $json.processedDate }}", "Financial Risks": "={{ $json.financialRisks }}", "Pricing Summary": "={{ $json.pricingSummary }}", "Parties Involved": "={{ $json.partiesInvolved }}", "Contract Duration": "={{ $json.contractDuration }}", "Operational Risks": "={{ $json.operationalRisks }}", "Scope of Services": "={{ $json.scopeOfServices }}", "Overall Risk Level": "={{ $json.overallRiskLevel }}", "Processed Date Time": "={{ $json.processedDateTime }}", "Stakeholder Summary": "={{ $json.stakeholderSummary }}", "Obligations (Client)": "={{ $json.obligationsPartyB }}", "Late Payment Penalties": "={{ $json.latePaymentPenalties }}", "Termination Conditions": "={{ $json.terminationConditions }}", "Important Dates & Deadlines": "={{ $json.importantDatesAndDeadlines }}", "Obligations (Service Provider)": "={{ $json.obligationsPartyA }}" }, "schema": [ { "id": "Processed Date", "type": "string", "display": true, "required": false, "displayName": "Processed Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Processed Date Time", "type": "string", "display": true, "required": false, "displayName": "Processed Date Time", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Contract Type", "type": "string", "display": true, "required": false, "displayName": "Contract Type", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Parties Involved", "type": "string", "display": true, "required": false, "displayName": "Parties Involved", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Effective Date", "type": "string", "display": true, "required": false, "displayName": "Effective Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Contract Duration", "type": "string", "display": true, "required": false, "displayName": "Contract Duration", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Scope of Services", "type": "string", "display": true, "required": false, "displayName": "Scope of Services", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Pricing Summary", "type": "string", "display": true, "required": false, "displayName": "Pricing Summary", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Fees", "type": "string", "display": true, "required": false, "displayName": "Fees", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Billing Cycle", "type": "string", "display": true, "required": false, "displayName": "Billing Cycle", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Late Payment Penalties", "type": "string", "display": true, "required": false, "displayName": "Late Payment Penalties", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Renewal Type", "type": "string", "display": true, "required": false, "displayName": "Renewal Type", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Notice Period", "type": "string", "display": true, "required": false, "displayName": "Notice Period", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Termination Conditions", "type": "string", "display": true, "required": false, "displayName": "Termination Conditions", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Obligations (Service Provider)", "type": "string", "display": true, "required": false, "displayName": "Obligations (Service Provider)", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Obligations (Client)", "type": "string", "display": true, "required": false, "displayName": "Obligations (Client)", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Financial Risks", "type": "string", "display": true, "required": false, "displayName": "Financial Risks", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Legal Risks", "type": "string", "display": true, "required": false, "displayName": "Legal Risks", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Operational Risks", "type": "string", "display": true, "required": false, "displayName": "Operational Risks", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Overall Risk Level", "type": "string", "display": true, "required": false, "displayName": "Overall Risk Level", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Important Dates & Deadlines", "type": "string", "display": true, "required": false, "displayName": "Important Dates & Deadlines", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Stakeholder Summary", "type": "string", "display": true, "required": false, "displayName": "Stakeholder Summary", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email Type", "type": "string", "display": true, "required": false, "displayName": "Email Type", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [] }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "sheet-url", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "google-sheet-id", "cachedResultUrl": "sheet-url", "cachedResultName": "sheet-name" } }, "position": [ 8112, 4736 ] } ] }

Analyze contract risk from Google Drive with OpenAI and log to Gmail & Sheets