Triage Japanese freelance gig emails with Gmail, Gemini, Sheets, Drive, and Calendar
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 21 nodes and runs on Gmail events. Along the way it connects Gmail, Google Drive, Google Docs and Google Calendar and 2 more.
How it runs
Trigger: On Gmail events.
- Set config: Freelancer settings (Edit Fields (Set)): sets 12 fields: spreadsheet_id, sheet_name, calendar_id…
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
- Gemini: Analyze side gig request (Google Gemini): uses Google Gemini
- Code: runs custom JavaScript code
- Switch: routes items into 3 branches
- Sheets: Log opportunity (Google Sheets): append
- Drive: Create project folder (Google Drive): work with folder
- Gmail: work with draft
- Gmail: work with draft
…plus 10 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)
- Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Google Drive
n8n-nodes-base.googleDrive - Google Docs
n8n-nodes-base.googleDocs - Google Calendar
n8n-nodes-base.googleCalendar - Gmail Trigger
n8n-nodes-base.gmailTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Google Sheets
n8n-nodes-base.googleSheets - Switch
n8n-nodes-base.switch
From the author
Quick overview This workflow monitors Gmail for Japanese side-gig inquiries, flags risky wording, and uses Google Gemini to extract details and score each request. It logs every opportunity to Google Sheets, then drafts an accept/clarify/decline reply and,…