Answer RFx sourcing event questions with Gemini and Google Sheets

Description

Quick Overview
This workflow answers RFx sourcing questions from a chat widget by combining Google Sheets event/FAQ data with Google Gemini, then scores each response for confidence and logs usage or escalations back to Google Sheets.

How it works
Receives a message from an n8n chat trigger and captures the question, timestamp, and session ID.
Classifies the requester (supplier vs internal), detects the RFx stage and question category, and extracts any referenced RFx event ID from the text.
Pulls RFx event details from Google Sheets and builds a context summary, prioritizing active events and the referenced event when provided.
Pulls FAQ rules from Google Sheets, selects the most relevant entries, and builds a role-specific prompt that includes event data, FAQ guidance, and response instructions.
Sends the prompt to Google Gemini to generate a concise, audience-adapted answer.
Scores the answer for uncertainty and sensitive topics, then appends the interaction to a Google Sheets usage log or creates a pending escalation record in a Google Sheets escalation log.

Setup
Add Google Sheets OAuth2 credentials in n8n and ensure the workflow’s Google Sheets nodes point to your spreadsheet document ID.
Create and populate a Google Sheets workbook with the required tabs: RFx_Events, FAQ_Rules, FAQ_Usage_Log, and Escalation_Log, using columns that match the fields the workflow appends.
Add a Google Gemini (Google PaLM / Gemini) API credential in n8n and assign it to the Gemini Chat Model node.
Enable and configure the n8n Chat trigger (webhook) and connect its chat/web widget to the generated endpoint so messages reach the workflow.