Track contract renewals and obligations with LlamaParse, GPT-4o-mini and Slack
Ready for 3.0What this workflow does
This AI workflow has 35 nodes and runs on Google Drive events (file created) (plus 2 other triggers). Along the way it connects Google Drive, Google Sheets, Slack and OpenAI and 1 more. It also calls api.cloud.llamaindex.ai over HTTP.
How it runs
Trigger: On Google Drive events (file created) (plus 2 other triggers).
- Is PDF? (If): checks a condition and branches into true / false
- Read Contract Register (Google Sheets): uses Google Sheets
- Read Obligations (Google Sheets): uses Google Sheets
- Look Up Contract in Register (Google Sheets): uses Google Sheets
- Download Contract PDF (Google Drive): download
- Find Due Renewal Milestones (Code): runs custom JavaScript code
- Find Upcoming Obligations (Code): runs custom JavaScript code
- Validate Decision Token (Code): runs custom JavaScript code
- Upload PDF to LlamaParse (HTTP Request): calls api.cloud.llamaindex.ai (POST)
- Ask Renew or Terminate in Slack (Slack): uses Slack
…plus 22 more steps. See the full node list below.
Services it uses
HTTP calls to: api.cloud.llamaindex.ai
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (14)
- Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Google Drive
n8n-nodes-base.googleDrive - Code
n8n-nodes-base.code - Slack
n8n-nodes-base.slack - HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - Switch
n8n-nodes-base.switch - OpenAI
@n8n/n8n-nodes-langchain.openAi - Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook - Gmail
n8n-nodes-base.gmail
From the author
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…