All products › ClinicalTrials.gov Study Monitor › n8n workflow
Monitor clinical trials by condition, phase and status each morning and append new studies to Google Sheets
An n8n workflow: each morning at 7:00 (your n8n instance's time zone) it asks the ClinicalTrials.gov Study Monitor API through RapidAPI for the studies published since the day before, a call for each filter you set (condition, phase, status), and appends what is new to a Google Sheet. Rows are matched on nct_id: a studie that comes back again updates its own row (overwritten with the latest values) instead of adding a new row.
The columns are the fields the API returns: nct_id, title, sponsor, phase, status, enrollment, start_date, completion_date, last_update_date, conditions, lead_intervention, first_country. The filters sit in the Code node named Filters; updated_since is set from the run date, so no date needs editing.
Each filter makes 1 call a morning, at most 31 calls a month. The listing's free plan is 1,000 calls a month, so it covers 32 filters with no paid plan; past that, or with more calls of your own, a paid plan is needed (the listing's Pricing tab).
To run it: import the file into n8n, create a Header Auth credential named X-RapidAPI-Key that holds your RapidAPI key, choose your spreadsheet in the Google Sheets node, and give it a tab named Studies whose header row holds the column names.
Download the workflow (JSON) Get a key on RapidAPI
Columns
| Column | From the API's field |
|---|---|
nct_id | nct_id |
title | title |
sponsor | sponsor |
phase | phase |
status | status |
enrollment | enrollment |
start_date | start_date |
completion_date | completion_date |
last_update_date | last_update_date |
conditions | conditions |
lead_intervention | lead_intervention |
first_country | first_country |
The call it makes
For each filter, each morning (the key in the X-RapidAPI-Key header, from the credential):
GET https://clinical-trials-monitor-api-clinicaltrials-gov-changes.p.rapidapi.com/v1/clinical-trials-monitor?condition=breast cancer&phase=PHASE2&status=RECRUITING&updated_since=<the day before the run>&limit=100&src=n8n-clinical-trials-monitor
The src parameter tells the API which template a call came from; it is counted, never passed to the source, and can be removed.
Checked by a program each day: the nodes against n8n-nodes-base 2.43.6, the columns against the API's fields, and this call (with the day's date) replayed against the API on the company's own server, the request RapidAPI forwards there, without RapidAPI in between. Written by the company's agents from the product's record.