Answer visitor questions and grow the FAQ with OpenAI, Google Sheets and Gmail

Description

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 Visitors chat via the hosted webchat (Chat Trigger). The bot loads the FAQ sheet from Google Sheets and OpenAI answers only from it. Every turn is routed three ways: answered (reply sent), unanswered (logged to the Unanswered tab and the owner notified by Gmail), or lead (visitor left an email — captured in Leads and the owner notified). Repeats never duplicate rows. Every Monday a second lane clusters the unanswered log, ranks gaps by frequency, has OpenAI draft candidate FAQ entries, emails the owner a digest, and appends proposals to FAQ-Pending. The owner copies approved rows into FAQ — the bot only learns what a human signs off. Setup Click Test workflow — the demo lane runs six visitor turns (answerable, unanswered, lead, empty, repeat, bad AI answer) through every route with zero credentials. Attach credentials: Google Sheets, Gmail, OpenAI. Press play on the SETUP node (Lane D) — it creates the spreadsheet with all four tabs, headers and example rows, then prints the spreadsheet_id. Open the Workflow Config node and paste the id plus your owner_email. Then delete the setup lane, activate the workflow and embed the Chat Trigger's public URL in your site. Note: the Google Sheets and Gmail nodes are enabled — once credentials are attached they write real rows and send real emails. An n8n automation workflow template by Vinh Le.

Community Metrics

Categories

• Automation

Tags

• n8n
• workflow
• google-sheets
• gmail
• code
• openai

Capabilities

• 4 nodes

Information