Qualify sponsorship leads and send proposals with GPT-4o, Google Sheets and Gmail
Needs changesWhat this workflow does
This AI workflow has 12 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects OpenAI Chat Model, Google Sheets, Gmail and Telegram.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Normalize Input (Edit Fields (Set)): sets 7 fields: companyName, contactName, email…
- Validate Enquiry Contact (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Shape Output (Code): runs custom JavaScript code
- Log to Sponsorship CRM (Google Sheets): append
- Route by Sponsorship Fit (Switch): routes items into 3 branches
- Send Fast-Track Proposal Email (Gmail): uses Gmail
- Send Standard Info Pack Email (Gmail): uses Gmail
- Alert Sales Lead (High Fit) (Telegram): uses Telegram
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent - Qualify Sponsorship Fit (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent - Qualify Sponsorship Fit (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Switch
n8n-nodes-base.switch - Gmail
n8n-nodes-base.gmail - Telegram
n8n-nodes-base.telegram
From the author
Quick overview This workflow receives sponsorship inquiries via a webhook, uses OpenAI GPT-4o to qualify sponsor fit and draft a proposal opening, logs the lead to Google Sheets, then sends follow-up emails via Gmail and alerts your sales lead in Telegram for…