How to get AEMPS Drug Shortage
Search active Spanish drug shortages on the AEMPS list. cima.aemps.es is one page of it. A run reads that public list and saves one row per shortage.
One row per shortage
A row has Product, Problem, Starts, AEMPS page. The columns are listed in the schema on this page.
New shortages from that site
Each run reads cima.aemps.es again. Put it on a schedule and the next file is the latest shortages from that site.
AEMPS Drug Shortage in Excel, Sheets, or Power BI
The rows are the same in each of those tools. The guide for the one you already use starts with a free Apify account and finishes with the file.
Schema
Examples come from the actor sample, not a live result.
| Name | Description | Example |
|---|---|---|
name | Product | PARACETAMOL |
problemLabel | Problem | Controlled |
startsOn | Starts | 2026-09-17 |
url | AEMPS page | https:/ |
nameProductPARACETAMOLQUALIGEN 1g COMPRIMIDOS EFERVESCENTES EFG problemLabelProblemControlleddistribution, limited stock startsOnStarts2026-09-17urlAEMPS pagehttps:// cima.aemps.es/ cima/ publico/ detalle.html?cn=707044