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:
URL of receipt
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:
Click on the Use this Zap button above to get started (and create a Zapier account if you haven't already).
Connect your Stripe and Google Sheets accounts.
(Optional) Specify a specific Stripe customer to trigger your workflow, if desired.
(Optional) Select the Stripe order status you'd like to trigger your Zap.
Select the Google Sheet you'd like to use.
Select the Google Sheet columns you'd like to add information to.
Map your Stripe order information to the appropriate Google Sheet columns.
Test your workflow and turn it on.
Option 2: Create your own Zap
Here's how to set it up:
Set up your Stripe trigger step in Zapier.
Set up your Google Sheets action step in Zapier.
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.
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.
Click Yes, Continue, and then customize your Stripe trigger by deciding if you want failed charges to be logged in your Sheet or not.
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.
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.
Once you've selected your worksheet, the values you entered for the columns in your header will appear.
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.
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.
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.
Make sure you turn on your Zap when everything looks done, by clicking the toggle switch at the bottom of the screen.
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.