---
name: google-workspace-unused-subscriptions
description: "Monthly: every software subscription in your receipts and books, checked against Google sign-ins and Slack links, with the ones unused for 60 days. Use when the user asks for this, or when it runs on a schedule."
---

# Tools you pay for but nobody uses: receipts, books and Google sign-ins

Monthly: every software subscription in your receipts and books, checked against Google sign-ins and Slack links, with the ones unused for 60 days.

Software spend leaks quietly. Someone starts a trial for one project, it rolls into a paid plan on a company card, the project ends and the charge does not. The receipts sit in Gmail, the charges sit in the books, and nobody joins them to whether anyone still logs in.

Once a month the agent builds the list of tools you pay for from receipts and expenses, cleans up the vendor names so "NOTION LABS INC" and billing@mail.notion.so are one tool, and checks each against Google Workspace's record of third-party sign-ins and links shared in Slack. Tools with no sign of use in 60 days come back as a short list with their monthly cost, and the agent asks which to put on a cancel list.

## Two ways to get the data

Use the API or MCP route when you have an MCP server, a CLI or an API token for the app. Otherwise, if you can drive a browser the user is signed in to (Claude in Chrome, a Playwright or Chrome DevTools MCP server), use the browser route. Say which one you used.

## Route A: API or MCP server

### What you need

- A Google Workspace admin with the Reports privilege, through the read-only scope `admin.reports.audit.readonly`.
- Read access to the mailbox where receipts land (often a shared billing address) and to QuickBooks or Xero expenses.
- Optionally, a Slack user token with `search:read`, and an alias list for vendor names the rules cannot merge.

If something is missing, say what and stop; do not invent numbers.

### Steps

1. **Collect paid tools from receipts** (Gmail): Search with `users.messages.list` and `q: (subject:(receipt OR invoice) OR from:(billing OR receipts OR invoice)) newer_than:95d`. From each message read the sender domain, amount, currency and date. Two charges about a month apart mean monthly; one charge in the window with "annual" or "yearly" in it means annual, divided by 12.
2. **Add vendors from the books** (QuickBooks): QuickBooks: `SELECT * FROM Purchase WHERE TxnDate >= '<95 days ago>'` and the same for `Bill`, grouped by `EntityRef` name, kept to software or subscription expense accounts. Xero: `GET /BankTransactions?where=Type=="SPEND"` and `ACCPAY` `Invoices`, grouped by `Contact.Name`. Whichever ledger you use, keep vendor, monthly amount and last charge date.
3. **Normalize vendor names and merge**: Lowercase, drop `inc`, `llc`, `ltd`, `gmbh`, `.com`, `.io`, card prefixes such as `SQ *`, `PADDLE.NET*`, `FS *` and `PAYPAL *`, and trailing reference numbers; reduce sender domains to the brand (`mail.notion.so` becomes `notion`). Merge receipts and books on that name, using an alias list in settings for the leftovers. In both is confirmed spend; receipts only may be on a personal card; books only has no receipt and goes on a separate line for the bookkeeper.
4. **Check who signed in with Google** (Google Workspace): Call `GET https://admin.googleapis.com/admin/reports/v1/activity/users/all/applications/token?startTime=<60 days ago>` and keep the `authorize` and `activity` events (Grant and API call in the Admin console). Normalize `app_name` the same way and keep, per app, the latest event date and the distinct `actor.email` count.
5. **Look for other signs of use** (Slack): For each tool with no Google events, run `search.messages` with `query: "<vendor domain> after:<60 days ago>"` (for example `figma.com`): shared files, videos and docs mean people still use it. Tools whose login does not go through Google are marked "no sign-in data" rather than unused, for a check on the vendor's admin page.
6. **Anti-join and ask**: A paid tool with no Google sign-in and no Slack links in 60 days is unused. Read the small JSON file kept between runs (`unused-tools.json`) and leave out tools the person chose to keep last time. Post the list with cost, seats and last sign-in, and ask which to put on the cancel list; the agent never cancels anything.

## Route B: the browser

### What you need

- Signed in to Gmail for the receipts mailbox, to QuickBooks or Xero, to Slack, and to the Google Admin console as an admin who can see reports and API controls.

If something is missing, say what and stop; do not invent numbers.

### Steps

Start at https://mail.google.com/mail/u/0/#search/subject%3A(receipt+OR+invoice)+newer_than%3A95d. The user is signed in already; never type passwords or codes, and ask if a sign-in page appears.

1. **List paid tools from receipts**: The URL runs the Gmail search `subject:(receipt OR invoice) newer_than:95d`. Open each sender's latest receipt and note the tool, amount and whether it is monthly or annual (annual divided by 12).
2. **Add vendors from the books**: In QuickBooks open Expenses > Vendors, or in Xero Contacts > Suppliers, and note software vendors charged in the last 95 days that are not on the receipt list. Merge names that are the same company.
3. **Check Google sign-ins**: Open `https://admin.google.com/`, then Security > Access and data control > API controls > Manage Third-Party App Access, and under Accessed apps click View list. For dates, go to Reporting > Audit and investigation > OAuth log events, filter by application name and a 60-day range, and note the latest event per tool.
4. **Check Slack for links**: For each tool with no Google events, search Slack for its domain with `after:` set 60 days back, for example `figma.com after:2026-08-28`. Any shared file or video counts as use.
5. **Report and ask**: List the tools with no sign-in and no Slack links, with monthly cost and seats, and the total. Put tools that use their own login on a separate line. Ask which to cancel; do not cancel anything.

Note: Gmail shows 50 results a page, so a busy billing inbox takes a few pages. The OAuth log keeps about six months of events. The Accessed apps list shows how many users an app has but not when they last used it, which is why the audit log is the page to read for dates.

## The report

- **Monthly cost of unused tools** and how many there are.
- **The list**: tool, monthly cost, seats, last Google sign-in, Slack links in 60 days.
- **No sign-in data**: paid tools that use their own login, to check on their admin pages.
- **Books only**: charges with no receipt in Gmail, for the bookkeeper.
- The ask: which tools go on the cancel list.

## Post it to Briefkin

When `BRIEFKIN_TOKEN` is set, or `~/.config/briefkin/env` exists (the installer from https://briefkin.dev/docs writes it), also send the result to the user's Briefkin board as one card. Keep the `item_key` the same on every run so the card updates in place, use a new `event_id` per run, and put today's real numbers in place of the example ones. If the request fails, say so once and carry on.

```bash
[ -n "${BRIEFKIN_TOKEN:-}" ] || . ~/.config/briefkin/env
curl -sS -X POST "${BRIEFKIN_URL:-https://briefkin.dev}/v1/events" \
  -H "authorization: Bearer $BRIEFKIN_TOKEN" \
  -H "content-type: application/json" \
  -d @- <<'JSON'
{
  "v": 1,
  "event_id": "google-workspace-unused-subscriptions/<date of this run, e.g. 2026-10-16>",
  "item_key": "google-workspace-unused-subscriptions",
  "project": "Acme",
  "source": "Tools you pay for but nobody uses: receipts, books and Google sign-ins skill",
  "kind": "action",
  "title": "$340 a month on 4 tools with no sign-in in 60 days",
  "summary": "Of **23 paid tools** in receipts and QuickBooks, **4** had no Google sign-in and no Slack links in 60 days: **$340 a month**. Three more use their own logins, so their use is unknown.",
  "action": {
    "request": "Which of these should go on the cancel list?",
    "options": [
      "All 4",
      "Calendly and Miro",
      "Check seat use first",
      "Keep all this month"
    ]
  },
  "widget": [
    {
      "type": "Table",
      "props": {
        "columns": [
          "Tool",
          "Per month",
          "Seats",
          "Last Google sign-in",
          "Slack links (60d)"
        ],
        "align": [
          "left",
          "right",
          "right",
          "left",
          "right"
        ],
        "rows": [
          [
            "Calendly",
            "$120",
            10,
            "Jul 30",
            0
          ],
          [
            "Miro",
            "$96",
            12,
            "Aug 11",
            0
          ],
          [
            "Loom",
            "$75",
            5,
            "Jun 2",
            0
          ],
          [
            "Hotjar",
            "$49",
            1,
            "None in 6 months",
            0
          ]
        ]
      }
    },
    {
      "type": "Callout",
      "props": {
        "text": "No sign-in data for Zoom, 1Password and Ahrefs: they use their own logins. Their admin pages show last active dates if you want them checked.",
        "tone": "info"
      }
    }
  ]
}
JSON
```

Widgets come from the Briefkin catalog (https://briefkin.dev/v1/catalog). Without a token, just give the user the report.

## Run it on a schedule

Suggested: 1st of the month at 10:00 (`0 10 1 * *`). From cron, with the agent signed in on that machine:

```bash
0 10 1 * * claude -p "Run the google-workspace-unused-subscriptions skill"
# Codex: codex exec, Gemini CLI: gemini -p, Copilot CLI: copilot -p, OpenCode: opencode run
```

Or use the agent's own scheduler (Claude Code routines, Codex automations, Claude or ChatGPT scheduled tasks): https://briefkin.dev/skills/google-workspace-unused-subscriptions#schedule

Source: https://briefkin.dev/skills/google-workspace-unused-subscriptions
