Video Introduction
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: Create a developer account at developers.hubspot.com Navigate to Legacy Apps and create a new private app In the Scopes tab, add these permissions: crm.objects.contacts.read crm.objects.contacts.write crm.objects.companies.read crm.objects.companies.write Copy the Access Token from the Auth tab 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. An n8n automation workflow template by Milan Vasarhelyi - SmoothWork.
Milan Vasarhelyi - SmoothWork
web
free
Others in the same category, ranked by how often they are opened.
