Event Sponsor Matching with Google Sheets, GPT & Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs on a schedule (every week at 09:00). Along the way it connects Google Sheets, OpenAI and Gmail.
How it runs
Trigger: On a schedule (every week at 09:00).
- Set Workflow Variables (Edit Fields (Set)): sets 3 fields: sponsorsSheetId, packagesSheetId, logSheetId
- Fetch Sponsors Sheet (Google Sheets): uses Google Sheets
- Fetch Packages Sheet (Google Sheets): uses Google Sheets
- Loop Over Sponsors (Loop Over Items (Split in Batches)): loops over the items in batches
- Aggregate: combines items into one
- Merge: merges the data from its input branches
- Prepare AI Context (Edit Fields (Set)): sets 1 field: allPackages
- Match Packages with GPT-4o (OpenAI): uses OpenAI
- Parse AI Response (Edit Fields (Set)): sets 3 fields: aiResponse, topPackage, topScore
- Extract Top Match Rankings (Code): runs custom JavaScript code
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - OpenAI
@n8n/n8n-nodes-langchain.openAi - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Event Sponsor Matching: Google Sheets, GPT-4o & Gmail Revenue Optimizer Who is this for? Event planners, conference organizers, non-profits, and partnership managers who manage sponsor spreadsheets and want AI-powered package recommendations to maximize…