Build an SEO chatbot with GPT-4o-mini using your Google Sheets data

Description

Add your approved SEO Q&A pairs to a Google Sheet, activate the workflow, and share the chat URL with your team or clients. The chatbot reads your entire knowledge base on every question and answers strictly from your own content — never from outside sources. Every conversation is automatically logged to a second sheet so you can track common questions and improve your knowledge base over time. Built for SEO agencies, consultants, and marketing teams who want a branded AI assistant without hallucinated or off-brand answers.

---

What This Workflow Does

- Reads your knowledge base live — Pulls all Q&A rows from your Google Sheet on every question so answers always reflect your latest approved content - Answers strictly from your content — GPT-4o-mini is instructed to never use outside knowledge, keeping every response on-brand and accurate - Delivers an honest fallback — If a question is not covered in your sheet, the bot tells the user directly and points them to your support team instead of guessing - Maintains conversation memory — Users can ask follow-up questions naturally without repeating context, just like a real chat - Logs every exchange automatically — Appends each session ID, timestamp, question, and answer to a Chat Log sheet for analytics and gap identification - Returns the reply in real time — The answer is sent back to the chat interface instantly at the same time as it is being logged

---

Setup Requirements

Tools Needed - n8n instance (self-hosted or cloud) - OpenAI account with GPT-4o-mini API access - Google account with two Google Sheets (one for the knowledge base, one for the chat log)