Our integrations meet your team where they are by bringing all the tools you already use into Perdoo. Stripe is a payment processor that allows business owners to accept payments from credit and debit cards.
You can use the Perdoo Google Sheets Add-on or Perdoo Google sheets integration to easily update your goals with your Stripe data.
Enable a Google Sheets integration
If you haven't already, install our Google Sheets Add-on or enable our Google sheets integration.
Pull Stripe data into your Google Sheet
Log into your Google Drive account, and make a copy of this Google Sheet.
To find your Stripe secret key, log in to your Stripe account.
Click Account from the top-right corner of the page, then Account Settings.
Click the API Keys from the top tabs. Here, you will need the Live Secret Key:
Return to your copied Stripe Sync spreadsheet.
From the navigation menu, click Extensions > Stripe Sync > Setup:
In the pop-up window that appears, enter your Live Secret Key, Granularity, Initial load and Metrics where prompted:
Click Save.
Select a cell in your spreadsheet where you want balance data to be written.
Click Extensions > Stripe Sync > Initial Load:
Click Run.
Link goals from your Stripe Sync spreadsheet to the one you want to sync with Perdoo.
Open your Google Sheet.
In an empty cell, enter "=IMPORTRANGE".
In parenthesis, add the following specifications in quotation marks and separated by a comma*:
- The URL of the spreadsheet in Sheets.
- The sheet name and the range of cells to import
Example: =IMPORTRANGE("https://docs.google.com/spreadsheets/d/stripesync", "sheet1!A1:A1")Press Enter and click Allow access to connect the 2 spreadsheets:
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.
To schedule the values to sync automatically (for example, every hour), click Add-ons > Stripe Sync > Schedule Sync:
Need help?
Contact our friendly Support team via the live chat at the bottom-right of your screen, or email support@perdoo.com.