Back to Blog

How to Set Up a Stripe to Google Sheets Integration Without Coding

You can migrate data to or from Stripe using the REST API. Let’s say to export data about your payments, you need to build an integration between Stripe and your data destination. This means that you’ll need to code… 

But, if your data destination is Google Sheets, no coding is needed to export data from Stripe to your spreadsheet. You can either connect Stripe to Google Sheets yourself or benefit from the ready-to-use template made by our team. Read on to discover which option to choose.

Stripe to Google Sheets integration in less than 5 minutes

To connect Google Sheets to Stripe, you need Coupler.io. It’s a software to import data from third-party sources, such as Xero, QuickBooks, Jira, and others into Google Sheets. Check out all available options and choose the integration in Google Sheets that you need. 

You can sign up to Coupler.io and connect your spreadsheet to Stripe using the web version. Or install the Coupler.io 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 Coupler.io

Go to your Coupler.io 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 connect to Stripe:

  • JSON URL 
  • HTTP headers

JSON URL

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

https://api.stripe.com/v1/

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:

https://api.stripe.com/v1/balance

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:

sk_test_51IJx4mxNUzhHCSlzPQ4q2YNflh04GSFv3Jsxz9iB4nN82LWnwDTgMbcKHqZrtSfkBg4JZaO4ZvyqtrWQZDee4iHq00npiBCa5R

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

Destination

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

Now you can run the integration right away. Optionally, you can automate the import on a custom schedule. To do this, toggle on Automatic data refresh and choose the schedule you want.

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

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

For more on this, read Import JSON 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 Coupler.io 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 Coupler.io, 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 Coupler.io

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

  • Name: Marcello Bianko
  • Email: marcello@bianko.net

Here are the parameters to use:

JSON URL.../v1/customers
HTTP Method*POST
HTTP headersAuthorization: Bearer {api-key}
URL query stringname: Marcello Bianko
email: marcello@bianko.net

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

If you use Coupler.io add-on. here is what the JSON Client importer will look:

Once you click Save & Run, Coupler.io 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

Balance

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

Charges

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

Customers

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

Disputes

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

Events

Type of dataEndpoint
List of all events/v1/events
Details of an event/v1/events/{event-id}

Files and file links

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}

Mandates

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

Payouts

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

Products

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

Prices

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

Refunds

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

Token

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

Do you need a ready-to-use Stripe to Google Sheets integration?

We believe that the flow we described won’t take much time and effort. However, it would be great to have this integration available as a ready-to-use importer, wouldn’t it? Let us know if you need Stripe or another data source connected to Google Sheets by filling out this form. The Coupler.io team is working on new integrations, and yours can be the next importer we release!

Back to Blog

Comments are closed.

Access your data
in a simple format for free!

Start Free