A webhook-driven automation that logs every successful Stripe payment, refund, and subscription event into a tidy Google Sheet in real time.
No-Code & AutomationPDF · 6 pages· v1.0
4.3Stop exporting CSVs from the Stripe dashboard every week. This guide shows you how to build an automation that listens to Stripe webhooks and appends a clean row to a Google Sheet the moment a payment succeeds, a charge is refunded, or a subscription changes. You get a live, shareable revenue log your whole team can read without Stripe access. The guide is built for solo founders, finance-curious operators, and agencies managing client accounts. It covers two implementation paths so you can pick what fits: a no-code path using Zapier or Make, and a near-zero-cost path using n8n. Both are explained with the exact field mappings you need. Most important, the guide teaches you to verify the Stripe webhook signature so nobody can forge fake payment rows into your sheet, and how to handle Stripe's amounts (which arrive in cents) so your totals are actually correct. It also explains idempotency so a retried webhook never double-logs the same payment. After completing it you will have a self-updating Google Sheet with columns for date, customer email, amount, currency, status, and the Stripe object ID, ready to pivot, chart, or feed into your bookkeeping.
Webhooks only fire for new events. The guide includes a short appendix on backfilling past payments with a one-time export or a paginated API pull, so your sheet starts complete.
Yes, when you verify the signature. The guide walks through validating the Stripe-Signature header so only genuine Stripe events are written. Without this, anyone could POST fake rows.
Yes, and the guide explains it. Test and live use separate signing secrets and separate endpoints. You will typically build against test mode, then duplicate the endpoint for live.
Stripe reports amounts in the smallest currency unit (cents for USD). The guide shows the divide-by-100 step and the zero-decimal currency exceptions like JPY.
Read the full refund policy and trust & safety terms.