Back to Blog

How to Set Up a Stripe to Google Sheets Integration In Three Steps Without Coding

While Stripe doesn’t offer a way to automatically populate Google spreadsheets, it’s easy to set up an integration between both apps. What’s more, you can do it even without coding if you prefer.

In this article, we cover two methods you can use to connect Stripe to Google Sheets. We’ll also share a handy template you can use to create a custom integration between Stripe and Google Sheets.

Stripe to Google Sheets integration in less than 5 minutes

The simplest and quickest approach to setting up a Stripe Google Sheets integration is with third-party tools. One such app is – an all-in-one data analytics and integration platform that can fetch your Stripe data automatically and bring it to destinations like Google Sheets, Excel, or Looker Studio. Stripe to BigQuery integration is also available.

  • To get started, sign up to, a free 14-day trial is available, and no credit card is required. 
  • Then, choose to add a new importer.
  • From the dropdown lists, choose Stripe as a source app and Google Sheets as a destination.
stripe to google sheets
  • Connect your Stripe account and choose the business entity you want to fetch the data for. If you plan to fetch from multiple entities, you’ll just need to duplicate an importer later on and connect each entity separately.
  • Next, choose what to import from Stripe. There are plenty of available data entities, such as Customers, Invoices, Products, and Refunds. We’ll fetch invoices on this occasion.
  • Add some optional filters if you’d like and then jump to the destination settings.
  • Here, connect your Google account. Then, choose a spreadsheet and a sheet for your import of Stripe data to Google Sheets.
google sheets destination
  • While it’s optional, it’s worth setting up a schedule for your data importers. This will keep your data fresh as will fetch any changes to your data at a frequency you choose – for example hourly or daily.
import schedule
  • Once you’re finished, click the Save and Run button. 
  • Wait until the import is finished and then click View Results. Here’s a piece of our invoice data imported into a spreadsheet.
sample export

An alternative method to connect Stripe to Google Sheets importer offers plenty of data entities and customization options but chances are it may not get you the type of data you need. If that’s the case, you’ll want to use the API to integrate Stripe with Google Sheets.

There’s no point in guiding you through Stripe API as its reference provides all the knowledge you need. However, rather than write requests yourself and build scripts for automating imports, you may want to give a try to’s JSON importer. It helps you set up the same functionality without any coding and with a quick, effortless setup.

Let’s see it in action one more time. If you haven’t yet, sign up for a free trial of Alternatively, you may want to install the add-on from the Google Workspace Marketplace and set up the integration right from the Google Sheets document. 

Let’s check out what the web flow looks like.

Linking Stripe to Google Sheets using

Go to your account and click the +Add new button.

Click Select source application and choose JSON Client from the drop-down menu. Click Continue.

Basically, we need to set up two parameters to integrate Stripe with Google Sheets:

  • HTTP headers


JSON URL is the base URL + endpoint to make HTTP requests to. The Stripe base URL is the following:

The endpoints differ depending on the type of data you want to export from Stripe. For example, using the endpoint balance, you can retrieve information about the balance currently on your Stripe account. In this case, the JSON URL will look as follows:

Click Continue when ready. 

Here is a list of endpoints you can use to export data from Stripe.

HTTP headers

In our Stripe to Google Sheets integration, we’ll only use one header – Authorization. It should look as follows:

Authorization: Bearer {api-key}

How to get a Stripe API key?

Go to the Stripe dashboard => Developers => API keys. You need a secret key. Click the button to reveal it. 

In our case, the API key looks like this:


Insert the Authorization parameter in the field and click Proceed to destination settings when ready.


Choose your destination Google account and click Continue to select a spreadsheet to import Stripe data to. 

You’ll also need to select a sheet from your spreadsheet. Click Proceed to the schedule settings.

Import Stripe data to Google Sheets

Once you’re done linking Stripe to Google Sheets, you can click the Save and Run button to launch an importer. However, to keep your data up-to-date and refresh the spreadsheet as data changes in Stripe, you may want to create a schedule for automatic data refreshes.

To do this, toggle on Automatic data refresh and choose the schedule you want.

When ready, click Save & Run, and will import your Stripe data into your spreadsheet. 

And here is what the data import looks like if you use the add-on:

For more on this, read Import API to Google Sheets.

A ready-to-use template for importing Stripe data to Google Sheets (for more than 100 entries)

The Stripe API limitation is 100 entries per request. This means that if you have, let’s say, 150 customers in your Stripe account, you won’t get all of them at once. But we have a ready-to-use template with the pre-built importers to retrieve data from Stripe.

The how-to-use instructions are given in the Readme sheet.  For example, to import 150 entries about customers from Stripe to Google Sheets, we need to do the following:

1. Make a copy of this spreadsheet.

2. Insert our Stripe API key in the B8 cell.

3. Choose Customers from the drop-down list in B9 cell as the data entity to import from Stripe.

4. In the B11 cell, enter the value of how many customers we want to import – 150.

5. Open add-on. We’ll see three pre-built importers on the dashboard:

  • Get first 100 customers
  • Fetch last 50 records of the initial list of customers
  • Get new customers

6. Run the ‘Get first 100 customers‘ importer once. This will create a Stripe customers sheets and import 100 entries from Stripe. 

7. After that, run the ‘Fetch last 50 records…‘ importer once.

Note: Depending on the total number of entries to import, the number of importer runs will change.

That’s it. If you run the ‘Get new customers‘ importer, it will add newly created customers at the end of that list every hour. You can edit the frequency of the automatic data schedule if needed.

Push Stripe data to Google Sheets and vice versa

With, you can both import data from Stripe and push data to Stripe. For example, the following parameters will let you retrieve a list of customers:

JSON URL.../v1/customers
HTTP headersAuthorization: Bearer {api-key}

In our example, we retrieved a list of three customers:

If you tweak the JSON Client parameters a bit, you’ll be able to use this integration to push data from spreadsheet to Stripe. For example, here is how you can create a new customer. 

Create a new Stripe customer using

Let’s create a new customer with the following information:

  • Name: Marcello Bianko
  • Email:

Here are the parameters to use:

JSON URL.../v1/customers
HTTP headersAuthorization: Bearer {api-key}
URL query stringname: Marcello Bianko

*Do not forget to change the HTTP method from GET to POST!

Once you click Save & Run, will create a new customer in your Stripe account, and you’ll get the respective information in your sheet.

Let’s also check out the Stripe UI, to confirm this. 

In a similar way, you can create charges, payouts, refunds and other entries in Stripe. For more on this, refer to the Stripe API documentation.

Which data you can import via the Google Sheets and Stripe integration


Type of dataEndpoint
List of all balance transactions/v1/balance/history


Type of dataEndpoint
List of all charges/v1/charges
Details of a charge/v1/charges/{charge-id}


Type of dataEndpoint
List of all customers/v1/customers
Details of a customer/v1/customers/{customer-id}


Type of dataEndpoint
List of all disputes/v1/disputes
Details of a dispute/v1/disputes/{dispute-id}


Type of dataEndpoint
List of all events/v1/events
Details of an event/v1/events/{event-id}
Type of dataEndpoint
List of all files/v1/files
Details of a file/v1/files/{file-id}
List of all file links/v1/file_links
Details of a file link/v1/file_links/{file-link-id}


Type of dataEndpoint
Details of a mandate (record of the permission a customer has given you to debit their payment method)/v1/mandates/{mandate-id}

Payments intents

Type of dataEndpoint
List of all payment intents/v1/payment_intents
Details of a payment intent/v1/payment_intents/{payment-intent-id}

Setup intents and attempts

Type of dataEndpoint
List of all setup intents/v1/setup_intents
Details of a setup intent/v1/setup_intents/{setup-intent-id}
List of all setup attempts/v1/setup_attempts


Type of dataEndpoint
List of all payouts/v1/payouts
Details of a payout/v1/payouts/{payout-id}


Type of dataEndpoint
List of all products/v1/products
Details of a product/v1/products/{product-id}


Type of dataEndpoint
List of all prices/v1/prices
Details of a price/v1/prices/{price-id}


Type of dataEndpoint
List of all refunds/v1/refunds
Details of a refund/v1/refunds/{refund-id}


Type of dataEndpoint
Details of a token/v1/tokens/{token-id}

Stripe to Google Sheets – recap

Stripe only allows for manual data exports from the platform. It may work if you need the data for one-time use or, for example, once a quarter. However, if you have some automated workflows in mind or live dashboards perhaps, you’ll need a way to automate the way you import Stripe data to Google Sheets.

In this article, we described two handy integrations. One was about fetching data directly from Stripe with a dedicated importer available on all plans. Another relied on Stripe API and fetching data via’s JSON importer. The latter is a bit more technical but at the same time, gives you virtually unlimited possibilities. Choose what works best for you.

And if you’re struggling with setting up a Stripe Google Sheets integration you need, don’t hesitate to reach out to data experts. Through this service, we can build any custom integrations for you, set up automations, design self-updating dashboards, and much more. Get in touch and schedule a free consultation.

  • Julia Ryzhkova

    Product Manager at Railsware. I consider myself a 4 P's manager, focusing on Product, Process, Project, and People. In any of those fields, the main driver for me is the ability to make people's lives easier. That's also why I like to share my experience via blog. I have worked in consultancy, R&D, support, marketing, and PMO, which helps me look at any question from diverse points of view. Besides work, I really enjoy traveling and playing board games🎲

Back to Blog

Comments are closed.

Focus on your business
goals while we take care of your data!