Stripe payments to Google Sheets
Set up an automation: every new Stripe payment is added as a row to my Google Sheet with the customer, amount and date
Build itIt builds an automation that writes only to your sheet, so nothing needs approval.
How to send Stripe payments to Google Sheets
Name the columns you want. Captain asks which sheet to use and which currencies your payments come in.
CaptainSet up an automation: every new Stripe payment is added as a row to my Google Sheet with the customer, amount and date
I’ll set that up. A couple of quick questions first.
It starts when a payment succeeds, looks up the customer, then adds a row. Refunds can be a second automation.
Payments sheetAutomation · every Stripe payment, one row each- Runs
- When a payment succeeds in Stripe
- Does
- Looks up the customer · Writes the amount in dollars · Adds a row to your Sheet
- Uses
Stripe
Google Sheets- Asks first
- Nothing outside your own sheet
Connect both once and pick the spreadsheet and tab. Put your column headings in row one so each value lands in its column.
StripeConnected
Google SheetsConnectEach payment adds one row: date, customer name and email, amount as dollars, the currency, and the payment ID.
Payments sheetLive- Today, 11:52Added a row for a USD payment from Harbor Yoga
- Today, 10:07Added a row for a EUR payment from Ben Ortiz
- Yesterday, 18:40Added a row for a USD payment from Grace Liu
Example runs
The sheet stays yours. Sort it, total it, chart it, or share it with your accountant.
Rows added to Payments- Harbor Yoga | [email protected] | 240.00 | USD
- Ben Ortiz | [email protected] | 36.00 | EUR
- Grace Liu | [email protected] | 120.00 | USD
Example
Works with Stripe, Google Sheets and 2,300+ apps
Make it yours
Change one thing, and Captain builds that version instead.
- “Set up an automation: every new Stripe payment over $1,000 is added as a row to my Google Sheet with the customer, amount and date”Only payments over $1,000
- “Set up an automation: every new Stripe refund is added as a row to my Google Sheet with the customer, amount and date”Logs refunds instead of payments
- “Set up an automation: every new Stripe payment is added as a record to my Airtable base with the customer, amount and date”Records go to Airtable, not Sheets
- “Set up an automation: every failed Stripe payment is posted in a Slack channel with the customer and amount”Failed payments go to Slack
Questions people ask
Does it handle refunds?
Stripe has its own refund events, New Refund Created and Charge Refunded. Build a second automation on one of them that adds a refund row or updates the payment's row. Tell Captain which you prefer.
Why is my amount too big in the sheet?
Stripe sends amounts in the currency's smallest unit, so a raw copy shows cents as dollars. Ask Captain for amounts in dollars with a currency column, since yen has no cents and needs no conversion.
Can it add Stripe's fees to the sheet?
Not today. None of the Stripe actions in the catalog look up fees, so keep fees in Stripe's own reports and use the sheet for the customer, amount and date.
Which Stripe event starts it?
A payment succeeding. Stripe also has New Charge Is Created and a completed checkout session, if you want a different starting point.
Does it add my past payments?
No. It starts with the next payment after you build it. For earlier ones, export from Stripe and paste them into the sheet.
What does it cost to start?
50agents is free to start. Tell Captain what you want, read the steps, and tap Build it.
What if a payment is missing from the sheet?
It adds a row each time a payment succeeds after you build it, so a payment made earlier is not there. Check your column headings in row one and ask Captain to adjust the match if values land in the wrong column.
Can I send payments to Airtable or my accounting tool?
A variation on this page writes to Airtable, and QuickBooks and Xero are in the catalog. Name your tool in your sentence to Captain and ask what it can write.
How long does setup take?
One sentence to Captain, then you connect Stripe and Google Sheets and pick the spreadsheet and tab. It starts with the next successful payment.