Google Sheets + Stripe
Create a Google Sheets spreadsheet for each new Stripe invoice
Effortlessly manage your finance records with this streamlined workflow. Whenever a new invoice is generated in Stripe, a corresponding entry is created in a Google Sheets spreadsheet. This results in an organized system for bookkeeping, saving you time and reducing the potential for manual data entry errors. Stay on top of your financial data with this efficient and reliable process.
Effortlessly manage your finance records with this streamlined workflow. Whenever a new invoice is generated in Stripe, a corresponding entry is created in a Google Sheets spreadsheet. This results in an organized system for bookkeeping, saving you time and reducing the potential for manual data entry errors. Stay on top of your financial data with this efficient and reliable process.
- When this happens...
New InvoiceTriggers on a new invoice. You can filter based on the invoice's status. (supports line items)
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create SpreadsheetCreates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Canceled Subscription
Triggers when a subscription is canceled (by a subscriber or due to end of billing period).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Failed Payment
Triggers when a payment attempt fails.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Ignore payments intentsRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Dispute
Triggers when a customer disputes a charge.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Status
Collection Method
Customer ID
Subscription ID
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Subscription
Triggers when a customer subscription has changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Warning
Payment IDRequired
Payment Method ID
Receipt Email
Error on Requires Action?
Shipping - Name
Shipping Address - Line 1
Shipping Address - Line 2
Shipping Address - Postal Code
Shipping Address - City
Shipping Address - State
Shipping Address - Country
Shipping - Carrier
Shipping - Phone
Shipping - Tracking Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer ID
Description
Quantity
Unit Price
Amount
Include Tax In Price?
Item Taxes
Is Discountable?
Item Coupons
Supply Date - Start
Supply Date - End
Invoice Item Currency
Price ID
Invoice Item Subscription ID
Tax Code
Shipping Rate
Invoice Coupons
Default Tax Rates
Payment Collection
Due Date
Days Until Due
Turn On Automatic Collection?
Default Payment Method
Memo
Footer
Custom Fields
Tax IDs
PDF Page Size
Shipping Details Instructions
Shipping Details - Name
Shipping Details - Phone
Shipping Details - Address Line 1
Shipping Details - Address Line 2
Shipping Details - City
Shipping Details - State
Shipping Details - Postal Code
Shipping Details - Country
Subscription ID
Automatic Tax Enabled?
Invoice Currency
Effective At
Payment Method Types
Rendering - Amount Tax Display
Statement Descriptor
Pending Invoice Items Behavior
Invoice Metadata
Help Text For Finalizing Sending Charging
Finalize Invoice?
Send Invoice for Manual Payment?
Pay Invoice?
Pay Invoice - Forgive
Pay Invoice - Off-Session
Pay Invoice - Paid Out of Band
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PriceRequired
QuantityRequired
Minimum adjustable quantity
Maximum adjustable quantity
Collect Tax Automatically?
Allow Promotion Codes?
Maximum number of times the link can be used
Collect Customers' Addresses?
Require customers to provide a phone number?
Require customers to accept terms of service agreement?
Confirmation Page
Metadata
Payment Method Types
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Description
Image
Tax Code
Metadata
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Payment LinkRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stripe Charge IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoice IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer IDRequired
Price ID
Status
ActionThis is an event a Zap performs.SearchFind existing data in your appNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Checkout Session Completed
Triggers when a checkout session is completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Payment Failed
Triggers when an invoice payment fails.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Customer
Triggers when a new customer is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Subscription
Triggers when a customer is signed up for a new plan.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice Item
Triggers when a new invoice item is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Payment
Triggers when a new payment is completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Refund
Triggers when a charge is refunded, including partial refunds.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planSubscription IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Email
Description
Billing - Address Line 1
Billing - Address Line 2
Billing - City
Billing - State
Billing - ZIP
Billing - Country
Billing - Phone
Shipping - Name
Shipping - Address Line 1
Shipping - Address Line 2
Shipping - City
Shipping - State
Shipping - ZIP
Shipping - Country
Shipping - Phone
Language
Invoice prefix
Next Invoice Sequence
Tax Status
Credit Balance
Metadata
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Warning
AmountRequired
CurrencyRequired
Customer ID
Payment Method ID
Confirm Payment Immediately?
Error on Requires Action?
Off Session?
Payment Description
Receipt Email
Shipping - Name
Shipping Address - Line 1
Shipping Address - Line 2
Shipping Address - Postal Code
Shipping Address - City
Shipping Address - State
Shipping Address - Country
Shipping - Carrier
Shipping - Phone
Shipping - Tracking Number
Statement Descriptor
Statement Descriptor Suffix
Metadata
Capture Method
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProductRequired
Price (in minor units, e.g. cents)Required
CurrencyRequired
Recurring or One time?
Tax Behavior
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer IDRequired
ItemsRequired
Collection MethodRequired
Coupon ID
Cancel at period end?
Metadata
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer IDRequired
Name
Email
Description
Billing - Address Line 1
Billing - Address Line 2
Billing - City
Billing - State
Billing - ZIP
Billing - Country
Billing - Phone
Shipping - Name
Shipping - Address Line 1
Shipping - Address Line 2
Shipping - City
Shipping - State
Shipping - ZIP
Shipping - Country
Shipping - Phone
Language
Invoice prefix
Next Invoice Sequence
Tax Status
Credit Balance
Metadata
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find Account Balance
Finds the account balance for your stripe account
ActionThis is an event a Zap performs.SearchFind existing data in your appFind by
QueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPayment Intent IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
About Stripe
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.
Related categories
Related Zap Templates
- Add new Stripe sales as rows on Google Sheets
- Save Stripe events in a Google Sheets spreadsheet
- Archive Stripe customers to a Google Sheet
- Add new Stripe payments to Google Sheets row(s)
- Create spreadsheet rows in Google Sheets from new customers in Stripe
- Add new Stripe subscriptions to Google Sheets rows
- Create Google Sheet rows for new Stripe events
- Add Stripe customers to Google Forms spreadsheets
- Log Failed Stripe Payments in Google Sheets Rows
- Log canceled subscriptions from Stripe to Google Sheets
- Track failed Stripe invoice payments by creating rows in Google Sheets
- Log failed Stripe payments in Google Sheets
- Create Google Sheets spreadsheet rows from new Stripe charges
- Log new Stripe payments in Google Sheets.
- Update Google Sheets rows for new Stripe payments
- Log new Stripe disputes in Google Sheets.
- Add new Stripe customers to Google Sheets as worksheets
- Create Google Sheets rows for new canceled subscriptions in Stripe
- Add new Stripe payments to Google Sheets rows
- Log Stripe checkout sessions in Google Sheets rows
- Add subscribers to Flodesk segments from Dubsado
- Create Stripe products from new or updated Google Sheets rows
- Add new Stripe subscriptions to Google Sheets as multiple rows
- Create Stripe customers from new Google Sheets rows
- Update Google Sheets rows with new Stripe payments
- Create Stripe products from new Google Sheets rows
- Create Stripe customers from new or updated Google Sheets rows
- Create Stripe customers from new or updated Google Sheets spreadsheet rows on team drive
- Add new Stripe customers to Google Sheets rows for streamlined record-keeping
- Update Stripe customers from new Google Sheets spreadsheet rows
- Create spreadsheet rows in Google Sheets for updated subscriptions in Stripe
- Create Stripe payment links for new or updated Google Sheets spreadsheet rows on a team drive
- Create Stripe subscriptions from new or updated Google Sheets rows in team drive
- Add new Stripe orders to Google Sheets as rows
- Create multiple spreadsheet rows in Google Sheets for completed Stripe checkout sessions
- Create columns in Google Sheets for new Stripe customers
- Create Stripe products from new or updated Google Sheets rows in team drive
- Add new Stripe customers to Google Sheets spreadsheets as rows
- Create spreadsheets in Google Sheets for every new payment in Stripe
- Create spreadsheet rows in Google Sheets for new invoice items in Stripe
- Create spreadsheet rows in Google Sheets for new invoices in Stripe
- Create spreadsheet columns in Google Sheets for new invoices in Stripe
- Create spreadsheet rows in Google Sheets for new refunds in Stripe
- Create spreadsheet rows in Google Sheets for new invoice items in Stripe
- Create spreadsheet rows in Google Sheets for new charges in Stripe
- Create new Stripe prices from updated rows in Google Sheets
- Create multiple rows in Google Sheets for new invoices in Stripe
- Update Stripe customers with new or updated rows in Google Sheets
- Create Google Sheets rows for new Stripe payment links
- Create Google Sheets columns for completed Stripe checkout sessions
- Log failed Stripe payments and create multiple rows in Google Sheets
- Create spreadsheets in Google Sheets for new subscriptions in Stripe
- Update and add multiple rows to Google Sheets when subscriptions are updated in Stripe
- Track failed Stripe payments by creating entries in Google Sheets spreadsheets
- Create payment links in Stripe for new rows in Google Sheets
- Deactivate Stripe payment links when new or updated rows appear in Google Sheets
- Create multiple rows in Google Sheets for new Stripe customers
- Create multiple rows in Google Sheets for every new payment link in Stripe
- Create multiple rows in Google Sheets for new events in Stripe
- Generate multiple spreadsheet rows in Google Sheets for newly canceled subscriptions in Stripe
- Create spreadsheet rows in Google Sheets for new invoices in Stripe
- Update Google Sheets rows with new Stripe events
- Update Stripe customers when new or updated rows are added in Google Sheets team drive
- Create new Google Sheets rows for each new Stripe event
- Create multiple rows in Google Sheets for every new invoice in Stripe
- Create multiple rows in Google Sheets for new refunds in Stripe
- Create Google Sheets spreadsheets when new Stripe checkout sessions are completed
- Create spreadsheets in Google Sheets for new invoices in Stripe
- Create Google Sheets columns for new Stripe payments
- Update Stripe api requests on new or updated Google Sheets rows
- Update Google Sheets rows when subscriptions get updated in Stripe
- Create Stripe invoices from new Google Sheets rows
- Clear rows in Google Sheets when new customers are added in Stripe
- Create Stripe subscriptions from new or updated rows in Google Sheets
Related Zap Templates
- Add new Stripe sales as rows on Google Sheets
- Add new Stripe payments to Google Sheets row(s)
- Create Google Sheet rows for new Stripe events
- Log canceled subscriptions from Stripe to Google Sheets
- Create Google Sheets spreadsheet rows from new Stripe charges
- Log new Stripe disputes in Google Sheets.
- Add new Stripe payments to Google Sheets rows
- Create Stripe products from new or updated Google Sheets rows
- Update Google Sheets rows with new Stripe payments
- Create Stripe customers from new or updated Google Sheets spreadsheet rows on team drive
- Create spreadsheet rows in Google Sheets for updated subscriptions in Stripe
- Add new Stripe orders to Google Sheets as rows
- Create Stripe products from new or updated Google Sheets rows in team drive
- Create spreadsheet rows in Google Sheets for new invoice items in Stripe
- Create spreadsheet rows in Google Sheets for new refunds in Stripe
- Create new Stripe prices from updated rows in Google Sheets
- Create Google Sheets rows for new Stripe payment links
- Create spreadsheets in Google Sheets for new subscriptions in Stripe
- Create payment links in Stripe for new rows in Google Sheets
- Create multiple rows in Google Sheets for every new payment link in Stripe
- Create spreadsheet rows in Google Sheets for new invoices in Stripe
- Create new Google Sheets rows for each new Stripe event
- Create Google Sheets spreadsheets when new Stripe checkout sessions are completed
- Update Stripe api requests on new or updated Google Sheets rows
- Clear rows in Google Sheets when new customers are added in Stripe
- Save Stripe events in a Google Sheets spreadsheet
- Create spreadsheet rows in Google Sheets from new customers in Stripe
- Add Stripe customers to Google Forms spreadsheets
- Track failed Stripe invoice payments by creating rows in Google Sheets
- Log new Stripe payments in Google Sheets.
- Add new Stripe customers to Google Sheets as worksheets
- Log Stripe checkout sessions in Google Sheets rows
- Add new Stripe subscriptions to Google Sheets as multiple rows
- Create Stripe products from new Google Sheets rows
- Add new Stripe customers to Google Sheets rows for streamlined record-keeping
- Create Stripe payment links for new or updated Google Sheets spreadsheet rows on a team drive
- Create multiple spreadsheet rows in Google Sheets for completed Stripe checkout sessions
- Add new Stripe customers to Google Sheets spreadsheets as rows
- Create spreadsheet rows in Google Sheets for new invoices in Stripe
- Create spreadsheet rows in Google Sheets for new invoice items in Stripe
- Create multiple rows in Google Sheets for new invoices in Stripe
- Create Google Sheets columns for completed Stripe checkout sessions
- Update and add multiple rows to Google Sheets when subscriptions are updated in Stripe
- Deactivate Stripe payment links when new or updated rows appear in Google Sheets
- Create multiple rows in Google Sheets for new events in Stripe
- Update Google Sheets rows with new Stripe events
- Create multiple rows in Google Sheets for every new invoice in Stripe
- Create spreadsheets in Google Sheets for new invoices in Stripe
- Update Google Sheets rows when subscriptions get updated in Stripe
- Create Stripe subscriptions from new or updated rows in Google Sheets
- Archive Stripe customers to a Google Sheet
- Add new Stripe subscriptions to Google Sheets rows
- Log Failed Stripe Payments in Google Sheets Rows
- Log failed Stripe payments in Google Sheets
- Update Google Sheets rows for new Stripe payments
- Create Google Sheets rows for new canceled subscriptions in Stripe
- Add subscribers to Flodesk segments from Dubsado
- Create Stripe customers from new Google Sheets rows
- Create Stripe customers from new or updated Google Sheets rows
- Update Stripe customers from new Google Sheets spreadsheet rows
- Create Stripe subscriptions from new or updated Google Sheets rows in team drive
- Create columns in Google Sheets for new Stripe customers
- Create spreadsheets in Google Sheets for every new payment in Stripe
- Create spreadsheet columns in Google Sheets for new invoices in Stripe
- Create spreadsheet rows in Google Sheets for new charges in Stripe
- Update Stripe customers with new or updated rows in Google Sheets
- Log failed Stripe payments and create multiple rows in Google Sheets
- Track failed Stripe payments by creating entries in Google Sheets spreadsheets
- Create multiple rows in Google Sheets for new Stripe customers
- Generate multiple spreadsheet rows in Google Sheets for newly canceled subscriptions in Stripe
- Update Stripe customers when new or updated rows are added in Google Sheets team drive
- Create multiple rows in Google Sheets for new refunds in Stripe
- Create Google Sheets columns for new Stripe payments
- Create Stripe invoices from new Google Sheets rows