Sign up
  • Home
  • Automation with Zapier

How to add Stripe sales as new rows in Google Sheets

Zapier tutorials

4 min read

How to add Stripe sales as new rows in Google Sheets

By Kaylee Moser · August 11, 2021
zapier-tutorial-stripe-google-sheets-00-hero

Manually logging Stripe transactions is not only tedious, it's also error-prone. Don't worry, automating your bookkeeping—taking those tasks off your plate while reducing errors—is easy with Zapier.

Stripe offers financial SaaS for businesses that need payment processing through APIs. You might use Stripe if you sell things online. Google Sheets is cloud-based spreadsheet software and Google's answer to Excel. Through Zapier's automated workflows —we like to call them Zaps—you can automatically log Stripe transactions in Google Sheets or your favorite spreadsheet app for further analysis.

To get this integration working, all you need is a Stripe account and a Google account with access to Google Sheets.

You'll need a Zapier account to use the workflows in this piece. If you don't have an account yet, it's free to get started.

Set up your Google Sheet

Before you get started, we recommend you set up the Google Sheet you'd like to receive your Stripe data. To do this, log in to your Google Sheets account and create a new Sheet. Be sure that your sheet has a frozen header row with clearly labeled columns. This will make it much easier to set up your Zap.

For this example. we are going to log the following information from Stripe, so we need columns with these labels:

  • Transaction date

  • Transaction ID

  • Currency type

  • Amount

  • URL of receipt

Setting up your Google Sheet to receive information from Stripe

You can read more about formatting Google Sheets to work with Zaps here.

Option 1: Get started quickly with a Zap template

You can use the Zap template below as a starting point. Click the Use this Zap button and you'll be guided through setup. You'll need to create a Zapier account if you don't already have one.

Here's how it works: 

  1. Click on the Use this Zap button above to get started (and create a Zapier account if you haven't already). 

  2. Connect your Stripe and Google Sheets accounts.

  3. (Optional) Specify a specific Stripe customer to trigger your workflow, if desired.

  4. (Optional) Select the Stripe order status you'd like to trigger your Zap. 

  5. Select the Google Sheet you'd like to use. 

  6. Select the Google Sheet columns you'd like to add information to.

  7. Map your Stripe order information to the appropriate Google Sheet columns. 

  8. Test your workflow and turn it on.

Option 2: Create your own Zap

If you'd like more control over information in your Zap or would like to add additional actions such as filtering for specific Stripe purchases, you can click here to create a new Zap from scratch. 

Here's how to set it up:

  1. Set up your Stripe trigger step in Zapier.

  2. Set up your Google Sheets action step in Zapier.

  3. Turn on your Zap.

Configure your Stripe trigger step

Once you're in the Zap editor, select the app—Stripe—and the trigger event—New Charge.

Configuring your trigger step in Zapier

Click Continue. You will be asked to sign in to your Stripe account, if you haven't already. If this is your first time connecting your Stripe account, you will need to add your API key from Stripe, which can be found here.

For each app you connect, Zapier will ask for a general set of permissions which allows you to be flexible with your Zaps. The only actions Zapier takes on your app accounts are those a given Zap needs to accomplish what you've set up.

Note that the API key should be a "secret" and "live" key. You need an activated account to get a key like that. If you're just trying to test out your Zap for now, you can use a test key, which can be found here.

Finding your API key in Stripe.

Click Yes, Continue, and then customize your Stripe trigger by deciding if you want failed charges to be logged in your Sheet or not.

Choose whether to include failed charges in your Sheet.

Click Continue. You will be asked to pull in sample data, which is always a good idea when setting up a new Zap.

Configure your Google Sheets action step

Now that your Google Sheet is created, it's time to set up the action for your Zap. Choose Google Sheets as your app and Create Spreadsheet Row as your action. If you're starting from the template, this may be selected for you already.

Configuring your action step to add a new row in Google Sheets.

This will prompt you to sign in to your Google Sheets account. After you've signed in, you can select the Google Drive, spreadsheet, and worksheet you wish to use for this integration.

Choose the correct Sheet from the dropdown menu.

Once you've selected your worksheet, the values you entered for the columns in your header will appear.

Set up your Zap to use the correct Worksheet in your Sheet.

If you find you need to make any changes to the columns in your Sheet at this point, click Refresh Fields afterward to update your options in this box.

Finally, select the values from the Stripe trigger's payload to populate your Sheet.

Customize how data will flow into your Sheet.

You can be as creative as you want for this part, setting up your Sheet to track whatever Stripe data is useful to log. Since we selected to log Date, ID, Currency, Amount, and URL, we are going to fill out those fields.

How your Zap will look when it is fully configured.

As you can see, it is showing the test data from our Stripe payload. Once all fields are selected, click Continue and then test your Zap. After running the test, you should see the data from Stripe as a row in your Sheet.

Once you run a test, a row will be added to your Sheet using the sample data from your Zap.

Make sure you turn on your Zap when everything looks done, by clicking the toggle switch at the bottom of the screen.

Use the toggle switch at the bottom of the screen to turn on your Zap.

And that's all! From now on, all transactions in your Stripe account will be logged in your new Google Sheet as a new row.

Log even more Stripe data in Google Sheets

If this bookkeeping integration made life easier for you, check out some of our other data-logging Zaps using Stripe and Google Sheets:

This article was originally published in September 2020 and was updated in August 2021 by Zapier staff writer Krystina Martinez.

Get productivity tips delivered straight to your inbox

We’ll email you 1/wk, and never share your information.

Kaylee Moser picture

Kaylee Moser

Kaylee Moser is a freelance writer living in the Sierra Foothills of California. When she’s not writing, she’s either gardening, collaging, or playing with her dog.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign upSee how it works