ConditionalVisibility

new-products-promo

Setting up your Google Sheet to receive information from Stripe

Configuring your trigger step in Zapier

Finding your API key in Stripe.

Choose whether to include failed charges in your Sheet.

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

Choose the correct Sheet from the dropdown menu.

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

Customize how data will flow into your Sheet.

How your Zap will look when it is fully configured.

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

Zapier tutorials

zapier-tutorial-stripe-google-sheets-00-hero

Google Sheets

Stripe

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.

How to add Stripe sales as new rows in Google Sheets

If you're looking for a little book-keeping assistance, you've come to the right place. Activate this Stripe-Google Sheets integration and it will watch Stripe for you, triggering with every new sale and automatically sending the information to Google Sheets in a new row, so your accounting has all the detail it needs.

Stripe is a developer-friendly way to accept payments online and in mobile apps. Stripe's suite of APIs powers commerce for thousands of companies of all sizes, processing billions of dollars for businesses each year.

Triggers when a subscription is canceled (by a subscriber or due to end of billing period).

Canceled Subscription

Triggers when a checkout session is completed.

Checkout Session Completed

Failed Payment

Invoice Payment Failed

New Charge

New Customer

Triggers when a customer disputes a charge.

New Dispute

Triggers when a customer is signed up for a new plan.

New Subscription

Triggers when a new event like a dispute, subscription, or transfer is added.

New Event

Triggers when a new invoice is created (supports line items).

New Invoice

Triggers when a new invoice item is created.

New Invoice Item

Triggers on a new invoice. You can filter based on the invoice's status. (supports line items)

Triggers when a new payment is completed.

New Payment

Triggers when a new payment link is created.

New Payment Link

Triggers when a charge is refunded, including partial refunds.

New Refund

Triggers when a customer subscription has changed.

Updated Subscription

Finds the account balance for your stripe account

Find Account Balance

Finds an existing charge by its Stripe ID.

Find Charge

Finds an existing customer by their Stripe ID or email address.

Find Customer

Finds an existing invoice by its Stripe ID.

Find Invoice

Finds an existing payment intent by its Stripe ID.

Find Payment

Find Subscription

Cancel Subscription

Confirms an existing payment, also known as a PaymentIntent.

Confirm Payment

Create Customer

Create Invoice

Creates a new payment, also known as a PaymentIntent.

Create Payment

Create Payment Link

Create Price

Create Product

Create Subscription

Deactivate Payment Link

Update Customer

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

Create one or more new rows in a specific spreadsheet (with line item support).

Create Multiple Spreadsheet Rows

Creates a new spreadsheet row at the top of a spreadsheet (after the header row).

Create Spreadsheet Row at Top

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

Update one or more rows in a specific spreadsheet (with line item support).

Update Spreadsheet Row(s)

Add new Stripe sales as rows on Google Sheets

When you have new invoices, you may want the details added to a spreadsheet for tracking purposes. This integration helps by automatically creating a row in a Google Sheet when there is a new invoice in Stripe. It's never been easier to organize invoice data.

Stripe (Legacy)

Triggers when someone's credit card is charged.

Triggers when you add a new Stripe coupon.

New Coupon

Triggers when a new event like a dispute, subscription, or transfer is added. 

Triggers when a new invoice item is listed.

New Order

New Plan

Finds an existing customer by their email address or Stripe ID.

Create Google Sheet rows for new Stripe invoices

When you have new refunds, you'll want to organize the details in a spreadsheet. This integration helps by automatically creating a row in a Google Sheet with the details of a new refund in Stripe. It's never been easier to organize your refund data.

Create Google Sheet rows for new refunds in Stripe

Log or archive new Stripe customers as rows in a Google Sheets spreadsheet automatically, with this Stripe Google Sheets integration. After you set up this integration, every time there is a new Stripe customer, a new row will be added to a Google Sheets spreadsheet. Now you have an easy way to share and collaborate on Stripe customer data without giving Stripe. access to third parties.

How to add Stripe sales as new rows in Google Sheets

Related articles

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