Weekly

Get a weekly OneDrive storage report

Each Monday you see how much storage you're using and which files changed last week.

Runs: Weekly
Apps: OneDrive
AI: Not needed
Access: read

Send this to your assistant

Create a ClickRuntime automation: every Monday at 9am, email me my OneDrive storage used and a list of files changed in the last 7 days.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Add to ChatGPT Add to Claude

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

An IT administrator at a firm of 60 people notices OneDrive storage is almost full and has no idea why. A few users keep video projects, someone synced an entire photo library, and a shared folder doubled in size over a month. Meanwhile managers cannot say which important documents were touched last week, because OneDrive offers no single view of changes across the drive.

Every week, the drive's quota is read (total, used, remaining and deleted items), then the delta feed is run from last week's saved token to list the files added, edited, moved or removed since. The report goes out as one email with the storage numbers and a list of changed files, and the new token is stored for next time.

It is useful for IT admins, small business owners and team leads who share a drive and want to see activity at a glance.

What you get out of it

Storage problems seen before they bite
Seeing usage climb from 70 to 85 percent over three weeks gives you time to clean up or buy space, rather than discovering the limit when saving fails. That early warning gives you time to archive, clear out or buy more space on your own terms, not in a panic.
Growth has a visible cause
The list of recent changes points to the folder or person behind a sudden jump, which makes the conversation about cleaning up concrete. That means you can speak to the person responsible with facts at hand, and you can decide what to archive.
Important changes are not missed
If a contract or a price list was edited or deleted this week, it appears in the report, which helps catch accidental overwrites quickly. That is a useful safeguard, since a file can often be restored when you act within days and not months.
No manual digging through folders
Gathering this data by hand means sorting by size and date across folders. A weekly email provides it without any investigation. A weekly email does this work for you and puts the answer in front of you every Monday.
Trends are easy to compare
A series of weekly reports shows storage trends and activity patterns, which supports decisions about licenses and quotas. This evidence helps when you are deciding whether to buy extra licenses or ask staff to archive old work.

How it works

What happens, step by step

Every Monday, ClickRuntime checks how much of your OneDrive storage you are using.
It lists the files that changed since last Monday's report.
You get one email with your storage use, such as "412.6 GB of 1024 GB (40%)", and the changed files.

Before it runs live

Connect OneDrive

What you get

RunsWeekly

Get a weekly OneDrive storage reporttoday, 9:00Succeeded

Email · OneDrive this weekStorage: 412.6 GB of 1024 GB (40%) 14 files changed: Northwind budget.xlsx, Acme proposal.docx…

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.

Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

Run it at a different time, more or less often, or only on weekdays
Add an AI step, for example to summarize, sort or draft a reply
Add another app, for example also send it to Slack
Combine it with other OneDrive steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.

weekly_storage_and_change_report.pyexample

from clickruntime import on_trigger, credentials, http, state, notify

GRAPH = "https://graph.microsoft.com/v1.0"

@on_trigger
def run(event):
    h = {"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"}
    quota = http.get(f"{GRAPH}/me/drive", headers=h).json()["quota"]
    url = state.get("delta_link") or f"{GRAPH}/me/drive/root/delta?token=latest"
    changed = []
    while url:
        res = http.get(url, headers=h).json()
        changed += [i["name"] for i in res["value"] if "file" in i]
        url, delta = res.get("@odata.nextLink"), res.get("@odata.deltaLink")
    state.set("delta_link", delta)
    used = f"{quota['used'] / 1e9:.1f} GB of {quota['total'] / 1e9:.0f} GB ({quota['used'] / quota['total']:.0%})"
    notify.email_me("OneDrive this week", f"Storage: {used}\n\n{len(changed)} files changed:\n" + "\n".join(changed[:50]))
    return {"changed": len(changed)}

FAQ

Common questions

How are deleted files represented?

The change feed marks removed items as deleted. They are listed in the report by name where OneDrive still returns it, and the quota figure also shows how much space deleted items are still taking.

Does it report every single edit on a file?

No. It reports each file that changed at least once since the previous run, with its latest state, not every individual save. A document saved fifty times shows as one modified entry. Each file is listed once, which keeps the report compact even on a busy drive.

Does it cover the whole drive or one folder?

The delta runs against the drive you authorize, so it reports on all files within it. If you only want one folder, the run can be pointed at that folder's delta feed instead. Pointing at one folder is a simple option to request.

What permissions does it need?

read. Nothing else in your accounts is used.

Does it need AI?

No. It runs without AI, so it doesn't use your plan's AI allowance.

How many runs does it use?

One run each time it runs (weekly). Checks that find nothing to do and stop right away aren't counted.

Can I change how it works?

Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Weekly