Process ADR intake and PV cases with Claude AI and Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 18 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Anthropic Chat Model.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Validate and Normalize ADR Intake (Code): runs custom JavaScript code
- Wait: waits 10 minutes
- Check for Duplicate ADR Submission (Google Sheets): uses Google Sheets
- Is Duplicate — Skip or Proceed (If): checks a condition and branches into true / false
- Claude AI Medical Coding and Causality Assessment (AI Agent): runs an AI agent, with model: Claude AI Model
- Parse AI Medical Coding Output (Code): runs custom JavaScript code
- Signal Detection — Query Historical PV Database (Google Sheets): uses Google Sheets
- Compute Disproportionality Signal (PRR/ROR) (Code): runs custom JavaScript code
- Wait: waits 30 minutes
- Persist PV Case to Database (Google Sheets): append
…plus 6 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Claude AI Medical Coding and Causality Assessment (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Claude AI Medical Coding and Causality Assessment (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Send Email
n8n-nodes-base.emailSend - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
This workflow automates end-to-end pharmacovigilance (PV) case processing. It ingests ADR reports from web forms or emails, extracts and classifies events using Claude AI against MedDRA terminology, enriches with historical signal data, persists to a PV…