Automate marketing leads import from Google Sheets to Airtable CRM

🎯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:

1. Reading leads for which email address validity has been verified. 2. Creating or updating company information. 3. 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