Automate conference travel approvals with Deepseek AI, Gmail and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 20 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Gmail, Google Sheets and OpenRouter Chat Model.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Workflow Configuration (Edit Fields (Set)): sets 19 fields: conferenceName, conferenceDuration, hostCountry…
- Fetch Exchange Rates (HTTP Request): calls an HTTP API
- Get Conference Details (HTTP Request): calls an HTTP API
- Parse Flight Quotes (Code): runs custom JavaScript code
- AI Email Composer Agent (AI Agent): runs an AI agent, with model: OpenRouter Chat Model; 3 tools (Calculator, Expense Analysis Tool, Flight Comparison Tool)
- Extract Currency Data (Edit Fields (Set)): sets 3 fields: exchangeRate, baseCurrency, lastUpdated
- Calculate Total Expenses (Code): runs custom JavaScript code
- Aggregate: combines items into one
- Check Budget Approval (If): checks a condition and branches into true / false
- Format Approved Email (Edit Fields (Set)): sets 3 fields: approvalStatus, budgetNote, emailPriority
…plus 5 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 (13)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge - Aggregate
n8n-nodes-base.aggregate - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - Code Tool
@n8n/n8n-nodes-langchain.toolCode - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter
From the author
Introduction Automates overseas conference approval requests to CEO. Generates emails with conference details, flight quotes, accommodation, expense breakdown, and admin procedures. Ensures consistency and saves time. How It Works Manual trigger initiates:…