Importing leads and trials from HubSpot using Zapier

Pushing lead and trial data to ChartMogul from your customer relationship management (CRM) software enables you to track metrics such as Leads and Trial-to-Paid Conversion Rate. Use Zapier to automatically send leads and trials to ChartMogul from HubSpot.

Here's what we cover in this article:

Resources and further reading:

Before you begin

Step 1 — Set up a trigger

  1. Login to Zapier and click + Create Zap.
  2. Choose HubSpot as your trigger app, and select New Contact as the Trigger Event. Click Continue.
  3. Select your HubSpot account and click Continue.
  4. Confirm the properties you'd like to retrieve with the trigger and click Continue.

Step 2 — Set up Formatter by Zapier

  1. Choose Formatter by Zapier as your app, and select Date / Time as the event. Click Continue.
  2. Within Set up action enter the following details, then click Continue:
    • Transform — select Format
    • Values — select Created At as the input
    • To Format — select YYYY-MM-DD (2006-01-22)
    • To Timezone — UTC (default)
    • From Format — select X (1137971045)
    • From Timezone — UTC (default) 
  3. Click Continue. If successful, a date/time transform will be sent to Formatter by Zapier.

Step 3 — Create a customer in ChartMogul

  1. Click + to add an action. Choose ChartMogul as your app, and select Create a Customer as the Action event. Click Continue.
  2. To set up the action, enter the following details:
    • Data Source UUID— find your UUID by navigating to Data Platform > Data Sources > and selecting   Settings for the data source you want to use.  
    • Customer Name — Contact information: First Name, Contact information: Last Name 
    • External ID — Contact information: Email
    • Customer Email — Contact information: Email
    • Lead Created at — Created At
    • Free Trial Started at — Created At, or choose the formatted date field that best suits your needs. This can include custom fields you've created as long as the value is a date. To format any additional dates you would like to use, you may need to add an additional action using the Formatter by Zapier app.
  3. Then, test the action. 
  4. If the test is successful, click Turn on Zap. The Zap will import new leads and trial HubSpot accounts into ChartMogul.
When a customer converts from a free trial to a paying customer, a duplicate customer record will be created in ChartMogul from your billing system. When this happens, we recommend merging the trial customer record with the new customer record. You need to complete this step to report trial to paid conversion rates. 

We'd love to hear how you use Zapier. Contact us to share feedback and ideas for integrations.

Was this article helpful?