Copy Stripe payments into Google Sheets automatically

Short answer: Use a free Google Apps Script that copies your Stripe payments into a Google Sheet every hour, with the amount, status and customer email, and never adds the same payment twice. It runs in your own Google account; nothing is sent to us. Setup takes 3 steps: Add your key; Paste the script; Run it.

How to set it up

1. Add your key. In the Apps Script editor, open Project Settings and add the Script property STRIPE_KEY. In Stripe, go to Developers, then API keys, and create a restricted key with Read access to Charges; paste it as the value. Keys stay in the script, never in the sheet.
2. Paste the script. Open Extensions, then Apps Script, paste in the code from our email, and save. Reload the sheet and a Stripe menu appears.
3. Run it. Choose Stripe, then Copy new payments. The Payments tab fills in with the date, charge ID, amount, currency, status, email and description of each payment from the last 90 days. Choose Copy new payments every hour to keep it up to date.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Good to know

• Amounts are shown in the currency's main unit, such as dollars, not cents.
• Each run adds only payments that aren't in the tab yet, matched on the charge ID.
• Refunds show in Stripe on the original charge; this tab keeps the status from when the payment was first copied.

Questions

What does this script do?

It is a free Google Apps Script that copies your Stripe payments into a Google Sheet every hour, with the amount, status and customer email, and never adds the same payment twice.

How do I set it up?

In 3 steps: 1. Add your key; 2. Paste the script; 3. Run it. The full steps are on this page.

Is it free, and does it send my data anywhere?

It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.

Can you install it for me?

Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

Want it wired into QuickBooks, your CRM or your payment system? Send us a short brief.