{"product_id":"gemini-google-sheets-rfx-q-a-automation-for-n8n-workflows","title":"Gemini + Google Sheets RFx Q\u0026A Automation for n8n Workflows","description":"\u003ch3\u003eAnswer RFx sourcing questions in chat—automatically, with Gemini + Google Sheets in n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automates RFx Q\u0026amp;A by pulling event and FAQ data from Google Sheets, sending a role-aware prompt to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, then scoring the response and logging or escalating the interaction back to Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReceives a question via an \u003cstrong\u003en8n chat trigger\u003c\/strong\u003e, capturing the question text, \u003cstrong\u003etimestamp\u003c\/strong\u003e, and \u003cstrong\u003esession ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eClassifies the requester (e.g., \u003cstrong\u003esupplier vs internal\u003c\/strong\u003e), detects the \u003cstrong\u003eRFx stage\u003c\/strong\u003e and `question category`, and extracts any referenced \u003cstrong\u003eRFx event ID\u003c\/strong\u003e from the message.\u003c\/li\u003e\n  \u003cli\u003eReads \u003cstrong\u003eRFx event details\u003c\/strong\u003e from Google Sheets and builds a context summary, prioritizing \u003cstrong\u003eactive events\u003c\/strong\u003e and the referenced event when provided.\u003c\/li\u003e\n  \u003cli\u003eRetrieves relevant \u003cstrong\u003eFAQ rules\u003c\/strong\u003e from Google Sheets, selects the most applicable entries, and constructs a \u003cstrong\u003erole-specific Gemini prompt\u003c\/strong\u003e (event data + FAQ guidance + response instructions).\u003c\/li\u003e\n  \u003cli\u003eSends the prompt to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to generate a concise, audience-adapted answer.\u003c\/li\u003e\n  \u003cli\u003eScores the output for \u003cstrong\u003euncertainty\u003c\/strong\u003e and \u003cstrong\u003esensitive topics\u003c\/strong\u003e, then appends the result to a \u003cstrong\u003eFAQ usage log\u003c\/strong\u003e or creates a \u003cstrong\u003epending escalation\u003c\/strong\u003e record in a Google Sheets \u003cstrong\u003eEscalation Log\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSupplier-facing RFx portals: answer common sourcing questions instantly based on the correct active event.\u003c\/li\u003e\n  \u003cli\u003eInternal procurement support: guide internal users using the same FAQ_Rules and event context.\u003c\/li\u003e\n  \u003cli\u003eAudit-friendly operations: track every interaction in Google Sheets and flag uncertain or sensitive responses for escalation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (OAuth2) and \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (Google PaLM \/ Gemini API) inside n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets tabs required:\u003c\/strong\u003e RFx_Events, FAQ_Rules, FAQ_Usage_Log, Escalation_Log (with columns matching what the workflow appends).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n building blocks:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, sticky notes, and LLM handling via \u003ccode\u003en8n-nodes-langchain\u003c\/code\u003e nodes.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46029330743475,"sku":"N8N-19610","price":63.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/CE_4b8kqw8tdGGEHFDCa-_UViL2LO8.png?v=1789463170","url":"https:\/\/buyflowscripts.com\/products\/gemini-google-sheets-rfx-q-a-automation-for-n8n-workflows","provider":"N8N Commerce","version":"1.0","type":"link"}