n8n Workflow: Answer FAQ with Google Sheets + Gemini

Answer FAQ questions in a public n8n chat using Google Sheets + Google Gemini (and log gaps for follow-up)

This n8n workflow turns your public chat into an FAQ-driven support assistant: it answers only from your Google Sheets FAQ using Google Gemini, and when a question isn’t covered, it automatically records it in a separate Unanswered tab for future updates.

What this workflow does

• Receives customer questions via the built-in public chat trigger.
• Loads your FAQ by reading all rows from a Google Sheets worksheet (expected columns: Question and Answer, case-insensitive variants also work).
• Builds a single FAQ context block and sends it to Google Gemini with instructions to answer only from the FAQ or mark the question as unanswered.
• Cleans the Gemini output and extracts whether the question was answered from the FAQ.
• If covered, returns the FAQ-based reply to the chat.
• If not covered, appends the question to an “Unanswered” worksheet tab and returns a fallback reply to the chat.

Use cases

• Provide instant answers to SaaS FAQs (pricing, onboarding, policies) without exposing internal docs.
• Maintain a feedback loop: unanswered questions automatically populate a Google Sheets queue for your team.
• Standardize support responses by ensuring answers come strictly from your approved FAQ source.

Technical details

• Google Sheets (OAuth2): reads the FAQ tab and appends to the Unanswered tab.
• Google Gemini (PaLM): generates responses constrained to the FAQ context.
• n8n workflow logic: uses nodes including if, set, code, and supporting UI notes (sticky note).
• Includes an LLM integration via the n8nnodes-langchain / chain LLM stack.

Set up the Google Sheets spreadsheet/worksheets for both the FAQ read and Unanswered append steps, connect your Gemini API credential, create the required “FAQ” and “Unanswered” tabs, then use the chat URL from the trigger to test.