Daily

Get alerted about rows that need action

You get the rows that match your rule, like students marked absent, with the context you need.

Runs: Daily
Apps: Microsoft Excel
AI: Not needed
Access: read (Files.Read)

Send this to your assistant

Create a ClickRuntime automation: every school day at 10am, check my Attendance table and email me the students marked absent today, with their total absences this term.

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

A teacher keeps attendance in an Excel workbook. A warehouse lead tracks stock levels, and an office manager tracks contract renewal dates. In each case somebody has to open the file every morning, scan hundreds of rows, and spot the few that matter: students absent today, items below the reorder point or contracts expiring in 30 days. On busy days nobody looks, and the row that needed action waits.

Each day, ClickRuntime reads the rows in your workbook, filters them on the condition you describe, updates counters such as the number of days absent so far, and emails you the matching rows. If nothing matches, you can choose to get a short confirmation or nothing at all.

It suits anyone who already keeps important lists in Excel and wants to be told about the exceptions.

What you get out of it

Problems reach you without a morning ritual
The rows that need action arrive in your inbox, so checking the workbook becomes unnecessary. You start the day with the exceptions, not with a search through hundreds of lines.
Students and customers are followed up sooner
A pupil absent for three days in a row, or an invoice overdue by a week, is easier to deal with when you hear about it today. Early contact usually prevents bigger issues.
Counters give you the pattern
Updating a running count, such as total absences, shows who is becoming a concern rather than who simply missed a day. That supports better decisions about when to step in.
Your existing file keeps working
You do not have to move your data into a new system. The workbook stays as it is, and the alert is built on top of it, so there is nothing for colleagues to learn.
Consistent rules are applied
A person scanning rows might apply the rule differently on different days. The filter applies the same condition every time, so decisions are fair and comparable. Fairness matters most when the rows involve people.
Missed deadlines become rare
Contract renewals, warranty ends and certification dates are easy to forget. A daily list of what is coming up means these items are handled before they cause costs or compliance gaps.

How it works

What happens, step by step

Every day, ClickRuntime reads the rows of your Excel table.
It picks out the rows that match your rule, such as students marked absent.
It keeps a running count for each person, so you can see how often it has happened.
You get an email listing each match with its context, such as "Alex Kim (7B) – absent 4 times so far".

Before it runs live

Connect Microsoft Excel

What you get

RunsDaily

Get alerted about rows that need actiontoday, 9:00Succeeded

Email · 3 marked absentAlex Kim (7B) – absent 4 times so far Priya Shah (8A) – absent 1 times so far

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 Microsoft Excel 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.

alerts_from_rows_that_meet_a_condition.pyexample

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

SHEET = "https://graph.microsoft.com/v1.0/me/drive/items/01ABCDEF.../workbook/worksheets/Attendance"

@on_trigger
def run(event):
    values = http.get(f"{SHEET}/usedRange", headers={"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"},
                      params={"$select": "values"}).json()["values"]
    header, rows = values[0], [dict(zip(values[0], r)) for r in values[1:]]
    absent = [r for r in rows if str(r.get("Status", "")).lower() == "absent"]
    counts = state.get("absences") or {}
    for r in absent:
        counts[r["Name"]] = counts.get(r["Name"], 0) + 1
    state.set("absences", counts)
    if absent:
        notify.email_me(f"{len(absent)} marked absent", "\n".join(f"{r['Name']} ({r.get('Class', '')}) – absent {counts[r['Name']]} times so far" for r in absent))
    return {"absent": len(absent)}

FAQ

Common questions

What kinds of conditions can I use?

Anything you can express about the cells in a row: a date is today or earlier, a number is below a limit, a status equals a certain word, or a combination of those. Describe the rule to your AI assistant and review it before approving.

Does the workbook need to be in a specific format?

The data should be in an Excel table or a clear range with a header row on OneDrive or SharePoint, so each column has a name. Consistent headers make the conditions easier to write and less likely to break.

What if no rows match on a given day?

You can choose between getting no email, which keeps your inbox quiet, or a short note saying nothing matched, which confirms that the check ran. The run log in the ClickRuntime dashboard also shows it completed.

What permissions does it need?

read (Files.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 (daily). 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.

Daily