Sync leads between Google Sheets and HubSpot contacts

Video Introduction

Want to automate your inbox or need a custom workflow? 📞 Book a Call | 💬 DM me on Linkedin

Workflow Overview

This workflow automatically imports leads from a Google Sheets spreadsheet directly into your HubSpot account. When executed, it reads contact information from a designated spreadsheet and creates or updates corresponding contact records in HubSpot, preventing duplicates by matching on email addresses.

This automation is ideal for teams that collect leads through external forms, landing pages, or other systems that output to Google Sheets. Instead of manually copying contact information into HubSpot, this workflow handles the entire import process, ensuring your CRM stays up-to-date with minimal effort.

Key Features

• Automatically syncs contact data including email, name, company, and phone number
• Prevents duplicate records by updating existing contacts based on email addresses
• Works with any Google Sheets document containing lead information
• Can be scheduled to run automatically or triggered manually on demand

Setup Requirements

HubSpot Credentials:

1. Create a developer account at developers.hubspot.com
2. Navigate to Legacy Apps and create a new private app
3. In the Scopes tab, add these permissions:

• crm.objects.contacts.read
• crm.objects.contacts.write
• crm.objects.companies.read
• crm.objects.companies.write

4. Copy the Access Token from the Auth tab
5. In n8n, create a HubSpot credential using APP Token method and paste your token

Google Sheets: Connect your Google account to n8n when configuring the Google Sheets node.

Configuration

Update the Google Sheets node to point to your specific spreadsheet containing lead data. The HubSpot node is pre-configured to map common contact properties (Email, Company Name, Name, Phone Number). Adjust these field mappings if your spreadsheet uses different column names or if you need to sync additional contact properties.