PubMed Scraper: Articles, Abstracts & Evidence Table to Excel
pubmed_evidence_tableSearch PubMed with query strings and filters, then generate a screening-ready evidence table with PMIDs, study design, sample size, retraction status, PRISMA counts, and Excel export.
Instructions
Use this to search PubMed and get a screening-ready evidence table. Input: PubMed query strings plus optional date and study-design filters. Output: one row per article with PMID, journal, study design, sample size and retraction status, plus PRISMA counts and Excel.
Runs the Apify Actor pandadad0214/pubmed-evidence-table (https://apify.com/pandadad0214/pubmed-evidence-table) on your own Apify account. Price: $0.004 per article found. Runs that find nothing are not charged per result. Spending is capped per call by run_max_charge_usd.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dateTo | No | Published to. Optional. 2025, 2025-12 or 2025-12-31. | |
| sortBy | No | Order. Order of the table. PubMed best match or most recent first. Choices: relevance = Best match (PubMed relevance); newest = Most recent. | relevance |
| queries | Yes | PubMed search strings. One or more PubMed queries, written exactly as you would in PubMed (field tags like [tiab], [mh], [pt] and AND / OR / NOT work). Records found by more than one query are counted once and reported as duplicates. | |
| dateFrom | No | Published from. Optional. 2020, 2020-06 or 2020-06-30 (publication date). | |
| languages | No | Languages. Optional, e.g. english, spanish. Leave empty for all. | |
| maxResults | No | Maximum articles. You pay per returned article ($0.004 each), so this also caps the cost. Counts for everything not included are still reported. Whole number, 1 to 10,000 results; default 200. | |
| hasAbstract | No | Only records with an abstract. Removes records without an abstract (often letters, editorials and older records). Default: off. | |
| contactEmail | No | Contact email for NCBI / Crossref (optional). Sent to NCBI and Crossref as the contact for this tool. Leave empty to use ours. | |
| studyDesigns | No | Study designs. Keep only these designs (PubMed publication types / MeSH). Leave empty for all. | |
| citationStyle | No | Citation style. Style for the citation column and the CITATIONS file. Formatted by citeproc-js with the official CSL style. Choices: vancouver = Vancouver (NLM); apa = APA 7th edition; ieee = IEEE; harvard = Harvard (Cite Them Right); chicago = Chicago author-date; mla = MLA 9th edition. | vancouver |
| run_max_items | No | Optional. Most results to return from this call (default from PANDA_MAX_ITEMS, 50). Also limits how many results the Actor produces and charges for, unless you set its own max field. | |
| excludePreprints | No | Exclude preprints. Removes records with the Preprint publication type. Default: off. | |
| freeFullTextOnly | No | Free full text only. Keep only records PubMed links to a free full text. Default: off. | |
| includeAbstracts | No | Include abstracts. Include the abstract in the table and import files (recommended for screening). Default: on. | |
| run_timeout_secs | No | Optional. Seconds to wait for results (default from PANDA_TIMEOUT_SECS, 120; max 300). | |
| excludeAnimalOnly | No | Exclude animal-only studies. Removes records indexed with Animals but not Humans. Records not yet indexed are kept. Default: off. | |
| retractedArticles | No | Retracted articles. Flag keeps them in the table, marked FIX (charged as returned articles). Exclude removes them before they are returned (not charged) and counts them in PRISMA. Choices: flag = Flag them (FIX); exclude = Exclude them. | flag |
| run_max_charge_usd | No | Optional. Hard spending cap for this call in USD (default from PANDA_MAX_CHARGE_USD, 0.50). |