Answer visitor questions and grow the FAQ with OpenAI, Google Sheets and Gmail
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: OpenAI (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 33 nodes and runs when a chat message arrives (plus 2 other triggers). Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: When a chat message arrives (plus 2 other triggers).
- Merge: merges the data from its input branches
- Workflow Config (Code): runs custom JavaScript code
- Demo visitor turns (Code): runs custom JavaScript code
- Build FAQ prompt (Code): runs custom JavaScript code
- Load FAQ answers (Google Sheets): work with sheet within document
- Read unanswered log (Google Sheets): work with sheet within document
- Demo verdict (mirrors AI contract) (Code): runs custom JavaScript code
- Answer from FAQ only (OpenAI): work with chat
- Cluster gaps (Code): runs custom JavaScript code
- Route verdict (Switch): routes items into 4 branches
…plus 20 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- OpenAI (legacy) in Answer from FAQ only, Draft FAQ entries: replace with OpenAI node (AI section).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| OpenAI (legacy) Answer from FAQ only, Draft FAQ entries | OpenAI node (AI section) |
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - OpenAI
n8n-nodes-base.openAi - Switch
n8n-nodes-base.switch - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
FAQ chatbot that grows its own answers — with owner approval Who it's for: site owners and support leads who want a public chat that answers from a known FAQ, never hallucinates, and gets smarter every week. How it works 1. Visitors chat via the hosted…