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 it

It builds an automation that writes only to your sheet, so nothing needs approval.

How to send Stripe payments to Google Sheets

  1. Name the columns you want. Captain asks which sheet to use and which currencies your payments come in.

    Captain

    Set 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.

  2. 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
    StripeGoogle Sheets
    Asks first
    Nothing outside your own sheet
  3. 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 SheetsConnect
  4. Each 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

  5. The sheet stays yours. Sort it, total it, chart it, or share it with your accountant.

    Rows added to Payments

    Example

Works with Stripe, Google Sheets and 2,300+ apps

StripeGoogle SheetsCalendlyPayHereLemon SqueezySquareChargebeeCoinDCXMolliePinch PaymentsShopkitFlutterwaveGoDaddy PaymentsExpensyaAuthorize.NetPayrexx
BillsbyRecurlyRevolut BusinessGumroadbraintreeVATlayerPaddleSellAppHDFC Smart GATEWAYLagoShopifyHubSpotTodoistGoogle DocsSangam CRMSlackFreshsales ClassicRazorpay

Make it yours

Change one thing, and Captain builds that version instead.

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.

More things Captain can build

Stripe payments to Google Sheets

One sentence to Captain. Free to start.

Build it with Captain
Stripe payments to Google SheetsBuild it