{"product_id":"daily-generic-drug-opportunity-scoring-with-n8n-claude-airtable-whatsapp","title":"Daily Generic Drug Opportunity Scoring with n8n, Claude, Airtable \u0026 WhatsApp","description":"\u003ch3\u003eDaily Generic Drug Opportunity Scoring—Patent + Orange Book signals, scored and alerted via Airtable \u0026amp; WhatsApp\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every day to aggregate patent expiry, FDA Orange Book exclusivity, ANDA\/Paragraph IV filings, and market revenue data—then calculates a weighted \u003cstrong\u003e0–100 Generic Opportunity Score\u003c\/strong\u003e, logs results in \u003cstrong\u003eAirtable\u003c\/strong\u003e, and sends \u003cstrong\u003eWhatsApp\u003c\/strong\u003e alerts for BD action.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily (7am) or on-demand\u003c\/strong\u003e: scheduled execution loads configuration values (API URLs, score thresholds, Airtable\/WhatsApp targets) and supports manual testing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches and combines multiple data sources\u003c\/strong\u003e via HTTP requests: patent expiry, FDA Orange Book exclusivity, ANDA\/Paragraph IV filing activity, and market revenue estimates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes a weighted Generic Opportunity Score (0–100)\u003c\/strong\u003e for each drug\/NDA by joining datasets and applying the configured scoring logic.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAdds correlation flags\u003c\/strong\u003e such as first-mover windows and litigation risk signals to improve BD decision context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes items by priority\u003c\/strong\u003e (high, watch, low) using configured threshold rules.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFor high-priority candidates\u003c\/strong\u003e, uses \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e to generate a structured business-development report, then \u003cstrong\u003eupserts the report into Airtable\u003c\/strong\u003e and \u003cstrong\u003esends a WhatsApp alert\u003c\/strong\u003e to the BD lead.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles acknowledgement and re-scoring\u003c\/strong\u003e: waits for BD acknowledgement via a resume webhook, enforces a grace period, re-fetches competitive filings, re-scores, and then escalates or closes via WhatsApp messaging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFor watch-tier items\u003c\/strong\u003e, upserts watch entries in Airtable and sends a WhatsApp notice, followed by a run digest summarizing processed opportunities.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily BD pipeline triage for \u003cstrong\u003egeneric drug opportunities\u003c\/strong\u003e based on patent expiry and FDA exclusivity changes.\u003c\/li\u003e\n  \u003cli\u003eAutomated monitoring of \u003cstrong\u003eANDA\/Paragraph IV\u003c\/strong\u003e filing movement to flag emerging competitive windows.\u003c\/li\u003e\n  \u003cli\u003eStructured BD report creation with \u003cstrong\u003eClaude\u003c\/strong\u003e and centralized tracking in \u003cstrong\u003eAirtable\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes and logic: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eData ingestion: HTTP requests to fetch patent expiry, Orange Book exclusivity, ANDA\/Paragraph IV filings, and revenue estimates.\u003c\/li\u003e\n  \u003cli\u003eLLM generation: \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e for structured BD reports.\u003c\/li\u003e\n  \u003cli\u003eStorage \u0026amp; logging: \u003cstrong\u003eAirtable upserts\u003c\/strong\u003e for high and watch tiers.\u003c\/li\u003e\n  \u003cli\u003eNotifications \u0026amp; escalation: \u003cstrong\u003eWhatsApp\u003c\/strong\u003e, plus acknowledgement handling via a \u003cstrong\u003eresume webhook\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45931013603507,"sku":"N8N-18973","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/q5KEa2-r4GxFxFACOxj5k_0cCOsvhf.png?v=1788253797","url":"https:\/\/buyflowscripts.com\/products\/daily-generic-drug-opportunity-scoring-with-n8n-claude-airtable-whatsapp","provider":"N8N Commerce","version":"1.0","type":"link"}