{"product_id":"n8n-clinical-guideline-reports-gemini-brave-google-sheets","title":"n8n Clinical Guideline Reports: Gemini + Brave + Google Sheets","description":"\u003ch3\u003eGenerate evidence-based clinical guideline reports automatically—hourly\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads pending clinical questions from Google Sheets, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to structure the request, searches trusted guideline sources via the \u003cstrong\u003eBrave Search API\u003c\/strong\u003e, and produces an \u003cstrong\u003eevidence-based clinical guidance report\u003c\/strong\u003e in Google Docs—then updates the status back in Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every hour\u003c\/strong\u003e and retrieves rows marked \u003cem\u003e“pending”\u003c\/em\u003e from a Google Sheets spreadsheet.\u003c\/li\u003e\n  \u003cli\u003eMarks the matching request row as \u003cem\u003e“processing”\u003c\/em\u003e, clearing any previous report URL, completion time, or error message.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to parse the clinical question into \u003cstrong\u003estructured medical concepts\u003c\/strong\u003e, including guideline domains and question type.\u003c\/li\u003e\n  \u003cli\u003eMatches those domains to \u003cstrong\u003eregion-prioritized trusted sources\u003c\/strong\u003e listed in a \u003cem\u003e“Trusted Sources”\u003c\/em\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eCalls the \u003cstrong\u003eBrave Search API\u003c\/strong\u003e to search the top matched trusted source domain, normalizes results, and selects the most likely \u003cstrong\u003ecurrent guideline\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFetches the chosen guideline web page and extracts publicly available metadata, chapter titles, and supporting document links (when available).\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to synthesize a \u003cstrong\u003eclinical guidance JSON report\u003c\/strong\u003e using only the provided metadata, page excerpt, and search results—clearly separating \u003cem\u003econfirmed\u003c\/em\u003e vs \u003cem\u003eunconfirmed\u003c\/em\u003e information.\u003c\/li\u003e\n  \u003cli\u003eCreates a \u003cstrong\u003eGoogle Docs\u003c\/strong\u003e document, inserts the formatted report content, and updates the original Google Sheets row to \u003cem\u003e“completed”\u003c\/em\u003e with the generated report details.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eClinical operations teams that need consistent, structured guideline summaries for incoming questions.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators building evidence-search and reporting features for healthcare-adjacent workflows.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers orchestrating an end-to-end pipeline from request intake (Google Sheets) to reporting (Google Docs).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e (hourly)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (read pending requests, update statuses)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (concept extraction + JSON clinical guidance synthesis)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBrave Search API\u003c\/strong\u003e (trusted guideline domain search)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e (fetch selected guideline page)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Docs\u003c\/strong\u003e (generate the report document)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode\u003c\/strong\u003e nodes for normalization and candidate classification\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761016856755,"sku":"N8N-17757","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/sMLwvV7CUrJ5_3PjHLT6M_vK6OHkVL.png?v=1785921606","url":"https:\/\/buyflowscripts.com\/products\/n8n-clinical-guideline-reports-gemini-brave-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}