Score generic drug opportunities with Claude, Airtable, and WhatsApp
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 31 nodes and runs on a schedule (cron 0 7 * * *) (plus 1 other trigger). Along the way it connects Airtable and WhatsApp Business Cloud. It also calls api.anthropic.com over HTTP.
How it runs
Trigger: On a schedule (cron 0 7 * * *) (plus 1 other trigger).
- Set API Configuration (Edit Fields (Set)): sets 14 fields: patentApiUrl, orangeBookApiUrl, andaFilingsApiUrl…
- Fetch Patent Expiry Data (HTTP Request): calls an HTTP API
- Fetch Orange Book Data (HTTP Request): calls an HTTP API
- Fetch ANDA Filings Data (HTTP Request): calls an HTTP API
- Fetch Market Revenue Data (HTTP Request): calls an HTTP API
- Merge: merges the data from its input branches
- Calculate Opportunity Score (Code): runs custom JavaScript code
- Analyze Cross-System Signals (Code): runs custom JavaScript code
- Route by Priority Tier (Switch): routes items into 2 branches
- Loop Over High-Priority Opportunities (Loop Over Items (Split in Batches)): loops over the items in batches
…plus 19 more steps. See the full node list below.
Services it uses
HTTP calls to: api.anthropic.com
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 (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Airtable
n8n-nodes-base.airtable - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if
From the author
Quick overview This workflow runs daily to aggregate patent expiry, FDA Orange Book exclusivity, ANDA/Paragraph IV filing, and market revenue data, score generic-drug opportunities, and then log and notify results via Airtable and WhatsApp, using Anthropic…