Stripe & Catchr: How to connect your data

How to connect Stripe to Catchr ?

Connecting Stripe to Catchr is the best way to make your finance data accessible wherever needed. Once achieved, you can connect to Looker Studio, Google Sheets, PowerBI, and Tableau or get a JSON or CSV feed (and if you need another platform or format, ask us in the chat !)

To connect your account to Catchr, you must have:

• The administrator role on your Stripe account
• An API key (only the administrator can create it).

If you do not have the correct level of access, you must contact an administrator to either give you the administrator role or create an API key for you.

Here is how to create your API Key: 

Finding your API Key in Stripe:

Open your Stripe account and locate the Developer link at the top right corner. Click it.

I'm using test mode here, but you must not use it to generate your API Key.

• Go to the second menu, "API Keys".
• In the Standard Keys, click Create Secret Key.

• Name your key and click Create.
• Copy your key, and do not lose it. Once the pop-up closes, Stripe won't show it again. No worries if it happens. You can create a new one.

‍Now that you have the API Key, we will create a Source on Catchr.

Create your Catchr Source

Connect to Catchr and go to Source -> Add a new Source.

Select the Stripe Integration:

Then name your Catchr Source and click Connect my account:

Finally, paste the API Key generated in the first step.

Click next and let Catchr fetch your account.

When you can see your Stripe account listed, click save. You can now find your Stripe data on all of our Destination!

Starting with Looker Studio:

For Looker Studio, follow this link to our Stripe connector and go through the authorization steps.

In the dropdown, select your Stripe account.

To start with a blank canvas, uncheck the "Use report template for the new report" checkbox.

Click Connect to create your Stripe data source in Looker Studio.

The following page lists all available fields in the Stripe connector. Click Create Report to start creating your Stripe report with Looker Studio.

If you choose to start with a blank canvas, you can find our Stripe template here.

Starting with Google Sheet:

Start by installing our Google Sheets add-on. Click install then open a new Google Sheets

Then, go to :

• Extensions -> Catchr - Data connector -> Launch.

From here, you can access all Sources created on Catchr and generate a request that will automatically import data for you. You can also set up an automatic daily refresh to keep the data updated.

Here's a complete tutorial for Stripe and Google Sheets.

Here's a Stripe template for Looker Studio.

Starting with PowerBI, BigQuery, and CSV or JSON format:

In the API menu on your Catchr space, you can create a web URL to link to PowerBI or Tableau. You can then use this web URL to fetch data automatically and update your dashboards.

To do so, select your format, then create a query.

Once done, copy the URL and Paste it to your Destination.

Here's a complete tutorial on creating a Stripe request for PowerBI (it will work the same way for Tableau).