Workflow for two-way sync between Airtable and HubSpot

Who's it for This template is for sales teams, marketing operations (M-Ops), or freelancers who use Airtable as a "control panel" or staging area for new leads. If you're tired of manually copying and pasting approved leads into HubSpot, this workflow automates the entire process for you.

How it works This workflow runs on a schedule (e.g., every 5 minutes) to check for new leads.

1. Before: Your Airtable has new leads with a '📥 New Lead' status. 

2. The Trigger: You (or a teammate) manually review and change a lead's status to '👍 Ready to Sync'.  3. The Workflow Runs: n8n fetches all leads in that view (up to 50 at a time) and loops through them one by one. For each lead, it: Finds (or creates) a Company in HubSpot based on the email domain. Creates (or updates) a Contact in HubSpot based on the email. Automatically associates that Contact with that Company.

4. After: The workflow automatically updates the same Airtable row with the new HubSpot IDs and a '✅ Synced' status, completing the 2-way sync.  This template includes a full batch-processing loop, robust error-handling (it logs failures back to Airtable), and detailed sticky notes to guide you.

How to set up Setup should take less than 10 minutes. All detailed instructions are in the sticky notes inside the workflow.

1. Copy the Airtable Base: This is a mandatory first step! You must use this template. ➡️ [Click Here to Copy the Base Template](https://airtable.com/appthZgrzxKzQPEYa/shrRoRtIXoL1tlDVv) (First time using Airtable? [Sign up here with my link](https://airtable.com/invite/r/Isr7G94S))

2. Add Your Credentials: [How to connect Airtable to n8n (Video)](https://www.youtube.com/watch?v=xFFfkBeI2rQ) [How to connect HubSpot to n8n (Video)](https://www.youtube.com/watch?v=KzP52kRsRrk)