Google Sheets + Stripe
Create Stripe customers from new or updated Google Sheets spreadsheet rows on team drive
Effortlessly keep your customer database up-to-date with this Google Sheets and Stripe integration. Whenever a new or updated row is detected in your team's Google Sheets spreadsheet, this workflow will create a customer in Stripe, ensuring that your customer list stays current and organized. Save time and improve efficiency by letting this seamless process handle the work for you.
Effortlessly keep your customer database up-to-date with this Google Sheets and Stripe integration. Whenever a new or updated row is detected in your team's Google Sheets spreadsheet, this workflow will create a customer in Stripe, ensuring that your customer list stays current and organized. Save time and improve efficiency by letting this seamless process handle the work for you.
- When this happens...
New or Updated Spreadsheet Row (Team Drive)Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create CustomerCreates a new customer.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
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
Bottom-Up
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
Bottom-Up
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 app
No 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 To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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
Bottom-Up
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?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCanceled 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?
Collect Customers' Addresses?
Require customers to provide a phone number?
Confirmation Page
Metadata
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.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.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 app
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsAbout 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
- 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
- Create Google Sheet rows for new Stripe events
- Update Google Sheets rows for new Stripe payments
- Add Stripe customers to Google Forms spreadsheets
- Create Google Sheets spreadsheet rows from new Stripe charges
- Log canceled subscriptions from Stripe to Google Sheets
- Log Failed Stripe Payments in Google Sheets Rows
- Create spreadsheet rows in Google Sheets for new refunds in Stripe
- Log new Stripe disputes in Google Sheets.
- 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
- Log new Stripe payments in Google Sheets.
- Log failed Stripe payments in Google Sheets
- 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
- Add new Stripe customers to Google Sheets rows for streamlined record-keeping
- Update Stripe customers from new Google Sheets spreadsheet rows
- Add new Stripe customers to Google Sheets as worksheets
- 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
- Track failed Stripe invoice payments by creating rows in Google Sheets
- Create spreadsheet columns in Google Sheets for new invoices 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 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
Related Zap Templates
- Add new Stripe sales as rows on Google Sheets
- Create spreadsheet rows in Google Sheets from new customers in Stripe
- Create Google Sheet rows for new Stripe events
- Create Google Sheets spreadsheet rows from new Stripe charges
- Create spreadsheet rows in Google Sheets for new refunds in Stripe
- Add new Stripe payments to Google Sheets rows
- Log failed Stripe payments in Google Sheets
- Add new Stripe subscriptions to Google Sheets as multiple rows
- Create Stripe products from new Google Sheets rows
- Update Stripe customers from new Google Sheets spreadsheet rows
- 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
- 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
- Save Stripe events in a Google Sheets spreadsheet
- Add new Stripe payments to Google Sheets row(s)
- Update Google Sheets rows for new Stripe payments
- Log canceled subscriptions from Stripe to Google Sheets
- Log new Stripe disputes in Google Sheets.
- Log Stripe checkout sessions in Google Sheets rows
- 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
- Add new Stripe customers to Google Sheets as worksheets
- 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
- Track failed Stripe invoice payments by creating rows in Google Sheets
- 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
- 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
- Archive Stripe customers to a Google Sheet
- Add new Stripe subscriptions to Google Sheets rows
- Add Stripe customers to Google Forms spreadsheets
- Log Failed Stripe Payments in Google Sheets Rows
- Create Google Sheets rows for new canceled subscriptions in Stripe
- Log new Stripe payments in Google Sheets.
- Create Stripe products from new or updated Google Sheets rows
- Update Google Sheets rows with new Stripe payments
- Add new Stripe customers to Google Sheets rows for streamlined record-keeping
- 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 columns in Google Sheets for new invoices in Stripe
- Create new Stripe prices from updated rows in Google Sheets
- Create Google Sheets rows for new Stripe payment links
- 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