Import financial data from ProfitWell to Google Sheets

Business Benefits

Use your financial data to assess the performance of your marketing funnel.


Create a new JSON Client importer to pull Monthly Recurring Revenue (MRR).

Go through the authentication and set a request header with the value of your token.

Go to the API Keys/Dev Kit tab and copy your private token.

Set the URL query string to metrics: recurring_revenue.

Configure your data to update automatically, save, and run the importer.

Perform similar actions to pull the information about canceled subscriptions, churn rate, and APRU.

Use this data to calculate MRR Growth, MRR EOM, and EOM MRR Growth.

Last edited by @hesh_fekry 2023-11-14T11:10:32Z