Build a website FAQ chatbot with n8n, Google Sheets and Gemini (no vector database)

Описание и применение

Простой чат‑бот FAQ для небольших бизнесов, использующий n8n, Google Sheets и Gemini без векторной базы данных.

Задача

Small businesses need a simple FAQ chatbot that can be updated by editing a spreadsheet, without complex embeddings or vector databases.

Результат

A lightweight FAQ chatbot that avoids embeddings, allows instant updates via a spreadsheet, and captures leads with email/phone extraction.

Рабочий процесс

• Set up n8n Chat Trigger (public, webhook, response mode "When Last Node Finishes")
• Embed chat widget on website with CDN CSS/JS
• Read FAQ tab from Google Sheets
• Build knowledge base string from active rows, capped at 15,000 characters
• Detect email/phone in user message with regex
• Send prompt to Gemini AI Agent with system message containing business details and knowledge base
• Log conversation to Chat log sheet
• If contact details present, append or update Leads sheet
• Return reply text to widget

Доказательства

For a plumber, a dental clinic or a local shop with 30 to 80 frequently asked questions, that is far more machinery than the problem needs

Источник

The FAQ lives in a Google Sheet, the whole FAQ goes into the prompt on every message, and an n8n AI Agent with Gemini (free tier) answers only from it, logs every conversation and captures leads.

Источник

I cap the knowledge base at 15,000 characters as a safety valve.

Источник