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.