Triage brand deal emails with Gmail, OpenAI, Tavily, Google Sheets and Slack
Ready for 3.0What this workflow does
This AI workflow has 20 nodes and runs on Gmail events. Along the way it connects Gmail, OpenAI, Google Sheets and Slack. It also calls api.tavily.com over HTTP.
How it runs
Trigger: On Gmail events.
- Normalize Email (Code): runs custom JavaScript code
- AI: Classify Email (OpenAI): uses OpenAI
- Parse Classification (Code): runs custom JavaScript code
- Is Sponsorship? (If): checks a condition and branches into true / false
- Label: Brand Deals (Gmail): add labels
- Research: Funding (HTTP Request): calls api.tavily.com (POST)
- Research: Past Campaigns (HTTP Request): calls api.tavily.com (POST)
- Compile Research (Code): runs custom JavaScript code
- AI: Brand Profile (OpenAI): uses OpenAI
- Parse Brand Profile (Code): runs custom JavaScript code
…plus 8 more steps. See the full node list below.
Services it uses
HTTP calls to: api.tavily.com
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.
- Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (Gmail Trigger).
Nodes used (10)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Gmail
n8n-nodes-base.gmail - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack
From the author
Quick overview This workflow monitors unread Gmail inbox emails, uses OpenAI to identify brand deal opportunities, researches the brand via Tavily, calculates a suggested rate, and creates a Gmail draft reply while logging the deal to Google Sheets and…