Score mortgage loan risk from Google Drive PDFs with OpenAI and Gmail
Ready for 3.0What this workflow does
This AI workflow has 20 nodes and runs on Google Drive events (file created) (plus 1 other trigger). Along the way it connects Google Drive, OpenAI Chat Model, Gmail and Slack.
How it runs
Trigger: On Google Drive events (file created) (plus 1 other trigger).
- Download Application PDF (Google Drive): download
- Slack: uses Slack
- Extract PDF Text (Extract from File): extracts data from a file (pdf)
- Extract Applicant Data (AI) (AI Agent): runs an AI agent, with model: GPT-4o-mini: Data Extraction; output parser: Parse Applicant Data Schema
- Score Applicant Risk (AI) (AI Agent): runs an AI agent, with model: GPT-4o-mini: Risk Scoring; output parser: Parse Risk Score Schema
- Slack: uses Slack
- Generate Lending Summary (AI) (AI Agent): runs an AI agent, with model: GPT-4o-mini: Lending Summary
- Slack: uses Slack
- Issue Underwriting Decision (AI) (AI Agent): runs an AI agent, with model: GPT-4o-mini: Final Decision; output parser: Parse Decision Schema
- Assemble Final Report (Code): runs custom JavaScript code
…plus 1 more step. 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 (10)
- Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Slack
n8n-nodes-base.slack - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Quick overview This workflow monitors a Google Drive folder for new loan application PDFs, extracts text, and uses OpenAI (GPT-4o-mini) to structure applicant data, score risk, generate a lending summary, and produce an underwriting recommendation, then…