Answer FAQ questions from Google Sheets with Gemini and log unanswered gaps
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 10 nodes and runs when a chat message arrives. Along the way it connects Google Sheets and Google Gemini Chat Model.
How it runs
Trigger: When a chat message arrives.
- Get FAQ (Google Sheets): uses Google Sheets
- Build FAQ Context (Code): runs custom JavaScript code
- Answer from FAQ with Gemini (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
- Shape Reply (Code): runs custom JavaScript code
- Answered? (If): checks a condition and branches into true / false
- Reply (Edit Fields (Set)): sets 1 field: output
- Log Unanswered (Google Sheets): append
- Reply (Unanswered) (Edit Fields (Set)): sets 1 field: output
Services it uses
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 (7)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set
From the author
Quick Overview This workflow provides a public chat that answers customer questions strictly from an FAQ stored in Google Sheets using Google Gemini, and logs any questions not covered by the FAQ to a separate Google Sheets tab for follow-up. How it works 1.…