Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

Automatically Create HubSpot Contacts from Leads

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Automation

To start automating your HubSpot CRM with Google Sheets, you need to access Pabbly Connect. Begin by navigating to the Pabbly Connect website at pabbly.com/connect. Here, you can either sign up for a free account or log in if you’re an existing user.

Once logged in, you will be directed to the workflow page. This is where you can create a new automation workflow. Pabbly Connect allows you to integrate multiple applications seamlessly, making it the ideal choice for automating your tasks.

2. Creating a Workflow in Pabbly Connect

In this step, you will create a workflow that triggers when a new lead is added to Google Sheets. Select Google Sheets as your trigger application in Pabbly Connect. Choose the event as “New or Updated Spreadsheet Row” to initiate the workflow.

Select Google Sheets as the trigger application.
Choose the event: New or Updated Spreadsheet Row.
Build the connection to Google Sheets.

After selecting the trigger, Pabbly Connect will provide you with a webhook URL. This URL is essential for connecting Google Sheets with Pabbly Connect, allowing it to automatically fetch data whenever a new entry is made.

3. Configuring Google Sheets to Work with Pabbly Connect

Now, navigate to your Google Sheets where you have your leads listed. To integrate with Pabbly Connect, you need to set up the webhook URL. Go to Extensions, select Add-ons, and find Pabbly Connect Webhooks.

Access Extensions > Add-ons > Get Add-ons.
Search for Pabbly Connect Webhooks and install it.
Select Initial Setup to paste the webhook URL.

In the Initial Setup dialog, enter the webhook URL and specify the trigger column, which is the last column of your data (e.g., column D). After submitting, your Google Sheets will be ready to send data to Pabbly Connect.

4. Adding Leads to HubSpot CRM via Pabbly Connect

With your Google Sheets set up, the next step is to add leads to HubSpot CRM. In Pabbly Connect, select HubSpot CRM as your action application. Choose the event as “Create a Contact” to add new leads automatically.

To build the connection, click on “Add New Connection” and select your HubSpot account. Once connected, you will see various fields to fill in. Here, you will use the mapping feature to automatically fill in the contact details from the Google Sheets data.

Map the email address from Google Sheets to HubSpot.
Map the first name, last name, and phone number accordingly.
Click “Save and Send Test Request” to finalize the integration.

Upon successful mapping, you will receive a positive response confirming that the contact has been created in HubSpot CRM. This demonstrates how Pabbly Connect automates the entire process, saving you time and effort.

5. Conclusion: Streamlining Your Business with Pabbly Connect

In this tutorial, you learned how to automate the process of adding leads from Google Sheets to HubSpot CRM using Pabbly Connect. This integration not only saves time but also reduces manual errors, allowing you to focus on more important tasks.

By following the steps outlined, you can easily set up similar automations for other applications, enhancing your business efficiency. Start using Pabbly Connect today to streamline your operations and improve productivity!