Skip to content

Subscription Audit

Example prompt: "Search my Gmail for subscription receipts and recurring payment confirmations from the last 3 months. List every subscription with its cost and billing frequency in a Google Sheet, and highlight anything over £10/month."

How to automate subscription auditing with GloriaMundo

The Problem

Most people underestimate how many subscriptions they pay for. A streaming service here, a cloud storage plan there, that productivity app you signed up for during a free trial six months ago. Each one sends a receipt email that you archive without reading. Over time, these small charges accumulate into a meaningful monthly expense that nobody ever sits down to audit — because doing so means searching through hundreds of emails, identifying which are recurring, working out the billing frequency, and deciding which you actually use. It is dull enough that it never rises to the top of the to-do list, even though it could save a noticeable amount of money.

How GloriaMundo Solves It

We build a workflow that searches your Gmail for common receipt and payment confirmation patterns over the past three months. An LLM step analyses the email subjects and bodies to identify recurring subscriptions, extracting the service name, amount, currency, and billing frequency (monthly, annual, etc.) from each. A code step deduplicates the list, normalises amounts to a monthly equivalent, and calculates the total monthly and annual spend. An integration step writes the full audit to a Google Sheet — one row per subscription, sorted by cost, with a column flagging anything above your chosen threshold. Glass Box preview shows you the complete audit before the spreadsheet is created, so you can spot any misidentified emails or missing subscriptions.

Example Workflow Steps

  1. Trigger (manual): You run the workflow when you want to audit your subscriptions — monthly or quarterly.
  2. Step 1 (integration): Search Gmail for emails matching common receipt patterns (e.g. "receipt", "payment confirmation", "subscription renewed", "billing statement") from the last 3 months.
  3. Step 2 (llm): Analyse each email to extract the service name, amount charged, currency, and billing frequency. Filter out one-off purchases.
  4. Step 3 (code): Deduplicate entries, normalise all amounts to monthly equivalents, calculate total monthly and annual spend, and flag subscriptions above the user-specified threshold.
  5. Step 4 (integration): Create a Google Sheet with the full audit — columns for service name, monthly cost, annual cost, billing frequency, and a flag column for high-cost items.

Integrations Used

  • Gmail — source of subscription receipt and payment confirmation emails
  • Google Sheets — destination for the structured audit report

Who This Is For

Anyone who suspects they are paying for subscriptions they have forgotten about — which is most people. Particularly useful after a year of signing up for free trials, or when you are tightening your personal budget and want a clear picture of recurring costs.

Time & Cost Saved

Manually searching through emails and compiling a subscription list takes 1–2 hours and is tedious enough that most people never do it. This workflow produces a complete audit in a few minutes. Identifying even one or two forgotten subscriptions typically saves £10–30 per month. The workflow uses integration, LLM, and code steps, costing a few credits per run.