Between streaming services, SaaS tools, cloud storage, and every free trial that quietly converted into a paid plan, most people and small businesses are paying for more subscriptions than they can name off the top of their head. Every one of those charges triggers a receipt or confirmation email, but those emails pile up in your inbox instead of turning into something useful.
In this guide, we'll walk through how to automatically capture every subscription payment confirmation email and log it as a row in a Google Sheets budget tracker, so you always know exactly what you're paying for and when it renews.
Why Subscription Costs Get Out of Control
Subscription pricing is designed to be forgettable. Charges are usually small individually, billing cycles don't line up, and the confirmation email gets buried the moment it arrives. Without a central log, it's nearly impossible to answer a simple question: how much am I actually spending on subscriptions this month, across every card and every vendor?
A bank statement helps, but it only shows a merchant name and an amount, not what the charge was for or when it renews next. The payment confirmation email, on the other hand, usually contains the exact service name, the plan tier, the amount, and often the next billing date. That makes email the best source of truth for a subscription tracker.
Step-by-Step: Automating Your Subscription Tracker
1. Create a Gmail Filter and Label for Billing Emails
In Gmail settings, create a filter that catches subscription and billing receipts. Match on subject keywords like "Your receipt", "Payment confirmation", "Your subscription", or "Invoice", and include known senders such as no-reply@netflix.com, receipts@stripe.com, or service@paypal.com. Apply a label called "Subscriptions" to anything that matches.
2. Build Your Subscription Tracker Sheet
Create a new Google Sheet named "Subscription Tracker" with column headers in Row 1: Date Charged, Merchant/Service Name, Plan or Description, Amount, Billing Frequency, and Next Renewal Date.
3. Connect Mail Sheet to the Subscriptions Label
Open the sheet and go to Extensions > Mail Sheet > Open. Select the "Subscriptions" label as your source folder. Mail Sheet reads every matching email and writes the extracted fields directly into new rows, so nothing needs to be typed in by hand.
4. Use AI Mode to Handle Every Vendor Format
Netflix, a SaaS tool, and a Stripe-generated invoice all format their receipts completely differently. Rather than building separate rules for each one, switch Mail Sheet to AI Mode with a prompt like:
"Extract the Merchant or Service Name, the Plan or Product Description, the Charge Amount as a numeric value, the Billing Frequency (monthly or yearly), and the Next Renewal Date if mentioned. Format the amount without a currency symbol and the date as YYYY-MM-DD."
Because the AI understands context instead of matching a rigid layout, it works whether the receipt is a simple text email from a small SaaS tool or a detailed HTML invoice from a larger platform like Stripe or PayPal.
5. Automate Recurring Runs
Schedule Mail Sheet to check the "Subscriptions" label automatically, for example once a day. New charges get appended to your tracker as they arrive, so your spreadsheet stays current without you ever opening the label manually.
Turning Raw Data Into a Real Budget Tool
Once charges are flowing into Sheets automatically, the tracker becomes more than a log. Add a Category column (Software, Entertainment, Cloud Storage) to break spend down by type. Use a pivot table to see which vendor costs the most annually. Set a conditional formatting rule that highlights any charge above a certain amount, so a surprise price increase doesn't slip past unnoticed. For freelancers and small businesses, the same sheet doubles as a ready-made expense record for tax season.
Frequently Asked Questions
Can this catch subscriptions billed through Apple, Google Play, or a bank statement instead of email?
Mail Sheet works from Gmail, so it can only capture charges that generate a receipt or confirmation email. Most SaaS tools, streaming services, and Stripe or PayPal powered subscriptions send an email receipt automatically. App store purchases through Apple or Google Play also send confirmation emails to the address linked to that account. Charges that only appear on a bank or credit card statement without any email receipt won't be caught, so for full coverage pair this workflow with a periodic manual check of your statement.
How does Mail Sheet handle receipts from many different subscription services with different formats?
Every vendor formats their receipt emails differently: Netflix, a SaaS billing tool, and a Stripe-generated invoice all look nothing alike. Mail Sheet's AI Mode reads the content of each email rather than matching a fixed template, so it can pull out the merchant name, charge amount, and billing date regardless of layout. This means you can route dozens of different subscription services into a single Gmail label and still get consistent, clean rows in your spreadsheet.
Can I get alerted automatically when total subscription spend crosses a budget threshold?
Yes. Once your charges are logged as rows in Google Sheets, you can add a SUM formula that totals the Amount column by month, then use Google Sheets' built-in conditional formatting or a simple notification rule to flag when that total exceeds your budget. Combined with Mail Sheet's automatic scheduled runs, this gives you a near real-time early warning system for subscription creep without checking your bank statement manually.