Extract legal contract data & send alerts with VLM run, Google Workspace & Slack

📜 AI-Powered Contract Management Pipeline (Google Drive + VLM Run + Sheets + Calendar + Slack)

⚙️ What This Workflow Does

This workflow automatically extracts, organizes, and tracks legal contract details from documents uploaded to Google Drive. Using VLM Run’s Execute Agent, it parses key metadata such as contract ID, parties, dates, and terms — then stores, alerts, and schedules reminders through Google Sheets, Calendar, and Slack.

🧩 Requirements - Google Drive OAuth2 for monitoring and downloads - VLM Run API credentials with Execute Agent access - Google Sheets OAuth2 for structured record storage - Google Calendar OAuth2 for key date reminders - Slack API credentials for team notifications - A reachable Webhook URL (for receiving parsed contract data)

⚡Quick Setup

1. Configure Google Drive OAuth2 and create upload folder and folder for saving extracted images. 2. Install the verified [VLM Run node](https://www.npmjs.com/package/@vlm-run/n8n-nodes-vlmrun) by searching for VLM Run in the node list, then click Install. Once installed, you can start using it in your workflows. 3. Add VLM Run [API credentials](https://app.vlm.run/dashboard) for document parsing. 4. Configure Google Sheet and Calendar. 5. For Google Sheet, from the document list, pick your Google Sheet (e.g., test). Then select the sheet inside it (e.g., Sheet1).

6. Set the operation to Append Row — this will add new contract details as new rows.

7. Turn on Map Each Column Manually. Match each contract field (like Contract ID, Title, Parties, Effective Date, Termination Date) to its corresponding column in your Google Sheet.