Our integrations meet your team where they are by bringing all the tools you already use into Perdoo. ChartMogul is a subscription analytics platform that helps businesses track, analyze, and optimize their recurring revenue metrics in real time.

You can use the Perdoo Google Sheets Add-on or Perdoo Google sheets integration to easily update your goals with your ChartMogul data.

If you haven't already, install our Google Sheets Add-on or enable our Google sheets integration.

1. Inside your Google Sheet, select Extensions then Apps Script:

2. Add a name for your Apps Script project, like "Perdoo<>Chartmogul".

3. Copy the contents of the Google Appscript here, and paste it into your new project.
​
4. Replace APITOKEN with your Chartmogul API token (this article explains how to create an API key in Chartmogul).

5. Click Save project (the floppy disk icon).

💡 Pro tip: You can edit the Appscript to add or remove data points to be pulled (more info on the Chartmogul API here).

6. Then click Run (the play button icon) to run the selected function, and check that the data appears in the Sheet you created.

7. Once you’re happy with the data, on the left side menu of the Google Appscript page, select Triggers and add a trigger to run daily so your data is up to date:

8. You’ll then be asked to confirm that you’re happy to give the permissions to access the Sheet. Click on "Review permissions" on the Authorization required pop-up, select your Google account, and click "Allow".

9. Follow the step linked for our Google Sheets Add-on or the following step linked for our Google sheets integration to update your goals in Perdoo.

Contact our friendly Support team via the in-app chat at the bottom-right of your screen, or email support@perdoo.com.