■Overview
This is a flow bot that automatically stores subscription information in a Google Spreadsheet when a new subscription is made on Stripe.
It retrieves detailed information such as the customer's name who subscribed and the subscription period, and automatically stores the information in a specified Google Spreadsheet.
Feel free to change the target Google Spreadsheet and the information to be stored as needed.
By using this flow bot together, you can synchronize Stripe subscription information with Google Spreadsheet.
■Notes
・Please integrate both Stripe and Google Spreadsheet with Yoom.
・Prepare and utilize a spreadsheet to store Stripe information.
・Stripe is an app available only with the Team Plan and Success Plan. If you are on the Free Plan or Mini Plan, the operations and data connections set in the flow bot will result in errors, so please be careful.
・Paid plans such as the Team Plan and Success Plan offer a 2-week free trial. During the free trial, you can use apps that are subject to restrictions.
When a row is added
When a row is updated
When a new customer is created
When a customer subscribes to a new subscription plan
When subscription details are updated
When a subscription ends
When the new subscription period starts
When a deposit is made
When a new payment is created
When a new payment method is associated with a customer
When a payment method is detached from a customer
When a customer's payment method is updated
When an invoice is created
When a payment fails
When a payment is successfully completed
When a refund process is started
When the checkout session is successfully completed
When a product is created
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
Repeat Formula
Input Values into Range
Embed Image in Cell
Sort by Specific Column
Hide Sheet
Add Note to Specified Cell
When a row is addedWhen a row is updated
Input Value into CellRetrieve ValueDelete ValuesCreate a New SpreadsheetCopy Sheet (Tab)Add a New Sheet (Tab)Delete Sheet (Tab)Replace ValuesUpdate Sheet NameDelete RowsGet Spreadsheet InformationGet Sheet NamesRepeat FormulaInput Values into RangeEmbed Image in CellSort by Specific ColumnHide SheetAdd Note to Specified CellAdd ColumnDelete Columns
When a new customer is createdWhen a customer subscribes to a new subscription planWhen subscription details are updatedWhen a subscription endsWhen the new subscription period startsWhen a deposit is madeWhen a new payment is createdWhen a new payment method is associated with a customerWhen a payment method is detached from a customerWhen a customer's payment method is updatedWhen an invoice is createdWhen a payment failsWhen a payment is successfully completedWhen a refund process is startedWhen the checkout session is successfully completedWhen a product is createdWhen a product is updatedWhen a dispute is created
List CustomersRetrieve CustomerRetrieve invoiceCreate CustomerCreate subscriptionCancel SubscriptionCreate ProductAdd a Price to a ProductCreate Payment LinkRetrieve subscription detailsRetrieve Payment Intent detailsRetrieve balance transaction detailsRetrieve list of payoutsRetrieve balance transactions for a payoutRetrieve ChargeUpdate CustomerRetrieve ProductRetrieve PriceList ProductsSearch products (by product name)Search price information (exact match by product ID)Search customersCreate invoiceCreate priceList billing meter event summaries
Update productUpdate priceCreate Invoice ItemCreate Checkout Session (One-time Payment)
