ETL Infusionsoft data to Google BigQuery

About Infusionsoft

Infusionsoft helps entrepreneurs and their teams grow sales, save time, improve service with CRM, sales & marketing automation, & more! Integrate your favorite payment processors into Infusionsoft so you don't need to jump between systems to run your business and make clients happy.

Learn more about Infusionsoft.

Choose what data you would like to move from Infusionsoft

ActionSequence

This pipeline can be used to request and retrieve Name and Id attribute data sets which are created under the Infusionsoft Logo > Marketing Settings > Action Sets by the user.

AffResource

This pipeline can be used to request and retrieve Aff Resources

Affiliate

This pipeline can be used to request and retrieve commission and activities data for affiliates using Callbacks, Commissions, Payouts, Running Totals, and the Activity Summary.

AssetFeed

This pipeline can be used to request and retrieve Asset Feeds

CCharge

This pipeline can be used to request and retrieve CC Charges.

CProgram

This pipeline can be used to request and retrieve Continuity Programs (Legacy call for backwards compatibility)

Learn more about what data can be integrated into your data warehouse using DataChannel in the documentation here.

‍

Steps to Integrate Infusionsoft with Google BigQuery using DataChannel

From the DataSources section select Infusionsoft as the data source.
Select your added BigQuery data warehouse as the data destination. If you have not yet added a data warehouse, go to Data Warehouse tab and add a warehouse.
Authorize DataChannel to connect to your Infusionsoft account using OAuth, similar to the process described in this Documentation page.
Click on + Data Pipeline to start adding data pipelines to your account.