Score and shortlist suppliers with Google Sheets, Google Gemini, and Gmail

by WeblineIndia ✓ · 27 views · created 2026-08-18 · Market Research, AI Summarization

What this workflow does

This AI workflow has 17 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets, Google Gemini Chat Model and Gmail.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

1. Get RFx Requirements (Google Sheets): uses Google Sheets
2. Find Requested RFQ (Filter): keeps only the items that match a condition
3. Normalize RFx Data (Edit Fields (Set)): sets 8 fields: Request_ID, category, country…
4. Merge: merges the data from its input branches
5. Find Matching Suppliers (Google Sheets): uses Google Sheets
6. AI Supplier Match Analysis (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
7. Merge: merges the data from its input branches
8. Parse AI Assessment (Code): runs custom JavaScript code
9. Get Supplier Intelligence (HTTP Request): calls an HTTP API (POST)
10. Merge: merges the data from its input branches

…plus 5 more steps. See the full node list below.

Services it uses

Google SheetsGoogle Gemini Chat ModelGmail

Before you upgrade to n8n 3.0

Nodes used (12)

• Google Sheetsn8n-nodes-base.googleSheets
• Edit Fields (Set)n8n-nodes-base.set
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Coden8n-nodes-base.code
• Mergen8n-nodes-base.merge
• Sortn8n-nodes-base.sort
• Limitn8n-nodes-base.limit
• Gmailn8n-nodes-base.gmail
• HTTP Requestn8n-nodes-base.httpRequest
• Webhookn8n-nodes-base.webhook
• Filtern8n-nodes-base.filter

From the author

Quick overview This workflow receives an RFx request via webhook, pulls the matching requirements from Google Sheets, finds candidate suppliers from a supplier master sheet, and uses Google Gemini plus an external supplier-intelligence API to score, rank,…

View the original on n8n.io → Check your own copy