Stripe and Google Sheets automations
Set up an automation: when new customer created in Stripe, update spreadsheet row in Google Sheets
Build it50agents builds it as an automation, and asks before anything goes outside.
Stripe and Google Sheets in practice
Used for
Each new Stripe customer fills in columns on a Google Sheets row.
Best template
“New Customer Created” in Stripe, then “Update Spreadsheet Row” in Google Sheets. Stripe pushes each new customer as it happens, and the action writes into a single row.
Watch out
“Update Spreadsheet Row” only changes rows already in the sheet, so each customer needs a row first.
Stripe and Google Sheets templates
Pick one and Captain builds it with you.


When new customer created in Stripe, update spreadsheet row in Google Sheets
Build this

When new customer created in Stripe, update multiple rows in Google Sheets
Build this

When payment link created in Stripe, update multiple rows in Google Sheets
Build this
Stripe and Google Sheets triggers and actions
Every one of both apps. A trigger starts the work; actions are the steps.
Triggers
45- New customer createdRuns when customer is created
- Payment link createdRuns when payment link created
- Subscription endsRuns when subscription ends
- New charge is createdRuns when charge is created
- New event occursRuns when new event occurs
- New refund createdRuns when a new refund is created.
- Charge refundedRuns when charge is refunded
- When a charge succeedsRuns the workflow automatically whenever a charge succeeds.
- When a checkout session is completedRuns the workflow automatically whenever a checkout session is completed.
- Coupon createdRuns when coupon is created
- Customer subscribesRuns when customer subscribes
- Customer updatedTriggers whenever any property of a customer changes.
- Invoice is finalizedRuns when invoice is finalized
- When an invoice is paidRuns the workflow automatically whenever an invoice is paid.
- Invoice item createdRuns when invoice item created
- When a new payment intent is createdRuns the workflow automatically when a new payment intent is created in your Stripe account.
- Payment failsRuns when payment fails
- When a payment succeedsRuns the workflow automatically whenever a payment succeeds.
- Payment link updatedTriggers when a payment link is updated.
- Payment method attachedTriggers whenever a new payment method is attached to a customer.
- Payment method automatically updatedTriggers whenever a payment method’s details are automatically updated by the network.
- Payment method detachedTriggers whenever a payment method is detached from a customer.
- Payment method updatedTriggers whenever a payment method is updated.
- Payout canceledTriggers whenever a payout is canceled.
- New payoutTriggers whenever a payout is canceled.
- Payout failedTriggers whenever a payout attempt fails.
- Payout paidTriggers whenever a payout is expected to be available in the destination account.
- Payout updatedTriggers whenever a payout is updated.
- New personTriggers whenever a person associated with an account is created.
- Person deletedTriggers whenever a person associated with an account is deleted.
- Person updatedTriggers whenever a person associated with an account is updated.
- New planTriggers whenever a plan is created.
- Plan deletedTriggers whenever a plan is deleted.
- Plan updatedTriggers whenever a plan is updated.
- New priceTriggers whenever a price is created.
- Price deletedTriggers whenever a price is deleted.
- Price updatedTriggers whenever a price is updated.
- New productTriggers whenever a product is created.
- Product deletedTriggers whenever a product is deleted.
- Product updatedTriggers whenever a product is updated.
- New promotion codeTriggers whenever a promotion code is created.
- Promotion code updatedTriggers whenever a promotion code is updated.
- Quote acceptedTriggers whenever a quote is accepted.
- Quote canceledTriggers whenever a quote is canceled.
- Quote canceledTriggers whenever a quote is canceled.
No triggers match.
Actions
21- Find a subscriptionRetrieves subscriptions from your Stripe account with flexible filtering options.
- List invoiceSearch and retrieve Stripe invoices using smart filters like customer email, subscription, status, and date.
- Find payment intentsLocate payment intents
- Find customerFind customer by ID/email/date
- Create invoiceCreate a new Stripe invoice
- Delete customerPermanently remove a customer.
- Update customerUpdate Stripe customer details
- Deactivate payment linkDeactivate a payment link
- Create productCreate a new product.
- Create customerCreate or update a customer.
- Cancel subscriptionCancel an active subscription.
- Create priceCreate a product price.
- Collect paymentCreate a payment request in Stripe to collect money from a customer.
- Create payment linkCreate a payment link customers can use to pay or subscribe.
- List couponsRetrieve coupons from Stripe with optional date filters, pagination, limit, and expand fields.
- List all plansRetrieve Stripe plans and optionally filter by product, active status, creation dates, limit, or pagination.
- List billing metersRetrieve billing meters with status filter, cursor pagination, limit, and expand options.
- List transfersList transfers to connected accounts, filtered by destination, transfer group, created date, limit, or pagination.
- Get accountsRetrieve a single account by ID or list accounts with date-range filters, pagination, and limit.
- Search invoice detailsSearch invoice by selecting id
- Search customerFind a Stripe customer by ID or email; supports limit, pagination, and creation date filters.
No actions match.
Triggers
1- Row added or updatedRuns when row added or updated
No triggers match.
Actions
23- Update spreadsheet rowUpdate columns in sheet row
- List rows in sheetGet rows from a sheet tab as objects with row numbers. Supports an optional header row, offset/limit paging, and fetching from the last row.
- Delete rowsDelete one or more rows from a specific sheet in a Google Spreadsheet using a row range or row numbers.
- Add new row to sheetRuns as a step in Google Sheets.
- Lookup spreadsheet rowsFind rows in a Google Sheet that match a column value or an advanced filter.
- Copy sheet to spreadsheetCopy a sheet to another file
- Add multiple rowsAdd one or more rows to a specific sheet in a Google Spreadsheet. Provide data column-by-column or paste a JSON array for bulk inserts. If the sheet has no headers, they will be auto-created from your JSON keys.
- Create subsheetAdd a new subsheet to a spreadsheet and optionally set its position and add column headers in the first row.
- Create sheet columnInsert a new column into the specified Google Sheets sheet at the given index (or append to the end) and optionally set its header.
- Get rows from rangeRetrieve rows from sheet range
- Create a spreadsheetCreate a new spreadsheet.
- Find subsheetSearches a sheet in a spreadsheet by name and returns the sheet name, column titles, and number of rows.
- Get row detailsRetrieve values and metadata for a specific row in a spreadsheet sheet.
- Clear spreadsheet rowClears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.
- Create spreadsheet from templateCreate sheet from template
- List spreadsheetsFetch all spreadsheets
- List spreadsheet tabsLists all tabs (sheets) in a spreadsheet and returns the total count.
- Batch update cell valuesUpdate multiple cells at once
- Format spreadsheet rowFormat row font and background
- Add conditional formatting ruleApply conditional formatting to cells in a Google Sheets spreadsheet based on their values
- Update sheet nameRenames an existing sheet (tab) within a Google Spreadsheet to a new name you specify.
- Update multiple rowsUpdate values in one or more rows of a Google Sheet.
- Permanently delete spreadsheetPermanently delete a spreadsheet from Google Drive, including files on shared drives.
No actions match.
Questions about Stripe and Google Sheets
What can start a Stripe and Google Sheets automation?
“New customer created” and “Payment link created”.
Which other apps work with both Stripe and Google Sheets?
Slack, HubSpot, Shopify, WooCommerce and Google Meet. Each one has templates with Stripe and with Google Sheets, so a third app can join the same job.
All Stripe integrations · All Google Sheets integrations · Every app, A to Z