Standardized workflow design pattern with color-coding system for teams
Ready for 3.0What this workflow does
This workflow has 14 nodes and runs manually, when you click “Execute workflow” (plus 2 other triggers). Along the way it connects Airtable and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 2 other triggers).
- Normalize Manual Trigger (Edit Fields (Set)): sets or maps fields
- Trigger | Normalized (Edit Fields (Set)): sets or maps fields
- Normalize Webhook Trigger (Edit Fields (Set)): sets or maps fields
- Set Defaults (Edit Fields (Set)): sets 2 fields: googleDocId, googleSheetId
- Search records (Airtable): search
- Get Data From Google Sheets (Google Sheets): uses Google Sheets
- Input | Combined (Merge): merges the data from its input branches
- Switch: routes items into 2 branches
- Business Logic Single or Multi step (Code): runs custom JavaScript code
- Business Logic Single or Multi step (Code): runs custom JavaScript code
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)
- Manual Trigger
n8n-nodes-base.manualTrigger - Merge
n8n-nodes-base.merge - Airtable
n8n-nodes-base.airtable - Edit Fields (Set)
n8n-nodes-base.set - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Webhook
n8n-nodes-base.webhook - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - No Operation, do nothing
n8n-nodes-base.noOp - Switch
n8n-nodes-base.switch
From the author
Objective This template helps you create clean, structured, and visually understandable workflows that are easy to read, present to clients, and collaborate on with teams. Whether you're onboarding a client, building reusable automations, or working across a…