Process ADR intake and PV cases with Claude AI and Google Sheets

About

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 database, and triggers expedited regulatory alerts for serious/unexpected events. How it works Ingest ADR Report - Webhook receives ADR submission from patient/HCP portal or email parser Validate & Normalize - Checks ICH E2B(R3) required fields