{"product_id":"n8n-workflow-answer-faq-with-google-sheets-gemini","title":"n8n Workflow: Answer FAQ with Google Sheets + Gemini","description":"\u003ch3\u003eAnswer FAQ questions in a public n8n chat using Google Sheets + Google Gemini (and log gaps for follow-up)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow turns your \u003cstrong\u003epublic chat\u003c\/strong\u003e into an FAQ-driven support assistant: it answers only from your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e FAQ using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, and when a question isn’t covered, it automatically records it in a separate \u003cstrong\u003eUnanswered\u003c\/strong\u003e tab for future updates.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives customer questions\u003c\/strong\u003e via the built-in \u003cem\u003epublic chat trigger\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your FAQ\u003c\/strong\u003e by reading all rows from a Google Sheets worksheet (expected columns: \u003cstrong\u003eQuestion\u003c\/strong\u003e and \u003cstrong\u003eAnswer\u003c\/strong\u003e, case-insensitive variants also work).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a single FAQ context block\u003c\/strong\u003e and sends it to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e with instructions to answer \u003cstrong\u003eonly\u003c\/strong\u003e from the FAQ or mark the question as \u003cem\u003eunanswered\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans the Gemini output\u003c\/strong\u003e and extracts whether the question was answered from the FAQ.\u003c\/li\u003e\n  \u003cli\u003eIf covered, \u003cstrong\u003ereturns the FAQ-based reply\u003c\/strong\u003e to the chat.\u003c\/li\u003e\n  \u003cli\u003eIf not covered, \u003cstrong\u003eappends the question\u003c\/strong\u003e to an \u003cstrong\u003e“Unanswered”\u003c\/strong\u003e worksheet tab and returns a fallback reply to the chat.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProvide instant answers to SaaS FAQs (pricing, onboarding, policies) without exposing internal docs.\u003c\/li\u003e\n  \u003cli\u003eMaintain a feedback loop: unanswered questions automatically populate a Google Sheets queue for your team.\u003c\/li\u003e\n  \u003cli\u003eStandardize support responses by ensuring answers come strictly from your approved FAQ source.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth2): reads the \u003cstrong\u003eFAQ\u003c\/strong\u003e tab and appends to the \u003cstrong\u003eUnanswered\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e: generates responses constrained to the FAQ context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow logic\u003c\/strong\u003e: uses nodes including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, and supporting UI notes (sticky note).\u003c\/li\u003e\n  \u003cli\u003eIncludes an LLM integration via the \u003cstrong\u003en8nnodes-langchain\u003c\/strong\u003e \/ \u003cstrong\u003echain LLM\u003c\/strong\u003e stack.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSet 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.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761006272691,"sku":"N8N-17826","price":38.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/TS2pGm1qjzA5OjOCzDNLe_S7Bw6XdM.png?v=1785921062","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-answer-faq-with-google-sheets-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}