Google Sheets + Stripe
Clear rows in Google Sheets when new customers are added in Stripe
With this workflow, maintain an ordered record of your new Stripe customers in your Google Sheets by simply updating the sheet every time a fresh customer is added. This automation minimizes manual data entry while ensuring real-time and organized tracking of your clientele.
With this workflow, maintain an ordered record of your new Stripe customers in your Google Sheets by simply updating the sheet every time a fresh customer is added. This automation minimizes manual data entry while ensuring real-time and organized tracking of your clientele.
- When this happens...
New CustomerTriggers when a new customer is added.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Clear Spreadsheet Row(s)Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.
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 ZapPollingZapier 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.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
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
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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.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
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
Related categories
About Stripe
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
- Create spreadsheet rows in Google Sheets from new customers in Stripe
- Add new Stripe payments to Google Sheets row(s)
- Add new Stripe subscriptions to Google Sheets rows
- Log canceled subscriptions from Stripe to Google Sheets
- Create Google Sheet rows for new Stripe events
- Log failed Stripe payments in Google Sheets
- Log Failed Stripe Payments in Google Sheets Rows
- Create Stripe invoices from new Google Sheets rows
- Add Stripe customers to Google Forms spreadsheets
- Track failed Stripe invoice payments by creating rows in Google Sheets
- Create Google Sheets rows for new Stripe payment links
- Create Google Sheets spreadsheet rows from new Stripe charges
- Create Stripe products from new Google Sheets rows
- Log new Stripe disputes in Google Sheets.
- Log new Stripe payments 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
- Update Google Sheets rows for new Stripe payments
- 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 columns for completed Stripe checkout sessions
- Log failed Stripe payments and create multiple rows in Google Sheets
- Create a Google Sheets spreadsheet for each new Stripe invoice
- 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 subscriptions from new or updated rows in Google Sheets
- Update Google Sheets rows with new Stripe events for streamlined data tracking
- Create Stripe invoices from new or updated Google Sheets rows
- Update Google Sheets rows with new Stripe charges automatically
- Update Google Sheets rows when Stripe invoice payments fail
- Create spreadsheet rows in Google Sheets for new charges in Stripe
- Create Stripe customers from new or updated Google Sheets rows
- Add new Stripe subscriptions to Google Sheets as rows
- Create a Google Sheets row at top for every canceled Stripe subscription
- Update Google Sheets rows when new Stripe checkout sessions are completed
- Create Stripe payments from new or updated rows in Google Sheets
- Update Google Sheets rows when Stripe subscriptions are canceled
- Log failed Stripe invoice payments in a new top row on Google Sheets
- Create Google Sheets rows at the top for completed Stripe checkout sessions
- Update Google Sheets rows when new Stripe checkout sessions complete
Related Zap Templates
- Add new Stripe sales as rows on Google Sheets
- Create spreadsheet rows in Google Sheets from new customers in Stripe
- Log canceled subscriptions from Stripe to Google Sheets
- Log Failed Stripe Payments in Google Sheets Rows
- Track failed Stripe invoice payments by creating rows in Google Sheets
- Create Stripe products from new Google Sheets rows
- 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
- Update Google Sheets rows for new Stripe payments
- 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
- Log failed Stripe payments and create multiple rows in Google Sheets
- 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 invoices from new or updated Google Sheets rows
- Create spreadsheet rows in Google Sheets for new charges in Stripe
- Create a Google Sheets row at top for every canceled Stripe subscription
- Update Google Sheets rows when Stripe subscriptions are canceled
- Update Google Sheets rows when new Stripe checkout sessions complete
- Save Stripe events in a Google Sheets spreadsheet
- Add new Stripe payments to Google Sheets row(s)
- Create Google Sheet rows for new Stripe events
- Create Stripe invoices from new Google Sheets rows
- Create Google Sheets rows for new Stripe payment links
- Log new Stripe disputes in Google Sheets.
- 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
- Create a Google Sheets spreadsheet for each new Stripe invoice
- 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 subscriptions from new or updated rows in Google Sheets
- Update Google Sheets rows with new Stripe charges automatically
- Create Stripe customers from new or updated Google Sheets rows
- Update Google Sheets rows when new Stripe checkout sessions are completed
- Log failed Stripe invoice payments in a new top row on Google Sheets
- Archive Stripe customers to a Google Sheet
- Add new Stripe subscriptions to Google Sheets rows
- Log failed Stripe payments in Google Sheets
- Add Stripe customers to Google Forms spreadsheets
- Create Google Sheets spreadsheet rows from new Stripe charges
- Log new Stripe payments 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 columns for completed Stripe checkout sessions
- 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
- Update Google Sheets rows with new Stripe events for streamlined data tracking
- Update Google Sheets rows when Stripe invoice payments fail
- Add new Stripe subscriptions to Google Sheets as rows
- Create Stripe payments from new or updated rows in Google Sheets
- Create Google Sheets rows at the top for completed Stripe checkout sessions