Log Stripe payments and say thanks

Whenever a payment goes through in Stripe, it is added to your revenue sheet as one new row: the date, the customer's name and email, the amount, the currency, what it was for and Stripe's payment ID. The customer then gets a short thank-you from your Gmail that greets them by name and says how much they paid.

The amount is written as a number you can total, not in Stripe's cents, and rows are only ever added. A payment that has not gone through yet is neither logged nor thanked. When Stripe has no email address for the customer, the payment is still logged and the run says no thank-you was sent.

You need Stripe, Google Sheets and Gmail connected, and a tab headed Date, Customer, Email, Amount, Currency, Description and Payment ID.

StripeWhen a payment succeeds. Save it as payment.When a payment succeeds. Save it as payment.

Set spreadsheetUrl to blank.Set spreadsheetUrl to blank.

Set sheetName to blank.Set sheetName to blank.

Set businessName to blank.Set businessName to blank.

If payment.status is not succeededIf payment.status is not succeeded

Yes

Finish the run: This payment has not gone through yet (Stripe says payment.status), so nothing was logged or sent.Finish the run: This payment has not gone through yet (Stripe says payment.status), so nothing was logged or sent.

No

No steps

Trim payment.customer_name, or if it is empty and save it as customerName.Trim payment.customer_name, or if it is empty and save it as customerName.

Trim payment.customer_email, or if it is empty and save it as customerEmail.Trim payment.customer_email, or if it is empty and save it as customerEmail.

Trim payment.description, or if it is empty and save it as description.Trim payment.description, or if it is empty and save it as description.

Make payment.currency, or if it is empty uppercase and save it as currency.Make payment.currency, or if it is empty uppercase and save it as currency.

Set amount to payment.amount divided by 100.Set amount to payment.amount divided by 100.

Set decimalPlaces to 2.Set decimalPlaces to 2.

If [BIF, CLP, DJF, GNF, JPY, KMF, KRW, MGA, PYG, RWF, UGX,…If [BIF, CLP, DJF, GNF, JPY, KMF, KRW, MGA, PYG, RWF, UGX,…

Yes

Change amount to payment.amount.Change amount to payment.amount.

Change decimalPlaces to 0.Change decimalPlaces to 0.

Else if ["BHD", "JOD", "KWD", "OMR", "TND"] contains @curre…

Change amount to payment.amount divided by 1000.Change amount to payment.amount divided by 1000.

Change decimalPlaces to 3.Change decimalPlaces to 3.

Otherwise

No steps

Format amount as a currency and save it as amountText.Format amount as a currency and save it as amountText.

Make payment.created readable as “2026-11-02” and save it as paidOn.Make payment.created readable as “2026-11-02” and save it as paidOn.

Google SheetsAdd a row to sheetName in spreadsheetUrl.Add a row to sheetName in spreadsheetUrl.

If not customerEmail is a valid email addressIf not customerEmail is a valid email address

Yes

Finish the run: Added the amountText payment to your sheet. Stripe has no email address for this customer, so no thank-you was sent.Finish the run: Added the amountText payment to your sheet. Stripe has no email address for this customer, so no thank-you was sent.

No

No steps

Use customerName, or there if it is empty and save it as greetingName.Use customerName, or there if it is empty and save it as greetingName.

GmailSend an email to customerEmail.Send an email to customerEmail. Subject: Thanks for your payment to businessNameHi greetingName, Thank you for your payment of amountText. It has come through, and this email is your confirmation. If you have any questions, just reply to this email. Thanks again, businessName