How to Connect Stripe to Google Data Studio

November 2, 2022

How to Connect Stripe to Google Data Studio

There is no doubt that Stripe is one of the most popular payments platforms for content businesses, and for good reason. Their simple implementation for developers and ready-made integrations with platforms such as Ghost, makes them an easy and dependable choice.

One of the great things about Stripe is their comprehensive analytics API. This means that you can access all of your Stripe data and use it to create fully customized reports and analysis. Even if you are not a developer, you can still get the benefits of Stripe’s API by using no-code data connectors.

One of our favorite ways to do that is to use Google’s free data analytics platform, Data Studio. In this article, we will see step-by-step how you can connect Stripe to Google Data Studio with no code required.

Data Studio Connectors

As we’ve already mentioned, in order to connect Stripe to Google Data Studio, we are going to use a custom connector. Google Data Studio comes with its own connectors to Google data sources like Google Analytics, which means this data can be accessed with no additional set-up.

But to get data from non-Google sources into Data Studio, Google relies on 3rd party developers to create custom connectors. There are many custom connectors out there for lots of different data sources, which you can find in Google’s connector gallery:

Google Data Studio Connector Gallery

There are a few other options for Stripe connectors, but we were not satisfied with the performance or the pricing options, so we decided to build our own.

Our Stripe connector is free to try. You can preview it for 24 hours without creating an account or entering any credit card details and you can try out our Pro plan that enables you to link up to 5 Stripe accounts at a time if you sign up for an Epilocal account.

Let’s see how you can use it to get your Stripe data flowing into Data Studio in less than 5 minutes.

Add the Stripe Connector as a Data Source

Let’s start by going to Google Data Studio and adding a new Data Source.

Google Data Studio Add Data Source

This will take us to the Data Studio connector gallery, where you can find the Stripe connector by Epilocal.

Google Data Studio Stripe Connector

Click on the connector and you will be prompted to configure it.

Stripe Connector Configuration

When you first start configuring the Stripe connector, you will be prompted to authorize your Google account. This is required because the Stripe connector needs permission to access your Data Studio account. If you have many different Google accounts, make sure that you pick the Google account you use for Data Studio.

If you are trying the connector for the first time, you will now be prompted for an API Key.

Google Data Studio Enter Stripe Key

This API Key comes from Stripe and can be found in the Developers section of your Stripe dashboard, under where it says Secret Key.

Stripe API Key

Simply copy the Stripe Secret Key and paste it into Data Studio where it asks for the key.

Next, you should see a blue Connect button in the upper right-hand corner of Data Studio that you simply click. With that, you have successfully connected your Stripe account to Data Studio.

Use Stripe Data in Data Studio

Now that you are all connected, you will have the option to select multiple data views. These are:

  • Stripe Balance Transactions (eg. any movements that affect your Stripe balance)
  • Stripe Charges (includes both successful and failed charge attempts)
  • Stripe Customers
  • Stripe Subscriptions

You can pick whichever view you want to use at a given time or you can blend them together as they have ID’s which makes joining data easy. For example, Stripe Charges are associated with a Balance Transaction ID, so you could blend your data together using that.

Just be aware that all of the Data Views are filtered by Date Created, so if you want to see all of your customers at one time, for example, you will have to select a very wide date range.

To help you get started, you can check the box “Use Default Template” to use the free starter template we have to help you get started.

Use Stripe Data Studio Report Template

Just make sure to use the Transactions data view and click Create Report instead of Explore if you want to use the template.

Stripe Data Studio Report Template

The above setup will get you started for the 24 hour preview for one Stripe account. If you sign up free trial, however, you can link multiple Stripe accounts at one time. (5 accounts for our Pro plan and unlimited for our Agency plan)

To do this, first go to the Stripe Data Studio Connector product page to create your Epilocal account and start your free trial. After you’ve done this, go to My Account and scroll down to Manage Subscriptions.

Here you should see your Stripe Data Studio Connector free trial with several options:

Stripe Connector Manage Account

To link multiple Stripe accounts, we will select Manage Stripe Accounts:

Manage Stripe Accounts

Then we will click on Add Stripe Account:

Add Stripe Account

Here we will do the same step as before for our API Key - we will take the secret key from our Sripe Developers dashboard and paste it here. We also have the option of giving this API a nickname that will make it easy to refer to in Data Studio. (if you don’t do this, you will simply see the last 4 digits of the API key)

If your Stripe account was linked successfully, you will now see your Stripe account listed with the option to add more. Then all you need to do is repeat the process for any other Stripe accounts you want to link.

Now we are ready to use the data from our linked Stripe accounts in Data Studio. If we go back to the Config screen of our Stripe data source in Data Studio, you will see that your linked accounts are automatically populated in the dropdown menu Stripe Account:

Choose Stripe Account in Google Data Studio

Now, we just choose which Stripe account we want to use in Data Studio and everything else works the same. You can even select multiple Stripe accounts at one time to easily aggregate all of your data together.

Wrapping Up

With that, you have Stripe connected to Google Data Studio and can start exploring and customizing your data. We hope that you have found this guide helpful to connect Stripe to Data Studio using our connector. If you have any issues or questions, please let us know on our Contact Us page.

Start a Free Trial

Connect Stripe to Data Studio in less than 5 minutes

Related Posts

How to Get Member Data from Mailchimp
Building a Mailchimp Integration for Google Sheets [Free Template]
Getting Started With the Mailchimp Marketing API
Creating Custom Charts for Plausible Analytics