Triage PubMed clinical literature with Gemini and Google Sheets and Docs
Ready for 3.0What this workflow does
This AI workflow has 17 nodes and runs on a schedule (every hour). Along the way it connects Google Sheets, Google Docs and Google Gemini Chat Model. It also calls eutils.ncbi.nlm.nih.gov over HTTP.
How it runs
Trigger: On a schedule (every hour).
- Load Request (Google Sheets): uses Google Sheets
- Build Query (Edit Fields (Set)): sets or maps fields
- Processing Request (Google Sheets): update
- Search PubMed (HTTP Request): calls eutils.ncbi.nlm.nih.gov
- Fetch Details (HTTP Request): calls eutils.ncbi.nlm.nih.gov
- Parse PubMed XML (XML): converts between XML and JSON
- Normalize (Code): runs custom JavaScript code
- Aggregate: combines items into one
- Clinical Literature Triage (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini 2.5 Flash
- Parse AI Output (Code): runs custom JavaScript code
…plus 5 more steps. See the full node list below.
Services it uses
HTTP calls to: eutils.ncbi.nlm.nih.gov
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- XML
n8n-nodes-base.xml - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Aggregate
n8n-nodes-base.aggregate - Google Docs
n8n-nodes-base.googleDocs - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
From the author
Quick overview Automatically retrieve recent PubMed articles, identify the three papers most worth reading first using AI, and generate structured clinical literature triage reports in Google Sheets and Google Docs. How it works 1. Reads the first pending…