Generate clinical guideline reports with Google Sheets, Gemini and Docs

by Hiroyuki Yamasaki ✓ · 10 views · created 2026-07-14

What this workflow does

This AI workflow has 21 nodes and runs on a schedule (every hour). Along the way it connects Google Sheets, Google Gemini Chat Model and Google Docs. It also calls api.search.brave.com over HTTP.

How it runs

Trigger: On a schedule (every hour).

1. Get Pending Guideline Request (Google Sheets): uses Google Sheets
2. Mark Request as Processing (Google Sheets): update
3. Analyze Clinical Question (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model; output parser: Structured Output Parser
4. Get Trusted Sources (Google Sheets): uses Google Sheets
5. Match Trusted Sources (Code): runs custom JavaScript code
6. Search Trusted Sources (HTTP Request): calls api.search.brave.com
7. Normalize Search Results (Code): runs custom JavaScript code
8. Classify Evidence Candidates (Code): runs custom JavaScript code
9. Select Current Guideline (Code): runs custom JavaScript code
10. Fetch Guideline Metadata (HTTP Request): calls an HTTP API

…plus 7 more steps. See the full node list below.

Services it uses

Google SheetsGoogle Gemini Chat ModelGoogle Docs

HTTP calls to: api.search.brave.com

Before you upgrade to n8n 3.0

Nodes used (8)

• Google Sheetsn8n-nodes-base.googleSheets
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Coden8n-nodes-base.code
• Google Docsn8n-nodes-base.googleDocs
• Schedule Triggern8n-nodes-base.scheduleTrigger
• HTTP Requestn8n-nodes-base.httpRequest

From the author

Quick overview Automatically generates structured clinical guideline reports from Google Sheets requests. The workflow analyzes clinical questions with Gemini, searches trusted guideline sources using Brave Search, identifies the most relevant official…

View the original on n8n.io → Check your own copy