n8n Clinical Guideline Reports: Gemini + Brave + Google Sheets

Generate evidence-based clinical guideline reports automatically—hourly

This n8n workflow reads pending clinical questions from Google Sheets, uses Google Gemini to structure the request, searches trusted guideline sources via the Brave Search API, and produces an evidence-based clinical guidance report in Google Docs—then updates the status back in Google Sheets.

What this workflow does

• Runs every hour and retrieves rows marked “pending” from a Google Sheets spreadsheet.
• Marks the matching request row as “processing”, clearing any previous report URL, completion time, or error message.
• Uses Google Gemini to parse the clinical question into structured medical concepts, including guideline domains and question type.
• Matches those domains to region-prioritized trusted sources listed in a “Trusted Sources” tab in Google Sheets.
• Calls the Brave Search API to search the top matched trusted source domain, normalizes results, and selects the most likely current guideline.
• Fetches the chosen guideline web page and extracts publicly available metadata, chapter titles, and supporting document links (when available).
• Uses Google Gemini to synthesize a clinical guidance JSON report using only the provided metadata, page excerpt, and search results—clearly separating confirmed vs unconfirmed information.
• Creates a Google Docs document, inserts the formatted report content, and updates the original Google Sheets row to “completed” with the generated report details.

Use cases

• Clinical operations teams that need consistent, structured guideline summaries for incoming questions.
• SaaS operators building evidence-search and reporting features for healthcare-adjacent workflows.
• Automation engineers orchestrating an end-to-end pipeline from request intake (Google Sheets) to reporting (Google Docs).

Technical details

• Schedule Trigger (hourly)
• Google Sheets (read pending requests, update statuses)
• Google Gemini (concept extraction + JSON clinical guidance synthesis)
• Brave Search API (trusted guideline domain search)
• HTTP Request (fetch selected guideline page)
• Google Docs (generate the report document)
• Code nodes for normalization and candidate classification