Track contract renewals and obligations with LlamaParse, GPT-4o-mini and Slack

Description

Quick Overview This workflow watches a Google Drive folder for new contract PDFs, parses them with LlamaParse, extracts key terms and obligations with OpenAI, stores everything in Google Sheets, and uses Slack plus a webhook approval flow to manage renew/terminate decisions and draft termination notices in Gmail. How it works Triggers when a new file is created in a specific Google Drive folder and continues only if the file is a PDF. Downloads the PDF, uploads it to LlamaParse, polls for the parsing job to finish, and alerts a Slack channel if parsing fails or times out. Fetches the parsed markdown from LlamaParse and uses OpenAI (gpt-4o-mini) to extract structured contract terms, risks, and obligations. Calculates the notice decision deadline, upserts the contract into a Google Sheets “Contracts” register, posts a summary to Slack, and upserts each extracted obligation into a Google Sheets “Obligations” tab. Runs daily at 9 AM to read the Contracts register, detects upcoming/overdue notice milestones (90/60/30 days and overdue), posts Slack messages with Renew/Terminate buttons, and marks each sent milestone in Google Sheets. Runs daily at 9 AM to read open obligations from Google Sheets, compiles items due within 7 days (or overdue), and posts a Slack digest. Receives Renew/Terminate clicks via a webhook, validates a one-time approval token against Google Sheets, records the decision, then either posts a renewal confirmation to Slack or drafts a termination notice with OpenAI and saves it as a Gmail draft before notifying Slack. Setup Create a Google Sheet with tabs named “Contracts” and “Obligations” and ensure the column headers match the fields used by the workflow (for example contract_id, decision_deadline, approval_token, and obligation_id). Connect credentials for Google Drive, Google Sheets, Slack, Gmail, and OpenAI, and add a LlamaCloud API key using HTTP Header Auth (Authorization: Bearer …). Replace all placeholders for the Google Drive folder ID, Google Sheet ID, and Slack channel ID, and set your public n8n base URL in the renewal milestone link builder so Slack buttons point to your webhook. Copy the production webhook URL for the contract decision webhook and ensure it is reachable from Slack button clicks (including any firewall/SSO requirements). Upload a sample contract PDF to the watched Drive folder and verify that the contract register, obligations sheet, Slack messages, and Gmail draft creation behave as expected. An n8n automation workflow template by Rahul Joshi.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• google-sheets
• http-request
• slack
• google-drive
• gmail
• code
• openai

Capabilities

• 7 nodes

Information