Generate tender eligibility summaries and bid checklists with Gemini and Google Sheets

by WeblineIndia ✓ · 128 views · created 2026-06-08 · Market Research, AI Summarization

What this workflow does

This AI workflow has 20 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, Supabase, Google Gemini and Slack and 1 more.

How it runs

Trigger: On a schedule (every day).

1. Seed Dummy Tender Dataset (Edit Fields (Set)): sets 1 field: data
2. Normalize Tender Records (Code): runs custom JavaScript code
3. Enrich Tender Metadata (Edit Fields (Set)): sets 6 fields: duplicate_key, checklist_status, match_score…
4. Lookup Tender in Google Sheets (Google Sheets): uses Google Sheets
5. Lookup Tender in Supabase (Supabase): get many
6. Consolidate Duplicate Check Results (Merge): merges the data from its input branches
7. Filter New Tender Records (If): checks a condition and branches into true / false
8. Build AI Tender Analysis Payload (Code): runs custom JavaScript code
9. Generate Tender Eligibility and Bid Checklist (Google Gemini): uses Google Gemini
10. Combine Tender Source and AI Analysis (Merge): merges the data from its input branches

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

Services it uses

Google SheetsSupabaseGoogle GeminiSlackGmail

Before you upgrade to n8n 3.0

Nodes used (10)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• Supabasen8n-nodes-base.supabase
• Mergen8n-nodes-base.merge
• Ifn8n-nodes-base.if
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Slackn8n-nodes-base.slack
• Gmailn8n-nodes-base.gmail

From the author

Quick overview This scheduled workflow ingests tender records, checks Google Sheets and Supabase for duplicates, uses Google Gemini to generate an eligibility summary, match score, and bid checklist, then stores the tender and checklist data and alerts the…

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