Automate marketing leads import from Google Sheets to Airtable CRM
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 workflow has 18 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Gmail, Airtable and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Insert row (Data table): uses Data table
- Get row(s) Leads (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Limit: keeps the first few items
- Get row(s) (Data table): get
- Get row(s) (Data table): get
- Update row(s) (Data table): update
- Send a message (Gmail): uses Gmail
- Search Company (Airtable): search
- Code: runs custom JavaScript code
…plus 7 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)
- Manual Trigger
n8n-nodes-base.manualTrigger - Data table
n8n-nodes-base.dataTable - Limit
n8n-nodes-base.limit - Gmail
n8n-nodes-base.gmail - Wait
n8n-nodes-base.wait - Airtable
n8n-nodes-base.airtable - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
🎯General Principles This workflow automates the import of leads into the Company table of a CRM built with Airtable. Its originality lies in leveraging the new "Data Table" node (an internal table within n8n) to generate an execution report. 📚 Why Data…