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.
Using our Google Sheets integration, integrate with Stripe by following these steps:
Make sure you have a Google Sheets integration set up. If you don't yet, simply install our GSheets Add-on , (2) Connect a GSheet to your Perdoo account, (3) Automatically pull data from any spreadsheet and 200+ apps. You can learn more here.
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 set up via our Google Sheets integration:
Open your Google Sheet which is integrated with Perdoo.
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 step 2 of our Google Sheets integration.
To schedule the values to sync automatically (for example, every hour), click Add-ons > Stripe Sync > Schedule Sync:
And you're done!