Automate pharmaceutical COA verification & vendor scoring with AI document analysis
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 10 nodes and runs when an HTTP GET request hits its webhook URL. Along the way it connects Airtable.
How it runs
Trigger: When an HTTP GET request hits its webhook URL.
- Load Sample COA Data (Code): runs custom JavaScript code
- Analyze Specifications (Code): runs custom JavaScript code
- Calculate Vendor Score (Code): runs custom JavaScript code
- Check Compliance Status (If): checks a condition and branches into true / false
- Generate Approval Certificate (Code): runs custom JavaScript code
- Generate Rejection Report (Code): runs custom JavaScript code
- Update Vendor Database (Airtable): create
- Send Email: sends an email over SMTP
- Generate Final Report (Code): runs custom JavaScript code
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 (5)
- Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Airtable
n8n-nodes-base.airtable - Send Email
n8n-nodes-base.emailSend - Webhook
n8n-nodes-base.webhook
From the author
This enterprise-grade n8n workflow automates the Pharmaceutical Raw Material COA Verification & Vendor Quality Scoring System — from upload to final reporting — using AI-powered document extraction, specification matching, and dynamic vendor scoring. It…