Gemini + Google Sheets RFx Q&A Automation for n8n Workflows

Answer RFx sourcing questions in chat—automatically, with Gemini + Google Sheets in n8n

This n8n workflow automates RFx Q&A by pulling event and FAQ data from Google Sheets, sending a role-aware prompt to Google Gemini, then scoring the response and logging or escalating the interaction back to Google Sheets.

What this workflow does

• Receives a question via an n8n chat trigger, capturing the question text, timestamp, and session ID.
• Classifies the requester (e.g., supplier vs internal), detects the RFx stage and `question category`, and extracts any referenced RFx event ID from the message.
• Reads RFx event details from Google Sheets and builds a context summary, prioritizing active events and the referenced event when provided.
• Retrieves relevant FAQ rules from Google Sheets, selects the most applicable entries, and constructs a role-specific Gemini prompt (event data + FAQ guidance + response instructions).
• Sends the prompt to Google Gemini to generate a concise, audience-adapted answer.
• Scores the output for uncertainty and sensitive topics, then appends the result to a FAQ usage log or creates a pending escalation record in a Google Sheets Escalation Log.

Use cases

• Supplier-facing RFx portals: answer common sourcing questions instantly based on the correct active event.
• Internal procurement support: guide internal users using the same FAQ_Rules and event context.
• Audit-friendly operations: track every interaction in Google Sheets and flag uncertain or sensitive responses for escalation.

Technical details

• Integrations: Google Sheets (OAuth2) and Google Gemini (Google PaLM / Gemini API) inside n8n.
• Google Sheets tabs required: RFx_Events, FAQ_Rules, FAQ_Usage_Log, Escalation_Log (with columns matching what the workflow appends).
• n8n building blocks: if, set, code, sticky notes, and LLM handling via n8n-nodes-langchain nodes.