Adds each new Stripe payment to your revenue sheet in Google Sheets, then emails the customer a thank-you from Gmail.

RPRyan Peng · 1 workflow · Updated Nov 13, 2026

UsesGmailGoogle SheetsStripe

Log Stripe payments and say thanks

StripeStripeWhen a payment succeeds. Save it as payment.When a payment succeeds. Save it as payment.
ValuesSet spreadsheetUrl to blank.Set spreadsheetUrl to blank.
ValuesSet sheetName to blank.Set sheetName to blank.
ValuesSet businessName to blank.Set businessName to blank.
Decisions & LoopsIf payment.status is not succeededIf payment.status is not succeeded
Yes
Decisions & LoopsFinish 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
TextTrim 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.
TextTrim 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.
TextTrim 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.
TextMake 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.
MathSet amount to payment.amount divided by 100.Set amount to payment.amount divided by 100.
ValuesSet decimalPlaces to 2.Set decimalPlaces to 2.
Decisions & LoopsIf [BIF, CLP, DJF, GNF, JPY, KMF, KRW, MGA, PYG, RWF, UGX,…If [BIF, CLP, DJF, GNF, JPY, KMF, KRW, MGA, PYG, RWF, UGX,…
Yes
ValuesChange amount to payment.amount.Change amount to payment.amount.
ValuesChange decimalPlaces to 0.Change decimalPlaces to 0.
Else if ["BHD", "JOD", "KWD", "OMR", "TND"] contains @curre…
MathChange amount to payment.amount divided by 1000.Change amount to payment.amount divided by 1000.
ValuesChange decimalPlaces to 3.Change decimalPlaces to 3.
Otherwise
No steps
MathFormat amount as a currency and save it as amountText.Format amount as a currency and save it as amountText.
Dates & TimesMake 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 SheetsGoogle SheetsAdd a row to sheetName in spreadsheetUrl.Add a row to sheetName in spreadsheetUrl.
Decisions & LoopsIf not customerEmail is a valid email addressIf not customerEmail is a valid email address
Yes
Decisions & LoopsFinish 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
TextUse 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.
GmailGmailSend 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