Import Stripe Data to Google Sheets – Step by Step Guide

Import Stripe Data to Google Sheets – Step by Step Guide

Last Updated On June 02, 2019
You are here:
< Back

Stripe is a popular payment processor known for its fantastic APIs. In this guide, we’ll walk through how to pull transactions from the Stripe API directly into Google Sheets, using the free API Connector add-on. We’ll first get an API key from Stripe, and then set up a request to pull in metrics from Stripe to your spreadsheet.

PART 1: GET YOUR STRIPE API KEY

  1. Log in to Stripe and click Developers > API keys from the left-hand menu
    stripe-img1
  2. On this page, you’ll see that API keys have already been automatically created for you. You can toggle between test data and real data; for now we’ll use the test data. Click to reveal the secret token:
    stripe-img2
  3. Once you have your key, copy it to your clipboard as we’ll need it shortly.

PART 2: CREATE YOUR API REQUEST

We’re going to follow the Stripe API documentation to request a list of transactions.

  • Base URL:https://api.stripe.com/v1/
  • Endpoint: /charges

Putting it all together, we get the full API Request URL:
https://api.stripe.com/v1/charges

We can now enter all our values into API Connector to start importing Stripe data into Google Sheets.

  1. Open up Google Sheets and click Add-ons > API Connector > Create New API Request.
  2. In the Create Request interface, enter the Request URL we just created
    stripe-img3
  3. Under headers, enter a key-value pair like this:
    AuthorizationBearer {Secret Token}

    Replace {Secret Token} with the secret token you got above in step 3 above.
    stripe-img4

  4. Create a new tab. You can call it whatever you like, but here we’ll call it ‘Stripe Charges’. While still in that tab, click ‘Set’ to use that tab as your data destination.
  5. Name your request. Again we’ll call it ‘Stripe Charges’
  6. Click Run and a moment later you’ll see sales data populate the Stripe Charges tab in your Google Sheet:stripe-img5
  7. You can test other endpoints as described in the documentation. For example, change your URL endpoint to /products to see a list of products, or to /customers to see a list of customers.

Following the above steps, you will now be able to import data from the Stripe API directly into Google Sheets.

Comments:0

Leave a Reply

Your email address will not be published.