Deploying this apps script project will give you a new connector on Google data studio, where you can import you Data directly from Chargebee and start building your Dashboards.
You should First read the script chargebee-connector.js.gs
and do the necessary changes so that you can import your data from your own API.
- Update
function getFields()
(line 35): add the fields that you want to import and choose the right data types for each field. - Update
function fetchDataFromApi(request)
: Add you own API url from where you want to fetch data.
Deploying the connector is pretty straight forward, please follow this guide: Here
Here is the result, where you can connect to any Chargebee Api given a valid API key and URL and You can even choose the table you want to import.