ℹ️ Available on all plans.
Track revenue goals, such as MRR or new customers, with your payment data from Stripe.
Perdoo doesn't connect to Stripe directly. Instead, pull your Stripe data into Google Sheets with Stripe Sync, and link your goals to the cells you need.
💡 A spreadsheet lets you adjust your Stripe data with formulas before it updates your goals.
Before you start
Connect the Google Sheets integration in Perdoo, or install the Google Sheets Add-on.
Pull Stripe data into Google Sheets
Make a copy of the Stripe Sync spreadsheet.
In Stripe, go to Developers > API keys and copy your live Secret key.
In your copy of the spreadsheet, go to Extensions > Stripe Sync > Setup.
Enter your Secret key, and choose the Granularity, Initial load, and Metrics. Click Save.
Select the cell where the data should go, and go to Extensions > Stripe Sync > Initial Load. Click Run.
To keep the data up to date, go to Extensions > Stripe Sync > Schedule Sync, and choose how often, for example every hour.
To use the data in another spreadsheet, use =IMPORTRANGE("spreadsheet URL", "sheet1!A1:A1") and click Allow access.
Update your goals with Stripe data
Link each goal to the cell with its value. With the Google Sheets integration, open the goal, click Progress driver, and select the cell. With the Google Sheets Add-on, link the data to the Goal Progress cells of the goals you imported.
Good to know
How often are my goals updated?
Your spreadsheet refreshes as often as you set it up in Stripe Sync. Perdoo then fetches the value as often as the goal's sync frequency says.
Need help?
Start a live chat with our Support team by clicking on the ? at the bottom left or bottom right of your screen.