# Subscription Tracker: Keep renewals and monthly spend current in the Google Sheet you already use, without hunting rows by hand.

Source: https://zentor.ai/use-cases/google-sheets-subscription-tracker

Subscription tracker spreadsheet for Google Sheets: log new charges in plain English, verify the sheet, get a renewal pass before cards are hit.

## Prompt

```text
Add Notion AI at $20/month renewing on the 12th to the Subscription Tracker sheet, card ending 4242, and mark it Active.
```

Variations:

- **Price change**: On the Subscription Tracker sheet, update Netflix to $22.99/month and note that the price changed this billing cycle.
- **Cancel / pause**: Mark Adobe Creative Cloud as Cancelled on the Subscription Tracker sheet, keep the last charge date, and set renewal to blank.
- **Next 7 days renewals**: Read the Subscription Tracker sheet and list every Active subscription renewing in the next 7 days, with amount and card last four.

## How it works

1. **Say what changed**: New service, price bump, cancel, or "what renews this week." Plain English is enough; you do not point at cells.
2. **Zentor finds the row and writes the fields**: It opens your Subscription Tracker sheet, matches the service name you use, and writes amount, renewal day, status, or card note into the columns you already have.
3. **Get a change summary checked against the sheet**: After the write, Zentor reads the sheet back and lists what changed, so a wrong row does not sit there until the next invoice.

## What you can track

- New services: Name, price, renewal day, and status land in the right columns.
- Price changes: Update the amount and keep a short note when a plan jumps.
- Cancels and pauses: Flip status without deleting history you still want for last quarter.
- Upcoming renewals: List Active rows hitting in the next week before the card is charged.
- Monthly spend rollups: Pull Active totals by category when someone asks what the stack costs.
- Card last-four notes: Keep which card pays which tool without storing full numbers.

## Comparison

| Feature | Manual Sheet | Subscription tracker app | Zentor |
|---|---|---|---|
| Where the roster lives | Your Sheet, edited by hand | Vendor app, often bank-linked | Your Google Sheet, updated for you |
| Logging a new charge | Find a blank row, type, repeat | Wait for bank sync or tap through the UI | One sentence covers service, price, and renewal |
| Setup | Build the grid as the stack grows | Connect accounts and hope merchants match | Point at the sheet you already use |
| Who can open the source of truth | Anyone with the Sheet link | People who have the app login | Same Sheet link; automation on top |

## FAQ

### What is a subscription tracker in Zentor?

It is your existing Google Sheet for recurring services, updated from plain English instead of row-by-row edits. Zentor reads the layout you already use, writes the fields you ask for, and returns a verified change summary.

### Do I need a new subscription tracker template?

No. Keep the sheet you already run. Common columns are service, amount, billing cycle, renewal date, status, and card last four; Zentor adapts to the names you already use.

### How is this different from Rocket Money or subscription tracker apps?

Those apps want bank login and keep the roster inside their product. This tracker stays in Google Sheets, so finance can open the same file without another account, and you are not migrating years of notes into a consumer app.

### Can Zentor see my bank transactions?

No bank link is required for the Sheet workflow. You tell it what changed, or paste a short note list; it writes into the spreadsheet you point at.

### Can the subscription tracker run on a schedule?

Yes. A common setup is a Monday morning list of Active renewals in the next seven days. You can still send a one-off add or cancel any time.

### What do I get back after an update?

A short change summary: which service moved, the new amount or status, and which sheet was touched, after Zentor re-reads the file.