Log every Stripe charge in Google Sheets

Add every new Stripe charge to a Google Sheets row with the amount, currency, customer and receipt link, for a running payment log your team can filter.

Last checked

The "Log every Stripe charge in Google Sheets" workflow in Stepper's editor: Stripe: New Charge, then Google Sheets: Create Spreadsheet Row

What it does

You can export payments from the Stripe Dashboard as a CSV whenever you need them. For a daily sales tally, a shared revenue tracker or a commission sheet, a sheet that fills itself in as charges happen saves the export and the copy-paste.

This workflow adds a row to your Google Sheet for every new Stripe charge, with the time it was created (as a Unix timestamp), the charge ID, the amount, the currency, the customer's name and email, the description and a link to the receipt.

The steps

  1. Stripe: New Charge

    Starts the workflow when a new charge is created in your Stripe account.

  2. Google Sheets: Create Spreadsheet Row

    Adds a row with the created time as a Unix timestamp, the charge ID, amount in the smallest currency unit, currency, customer name and email, description and receipt link.

What you need connected

You also need a Stepper account. Each app's page lists every trigger and action Stepper has for it.

How to set it up

  1. Sign in to Stepper, or create a free account.
  2. Create a Google Sheet with these headers in the first row: Created, Charge ID, Amount (cents), Currency, Customer name, Customer email, Description, Receipt.
  3. Click Use this template in Stepper. Stepper copies the workflow into your account and asks you to connect Stripe and Google Sheets if you haven’t already.
  4. In the Google Sheets step, choose your spreadsheet and worksheet. The columns are already mapped.
  5. Make a small real charge (you can refund it afterwards) and run a test. Check the row, then click Publish.

What you can change

  • Amounts. Stripe records amounts in the smallest currency unit, so a 25.00 USD charge arrives as 2500. Add a formula column that divides by 100. Zero-decimal currencies such as JPY already arrive as whole amounts, so leave those as they are.
  • Dates. Stripe sends the created time as a Unix timestamp in seconds, such as 1763251200. To show it as a date, add a column with =A2/86400+DATE(1970,1,1) and format it as a date (the result is in UTC).
  • Which charges get a row. Put a condition on the rule before the Sheets step, such as a particular description or amount, so only those charges are logged.
  • More detail. Use Stripe’s Find Customer action to add other customer details to the row.

See all workflow templates