Track tenant document compliance with GPT-4, Drive, Sheets, email and Slack
Ready for 3.0What this workflow does
This AI workflow has 14 nodes and runs when an HTTP GET request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Drive, OpenAI, Google Sheets and Slack.
How it runs
Trigger: When an HTTP GET request hits its webhook URL (plus 1 other trigger).
- Workflow Configuration (Edit Fields (Set)): sets or maps fields
- Read Compliance Data (Google Sheets): uses Google Sheets
- Normalize Tenant Data (Edit Fields (Set)): sets or maps fields
- Aggregate: combines items into one
- Upload to Google Drive (Google Drive): uses Google Drive
- Send Compliance Report (Send Email): sends an email over SMTP
- Check Document Completeness (OpenAI): uses OpenAI
- Log Document Status (Google Sheets): uses Google Sheets
- Check Completeness Status (Switch): routes items into branches
- Send Reminder Email (Send Email): sends an email over SMTP
…plus 2 more steps. See the full node list below.
Services it uses
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 (11)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Google Drive
n8n-nodes-base.googleDrive - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets - Switch
n8n-nodes-base.switch - Send Email
n8n-nodes-base.emailSend - Wait
n8n-nodes-base.wait - Slack
n8n-nodes-base.slack - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Aggregate
n8n-nodes-base.aggregate
From the author
Who’s it for Property management teams handling leases, IDs, and compliance documents. What it does Automates document validation, reminders, escalation, and compliance reporting using AI and Google Sheets. How it works Uploaded documents are analyzed for…