I will build a stripe to google sheets revenue dashboard with auto sync


About this gig
Stripe's dashboard shows you numbers. It doesn't let you work with them. I'll set up an automatic sync that pulls your Stripe payments, refunds and subscriptions into your own Google Sheet, ready for analysis, reporting or your accountant. No ChartMogul or Baremetrics subscription needed.
What you get:
- Payments with amount, refunds, status, customer ID and description
- Subscriptions with status, start and cancel dates, plan and seats
- Automatic refresh on your schedule
- Premium: a summary tab with MRR, paying subscriptions and 30-day revenue, refunds and net
- Secure: you create a read-only restricted key in Stripe, and it stays in your sheet. I never need your Stripe login.
MRR rules are written down, not guessed: active and past-due subscriptions count, trials don't, yearly plans are divided by 12, and taxes, discounts and metered usage are left out.
The script runs inside Google Sheets. It's yours to keep, with no recurring fees.
AI-assisted development, tested on a live Stripe account before delivery.
Not sure which package fits? Message me your rough number of payments per month.
Get to know Majkee
- FromSlovakia
- Member sinceMay 2025
Languages
English, Slovak
FAQ
Is it safe to give the script a Stripe key?
Yes. You create a restricted key that can only read charges and subscriptions. It can’t move money, issue refunds or change anything, and it stays in your own Google Sheet. I never see it.
How is MRR calculated?
Active and past-due subscriptions, normalised to one month (yearly ÷ 12), per currency. Trials, discounts, taxes and metered usage are excluded. If you use a different definition, message me before ordering.
Do I need a paid tool or app?
No. The sync runs on Google Apps Script, which is free within Google’s usage limits. There are no subscriptions.
What if the sync stops working later?
Every package includes revisions. After delivery, message me and I’ll look at it. Small fixes are usually quick.

