🤝 Automate marketing leads import from Google Sheets to Airtable CRM
⚡ 478 views · 🤝 CRM & Sales Operations
Description
🎯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 Tables: This approach eliminates the need for reading/writing operations on a Google Sheet file or an external database.
🧩 It is structured on 3 main key steps:
- Reading leads for which email address validity has been verified.
- Creating or updating company information.
- Generating of execution report.
This workflow enables precise tracking of marketing actions while facilitating the historical record of interactions with prospects and clients.
Prerequisites
Leads file:
A prior validation check on email address accuracy is required.
Airtable:
Must contain at least a Company table with the following fields:
- Company: company name
- Business Leader: name of the executive
- Activity: business sector (notary, accountant, plumber, electrician, etc.)
- Address: main company address
- Zip Code: postal code
- City: city
- Phone Number: phone number
- Email: email address of a manager
- URL Site: company website URL
- Opt-in: company’s consent for commercial prospecting
- Campaign: reserved for future marketing campaigns
- Valid Email: indicator confirming email verification
⚙️ Step-by-Step Description
1️⃣ Initialization and Lead Selection
Data Table Initialization: An internal n8n table is created to build the execution report.
Lead Selection: The workflow selects leads from the Google Sheet file (Sheet1 tab) where the condition “Valid Email” is equal to OK.
2️⃣ Iterative Loop
Company Existence Check: The Search Company node is configured with Always Output Data enabled. A JavaScript code node distinguishes three possibilities:
-
Company does not exist: create a new record and increment the created records counter.
-
Company exists once: update the record and increment the updated records counter.
-
Company appears multiple times: log the issue in the Leads file under the Logs tab, requiring a data quality procedure.
3️⃣ Execution Report Generation
An execution report is generated and emailed, example format: Leads Import Report:
- Number of records read: 2392
- Number of records created: 2345
- Number of records updated: 42
If the sum of records created and updated differs from the total records read, it indicates the presence of duplicates. A counter for duplicated companies could be added.
✅ Benefits of this template
- Exception Management and Logging: Identification and traceability of inconsistencies during import with dedicated logs for issues.
- Data Quality and Structuring: Built-in checks for duplicate detection, validation, and mapping to ensure accurate analysis and compliance.
- Automated Reporting: Systematic production and delivery of a detailed execution report covering records read, created, and updated.
📬 Contact
Need help customizing this (e.g., expanding Data Tables, connecting multiple surveys, or automating follow-ups)?
📧 smarthome.smartelec@gmail.com 🔗 guy.salvatore 🌐 smarthome-smartelec.fr
🔗 Nodes Used
Airtable, Google Sheets, Gmail, Data table
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File