Google Sheets and Stripe

Google Sheets

Triggers

• Google Sheets New RowTriggers when a new row is added to a Google Sheets spreadsheet.

Actions

• Append rowAppend a single row to the end of a Google Sheet.
• Create spreadsheetCreate a new Google Sheets spreadsheet.
• Delete spreadsheetDelete a Google Sheets spreadsheet permanently.
• Write rowOverwrite a whole row, from column A, with values in column order. To change only some cells of a row, use Update row.
• Update rowSet some cells of one row by column name, leaving the rest of the row as it is. Pair it with Read rows to write a result back to the row it came from. A column that doesn't exist yet is added to the header row.
• Clear row valuesClear values in a specific row without deleting the row itself.

Stripe

Triggers

• New Stripe paymentRuns when a new payment is created in Stripe. The event gives the amount (in cents, so 5000 is $50), currency and status, and who paid as customer_name and customer_email, which are blank when Stripe doesn't know them (a guest checkout may have neither).
• New Stripe customerRuns when a customer is created in Stripe, by a checkout, an invoice, the dashboard or the API.
• New Stripe subscriptionRuns when a subscription is started in Stripe, including one that starts with a free trial.
• Stripe subscription endedRuns when a subscription ends in Stripe: canceled straight away, at the end of its period, or after payment kept failing. One set to cancel later runs this when it actually ends.
• Stripe invoice paidRuns when an invoice is paid in Stripe, including each renewal of a subscription and an invoice marked paid outside Stripe. Amounts are in the currency's smallest unit, so 5000 is $50.
• Stripe invoice payment failedRuns each time Stripe fails to collect an invoice, such as a declined card on a subscription renewal. attempt_count says which try it was, and next_payment_attempt when Stripe tries again.

Actions

• Create a Stripe customerCreate a new Stripe customer with contact details.
• Retrieve a Stripe customerLook up a Stripe customer by their ID.
• List Stripe customersList your most recent Stripe customers.
• Create a Stripe productCreate a product to sell with Stripe.
• Create a Stripe priceCreate a one-time or recurring price for a product.
• Create a Stripe payment linkGenerate a payment link for a price.