Home/ Marketplace/ Stripe/ Stripe → Google Sheets
Stripe
Google Sheets

Reporting Integration

Stripe → Google Sheets Integration

Every completed Stripe payment, as a row in your own spreadsheet — gross, fee, net, customer and what they bought. No exports, no downloads, no month-end scramble.

Free Trial
£6.99
per month after 1 month free trial
Start Free Trial
💳 Platform: Stripe 📊 Destination: Google Sheets 📱 Full support included ♻ Free updates included ❌ Cancel anytime

What It Does

The Stripe dashboard is excellent at showing you one payment. It is far less good at showing you your business — and the moment you want your numbers in your own shape, you are exporting a CSV, opening it in a spreadsheet, and doing it all again next month.

This integration keeps a Google Sheet permanently in step with Stripe. Your existing payment history is imported when we set it up, and from then on each new completed payment is added as a row on its own — usually within minutes. You build whatever you want on top: pivot tables, monthly summaries, a dashboard, a tab your accountant reads.

  • Your Stripe history backfilled into the sheet at setup
  • New completed payments added automatically, never duplicated
  • Stripe’s fee and your net amount alongside the gross
  • Customer name, email, currency and line items on every row
  • Refunds reflected so the sheet does not overstate your takings
  • Your own columns, formulas and extra tabs are left alone

How It Works

1
Connect Stripe and Your SheetRead-only access to Stripe, and edit access to the one Google Sheet you nominate. Nothing else in your Drive is touched.
2
Your History Is ImportedWe agree how far back to go and fill the sheet in one pass, so you start with a complete picture rather than an empty tab.
3
It Keeps Itself CurrentEvery new payment is appended as it happens. Open the sheet whenever you like — it is already up to date.

Frequently Asked Questions

What's the cost to run this?

£6.99 per month after a free first month. That covers the integration, ongoing updates and support — no per-row or per-payment fees on top.

Does it import the payments I've already taken?

Yes. We agree how far back you want to go — a year, or everything — and backfill the sheet in one pass at setup, so you begin with your full history rather than an empty tab. After that it only ever adds new payments.

What columns do I get?

The defaults cover what most people need:

\n
    \n
  • Date and time of payment
  • \n
  • Customer name and email
  • \n
  • Gross amount and currency
  • \n
  • Stripe fee and net amount received
  • \n
  • What was bought — line items or the payment description
  • \n
  • Status, and the Stripe reference so you can find it in your dashboard
  • \n
\n

If you want a different set, tell us at setup and we will shape it to how you actually work.

What credentials do you need?

Two things, both narrow. From Stripe, read-only access that cannot move money, issue refunds or change your account. From Google, edit access to the single sheet you nominate — not your Drive, not your other files. Both can be revoked by you at any time, and we walk you through each one.

Can I add my own columns and formulas?

Yes, and that is rather the point. New payments are appended as rows, so anything you build — extra columns to the right, additional tabs, charts, pivot tables reading from the data — keeps working. We only ever write to the columns we own.

How are refunds handled?

A refunded payment is reflected in the sheet rather than left showing as full revenue, so your totals do not overstate what you actually kept. Partial refunds are shown as the amount actually refunded. We confirm the exact treatment with you at setup so it matches how your bookkeeping works.

What about failed or incomplete payments?

They are ignored by default — a sheet full of abandoned checkouts helps nobody. If you want them logged, perhaps to see how often cards are declining, we can add them on a separate tab.

Does it handle more than one currency?

Yes. Each row records the currency it was actually taken in, alongside the amount and fee, so multi-currency accounts stay honest. We do not silently convert everything to pounds — if you want a converted column as well, we can add one.

How quickly does a new payment appear?

Usually within a few minutes of the payment completing. It is a continuous sync rather than an instant one — if a payment ever arrives late, the next pass picks it up, so nothing is quietly lost.

Can I use this to feed my accountant, or Xero and QuickBooks?

Plenty of people do exactly that — a shared Google Sheet is the easiest thing in the world to give an accountant, and it is always current. If you would rather push straight into Xero or QuickBooks instead, that is bespoke work rather than this product. Get in touch and we will quote it.

What if I edit or delete a row by accident?

Nothing breaks. We track payments by their Stripe reference rather than by row position, so sorting, filtering or removing rows will not cause the same payment to be written twice. If you delete something you wanted, ask and we will re-import it.

How does cancellation work?

You can cancel any time with 30 days' notice. The sync carries on during the notice period and then stops. The sheet is yours and stays exactly where it is, with everything already in it — it simply stops receiving new rows.

Who are Receptive?

A UK-based development company — Receptive Ltd — with offices in Cardiff and Cheltenham. Led by Ben Johnson, with over two decades' experience in web development and eCommerce integration.

Related Products

Free Trial
£6.99
per month after 1 month free trial
Start Free Trial
💳 Platform: Stripe 📊 Destination: Google Sheets 📱 Full support included ♻ Free updates included ❌ Cancel anytime

Questions before you start?

Get in touch and we'll get back to you within 24 hours.

Contact Us
WordPress Figma Framer Wix Contentful