Every 10 minutes

Get an email for each new Excel row

Each row added to your table reaches your inbox within minutes.

Runs: Every 10 minutes
Apps: Microsoft Excel
AI: Not needed
Access: Files.Read

Send this to your assistant

Create a ClickRuntime automation: every 10 minutes, email me any new rows added to my Excel Leads table with all their columns.

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

Shared Excel files are where small teams keep requests, bookings, expense claims and sign-ups, and the person who has to act on a new entry is often not watching the file. A row appears, and it sits there until someone happens to open the workbook. A customer waits for a quote, an expense approval stalls, and a reply that would have taken two minutes takes two days.

Every 10 minutes, ClickRuntime reads the table, compares the number of rows with the figure stored from the last check, and emails you the rows that are new. If the count has not changed, nothing is sent. It works for any Excel table stored in OneDrive or SharePoint.

It is a lightweight way to turn a plain spreadsheet into something that notifies the right person.

What you get out of it

Requests are answered the same day
The person responsible hears about a new entry within minutes, so a request is not left unseen for days. Customers and colleagues get faster replies. That speeds up everything that follows.
No need to keep checking the file
Opening a workbook repeatedly to see if anything changed wastes time and attention. An email only when something is added removes the habit entirely. It also removes the worry that something was missed.
Works with the tools people already use
Teams do not have to move to a new system. The workbook stays the place where data is entered, and the notification is added without changing how anyone works. That keeps adoption easy for everyone on the team.
Approvals keep moving
An expense claim or leave request that arrives in the workbook reaches the approver quickly. Fewer items sit unseen, so decisions happen before deadlines. That keeps things moving for the people waiting.
Each new row is reported once
Comparing against the stored row count means you are not told about the same entry again. Your inbox only shows what has arrived since the last email. That keeps your inbox tidy and useful.
A safety net for shared files
When several people edit one workbook, nobody is sure who has seen what. The email gives a reliable record that a new row arrived and when it was noticed. That is helpful if anyone later disputes timing.

How it works

What happens, step by step

Every 10 minutes, ClickRuntime checks your Excel table for rows added since the last check.
It only looks at rows it has not seen before, so you never hear about the same row twice.
You get an email with each new row's details, such as name, email and plan.

Before it runs live

Connect Microsoft Excel

What you get

RunsEvery 10 minutes

Get an email for each new Excel rowtoday, 9:00Succeeded

Email · 2 new rows in SignupsName: Sam Lee · Email: sam@northwind.com · Plan: Team

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

Act only on the items that match your own rules, and skip the rest
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.

new_row_notification_microsoft_excel.pyexample

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

TABLE = "https://graph.microsoft.com/v1.0/me/drive/items/01ABCDEF.../workbook/tables/Signups"

@on_trigger
def run(event):
    h = {"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"}
    cols = [c["name"] for c in http.get(f"{TABLE}/columns", headers=h).json()["value"]]
    rows = http.get(f"{TABLE}/rows", headers=h).json()["value"]
    seen = state.get("count")
    new = rows[seen:] if seen is not None else []
    report_fetched(len(new))
    if not new:
        state.set("count", len(rows))
        return {"summary": "Nothing new"}
    lines = [" · ".join(f"{c}: {v}" for c, v in zip(cols, r["values"][0])) for r in new]
    notify.email_me(f"{len(new)} new rows in Signups", "\n".join(lines))
    state.set("count", len(rows))
    return {"new": len(new)}

FAQ

Common questions

How soon will I be told about a new row?

Within about 10 minutes, since the table is checked on that interval. It is not instant, but fast enough for requests and bookings that are handled during the working day. Faster checks are possible if you need them.

What if rows are deleted and others added?

The check compares counts and positions, so if rows are removed and added between checks the count may not change. For heavy editing, you can ask for a more robust comparison using a unique ID column.

Which details are in the email?

The email shows the values from the new rows, with column names. You can choose which columns to include, which is helpful if the table contains private information you would prefer not to put in an email.

What permissions does it need?

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 checks. Checks that find nothing new 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.

Hourly