How to Connect Stripe to Google Sheets

Stripe's dashboard exports to CSV in about two minutes, which answers most one-off finance requests. For recurring reporting you go through the API, and two things quietly produce wrong numbers on the first attempt: amounts arrive as integers in cents, so revenue looks a hundred times too big, and a test-mode key returns an empty or fake dataset that looks like a broken connection. This guide covers both, plus pagination, expansion, and which key to use.

The two-minute option: dashboard CSV export

In the Stripe dashboard open Payments, Invoices or Balance → Payouts, set a date range, and click Export. You can choose which columns to include, and large exports are emailed rather than downloaded directly. Import the file into Sheets via File → Import.

For reconciliation specifically, export balance transactions rather than charges. Balance transactions include fees, refunds, disputes and payout timing, which is what actually reconciles against your bank; a charges export shows gross amounts and will not tie out.

Stripe to Google Sheets for free (Apps Script + API)

Create a restricted key under Developers → API keys rather than using your secret key. Grant read-only permissions on just the resources you need. A restricted key that leaks through a shared sheet cannot issue refunds or create charges; a secret key can do both.

Stripe's API is form-encoded rather than JSON for requests, uses the key as basic-auth username with an empty password, and paginates by cursor: read has_more, then pass the last object's ID as starting_after.

1function importStripeCharges() {2  const KEY = "rk_live_XXXXXXXXXXXX";   // restricted, read-only3  // Live keys see live data only; a test key returns test data only.4 5  const headers = {6    Authorization: "Basic " + Utilities.base64Encode(KEY + ":")7  };8 9  // Zero-decimal currencies are already whole units. Dividing these by 10010  // understates revenue by 100x, the mirror of the usual cents mistake.11  const ZERO_DECIMAL = ["JPY","KRW","VND","CLP","ISK","BIF","DJF","GNF",12                        "KMF","MGA","PYG","RWF","UGX","VUV","XAF","XOF","XPF"];13 14  const rows = [];15  let startingAfter = null;16 17  do {18    let url = "https://api.stripe.com/v1/charges?limit=100"19      + "&expand[]=data.customer";        // else customer is just an ID string20    if (startingAfter) url += "&starting_after=" + startingAfter;21 22    const res = JSON.parse(23      UrlFetchApp.fetch(url, { headers: headers, muteHttpExceptions: true })24        .getContentText()25    );26    if (res.error) throw new Error(res.error.message);27 28    res.data.forEach((c) => {29      const cur = (c.currency || "").toUpperCase();30      const amount = ZERO_DECIMAL.indexOf(cur) === -1 ? c.amount / 100 : c.amount;31      rows.push([32        c.id,33        new Date(c.created * 1000),        // epoch seconds, not milliseconds34        amount,35        cur,36        c.status,37        c.customer ? (c.customer.email || c.customer.id) : "",38        c.refunded,39      ]);40    });41 42    startingAfter = res.has_more ? res.data[res.data.length - 1].id : null;43  } while (startingAfter);44 45  const header = ["Charge ID","Created","Amount","Currency","Status","Customer","Refunded"];46  const ss = SpreadsheetApp.getActiveSpreadsheet();47  const sheet = ss.getSheetByName("Stripe") || ss.insertSheet("Stripe");48  sheet.clearContents();49  sheet.getRange(1, 1, 1, header.length).setValues([header]);50  if (rows.length) {51    sheet.getRange(2, 1, rows.length, header.length).setValues(rows);52  }53}

Two more details in that code. Stripe timestamps are Unix epoch seconds, so they need multiplying by 1000 before JavaScript reads them as dates; forgetting produces dates in 1970. And expand[]=data.customer is what turns the customer field from an opaque ID into an object with an email on it.

Limits: Apps Script's six-minute cap means high-volume accounts need chunking by date using the created[gte] and created[lte] filters. Stripe is read-only here by design, and this is one connector where write-back is not something you want.

Stripe Sigma

Sigma lets you run SQL directly against your Stripe data inside the dashboard, with scheduled queries and CSV output. If your questions are genuinely SQL-shaped, joining charges to subscriptions to customers with window functions, Sigma answers them more cleanly than assembling the same thing from API calls. It is billed on usage, and getting results into Sheets still means exporting or forwarding the output, so it complements a Sheets connector rather than replacing one.

The Brooked method

Brooked handles the cursor pagination, converts amounts using each charge's own currency so zero-decimal currencies stay correct, converts epoch timestamps to real dates, and expands customers so you get emails rather than IDs. Charges, invoices, subscriptions, customers and balance transactions can all land in one spreadsheet on a single schedule.

Step 1: Install Brooked

Install Brooked from the Google Workspace Marketplace. Free tier includes 100 imports per month, no credit card required.

Step 2: Connect Stripe

Choose Stripe in Brooked and paste a restricted, read-only API key. Confirm it is a live key if you want live data. Then pick the object you want, charges, invoices, subscriptions, customers or balance transactions, and import.

Step 3: Schedule the refresh

Set the import to re-run hourly, daily or weekly so MRR and revenue tables rebuild themselves. A scheduled re-read also captures refunds and disputes raised against older charges, which an append-only webhook feed would never revisit.

Brooked AI, Stripe

Live

Ask anything about your Stripe data…

Method comparison

Common use cases

• MRR and ARR reporting: build recurring revenue tables from subscriptions rather than eyeballing the dashboard
• Revenue reconciliation: pull balance transactions with fees and payouts to tie out against the bank
• Churn analysis: track cancelled subscriptions by plan, cohort and reason
• Failed payment recovery: list past-due invoices for the team chasing them
• Board reporting: combine Stripe revenue with pipeline or spend data already in the sheet

Troubleshooting common issues

Related Articles

• NetSuite Chrome Extension for Google Sheets
• How to Connect Sage Intacct to Google Sheets
• How to Consolidate Multiple QuickBooks Companies in One Google Sheet

Frequently asked questions