1. Wicked Help Center
  2. SETUP
  3. Order Systems and Shopping Carts

Connecting ClickFunnels Orders with Zapier

Integration Steps

To accomplish this integration, you will need a Zapier account.

The integration consists of two simple steps:

Step #1 - Connect your ClickFunnels account

Step #2 - Connect your Wicked Reports account

Step #1 - Connect your ClickFunnels account

  1. Log into your Zapier account and select Make a Zap
  2. Start your Zap by selecting the ClickFunnels App
    wicked reports Connecting ClickFunnels Orders with Zapier
  3. And the New Successful Purchase Trigger Event and click Continue
    wicked reports Connecting ClickFunnels Orders with Zapier
  4. Select your click funnels account (Authorize your account if necessary) and click Continue
    wicked reports Connecting ClickFunnels Orders with Zapier
  5. Customize the Purchase settings to your preference and click Continue
    wicked reports Connecting ClickFunnels Orders with Zapier
  6. Click Test to test the connection with ClickFunnels and retreive samples data to be used in the following steps.
    wicked reports Connecting ClickFunnels Orders with Zapier

Transform the Order Total for Import

  1. Click to add a new step to your Zap
  2. Select the Formatter App
     wicked reports Connecting ClickFunnels Orders with Zapier
  3. Choose the Numbers Action Event and click Continue
    wicked reports Connecting ClickFunnels Orders with Zapier
  4. On the Customize step, choose the Perform Math Operation transformation
    wicked reports Connecting ClickFunnels Orders with Zapier
  5. Select the Divide operation and add an additional Input by clicking the Plus icon to the right of the form.
    Specify Original Amount Cents from the ClickFunnels Trigger Action in Step 1 as the first input.
    Specify Original Amount Currency Subunit to Unit from the ClickFunnels Trigger Action in Step 1 as the second input.
    Click Continue.
    wicked reports Connecting ClickFunnels Orders with Zapier
  6. Click Test and Review and confirm that the Output value has been converted from Cents to Dollars
    wicked reports Connecting ClickFunnels Orders with Zapier

Step #2 - Connect your Wicked Reports account

  1. To submit your order to Wicked Reports, choose the most current Wicked Reports App
    wicked reports Connecting ClickFunnels Orders with Zapier
  2. Select the Create Order Action Event and click Continue
    wicked reports Connecting ClickFunnels Orders with Zapier
  3. Select your connected Wicked Reports account and click Continue.
    wicked reports Connecting ClickFunnels Orders with Zapier
  4. Customize Order as shown using the following values:
    Source system-Type into field Clickfunnels
    Customer email-Search for and add Contact email from Step 1
    Order id-Search for and add charge id from Step 1
    Order total-Search for and add Output from Step 2
    Order date time-Search for and add created at from Step 1
    Order time zone-Type into field UTC-5 from Step 1 (should match your ClickFunnels account Time Zone setting)
    Product id-Search for and add Products ID from Step 1
    Product name-Search for and add Products name from Step 1
    Customer state-Search for and add Contact State from Step 1
    Customer country-Search for and add Contact Country from Step 1
    Subscription Id-Search for and add Subscription ID from Step 1 (Required for subscription orders, otherwise leave blank)
  5. Click Continue
  6. Test the zap connection.  
  7. Turn on the Zap.
  8. Check your Wicked Reports account to confirm that data is coming from the Zap correctly.