Optimize PubMed Searches with Google Sheets & Gemini Workflow

Optimize PubMed Searches with Google Sheets & Gemini Workflow

Efficiently transform your medical research process with our advanced n8n automation workflow, designed to streamline PubMed searches utilizing Google Sheets and Google Gemini. This powerful tool ensures that you receive the top clinically relevant papers quickly and accurately, all while updating your records seamlessly.

What this workflow does

• Runs on an hourly schedule to check for pending PubMed search requests in a specified Google Sheets “Search Requests” tab.
• Initiates the search process by marking the request as “processing” and preparing the query parameters including keyword, specialty, and clinical question.
• Fetches relevant article abstracts and metadata from PubMed using the NCBI E-utilities API.
• Converts the fetched data into a structured list containing details such as title, abstract, journal, publication year, DOI, and PubMed URL.
• Utilizes Google Gemini to rank and select the top three articles based on clinical relevance and generates structured evaluations.
• Updates Google Sheets with the ranked articles and comprehensive summaries in the “Triage Results” tab.
• Creates a formatted report in Google Docs summarizing the findings and marks the original request as “completed” in Google Sheets.

Use cases

• Medical researchers looking to efficiently manage and analyze large volumes of PubMed data for clinical trials or systematic reviews.
• Academic professionals and students who need a streamlined process for sourcing and evaluating scientific literature.
• Healthcare consultants and analysts aiming to provide data-driven insights by leveraging the latest research findings.

Technical details

• Integrates with Google Sheets to manage search requests and triage results.
• Leverages NCBI E-utilities API for accessing PubMed databases.
• Uses Google Gemini for AI-driven evaluation and ranking of articles.
• Incorporates n8n nodes such as set, xml, code, aggregate, and sticky note for efficient data processing and workflow management.
• Automatically generates Google Docs reports for easy presentation of findings.