Every 5–15 minutes

Get notified about new rows

Whenever a row is added to your sheet, you see it in Slack within minutes.

Runs: Every 5–15 minutes
Apps: Google Sheets
AI: Not needed
Access: read

Send this to your assistant

Create a ClickRuntime automation: whenever a new row is added to my Leads sheet, send me the row in Slack.

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 Google Sheet is often the cheapest intake system a small team has. A Google Form writes sign-ups into it, a sales rep pastes in a lead, an ops person logs a new order. The trouble is that a sheet never announces anything. Row 212 sits there until someone happens to scroll down, and by then the customer has already emailed twice asking whether anyone saw their request.

Every 5 to 15 minutes, the sheet's range is read and the row count is compared with the count saved last time. Any rows beyond that count are posted to Slack or sent by email, with the cell values from each new row in the message, and the new total is stored for the next check.

It suits form-fed sheets, shared request trackers and any spreadsheet that acts as a lightweight database for a team that lives in Slack.

What you get out of it

New entries seen within minutes
A form response or pasted lead reaches a person in Slack while it is still fresh. Instead of discovering a request at the end of the day, someone can reply in the same quarter hour.
Nobody has to babysit the sheet
Teammates stop refreshing the tab to check for changes. The check runs by itself, so attention goes to the work the row describes rather than to watching for it. That matters most for the person who owns the sheet and is tired of being the human notification system.
Rows are not missed in busy periods
Because the comparison is against a saved row count, ten rows added in one burst produce ten posts. Nothing gets buried under the newest entry on a long, scrolling sheet.
A spreadsheet can stand in for a small app
If your intake process is a sheet plus a form, an alert channel turns it into a working workflow. You avoid paying for a ticketing tool before volume justifies one.
Shared awareness across the team
When the post lands in a channel, everyone sees what came in and who picked it up. That cuts the double replies and the question of whether anyone has handled row 212.

How it works

What happens, step by step

Every 5 to 15 minutes ClickRuntime reads your Google Sheet.
It compares the number of rows with what it saw last time to spot new ones.
Each new row is posted to your Slack channel, with every column shown by name, such as Name, Company and Email.

Before it runs live

Connect your Google Sheets account and pick the spreadsheets it may use

What you get

RunsEvery 5–15 minutes

Get notified about new rowstoday, 9:00Succeeded

Slack · #leadsNew lead Name: Dana Park Company: Acme Email: dana@acme.example

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 Google Sheets 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.pyexample

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, report_fetched, credentials, state, notify

SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    rows = sheets.values().get(spreadsheetId=SHEET_ID, range="Leads!A1:Z").execute().get("values", [])
    header, data = rows[0], rows[1:]
    seen = state.get("rows")
    if seen is None:  # first run: remember where the sheet ends
        state.set("rows", len(data))
    new = data[seen:] if seen is not None else []
    report_fetched(len(new))
    if not new:
        return {"summary": "Nothing new"}
    for row in new:
        notify.slack("New lead\n" + "\n".join(f"{h}: {v}" for h, v in zip(header, row) if v), channel="#leads")
    state.set("rows", len(data))
    return {"new": len(new)}

FAQ

Common questions

How does it know which rows are new?

It stores the number of rows it saw on the previous check and compares it with the current count. Rows past the stored number are treated as new. If you insert rows in the middle of the data rather than at the bottom, counts can drift, so adding at the end works best.

What if someone deletes or sorts rows in the sheet?

Deleting rows lowers the count, so the saved number resets on the next run and no false alerts are posted for old data. Sorting does not change the count, so it is ignored. Only genuine additions past the last known row trigger a post.

Can the alert include only certain columns?

Yes. The message is built from the cells you choose, such as name, email and request type, rather than the whole row. Telling your AI assistant which columns matter changes the format, and you approve the new version before it runs.

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

Every 15 minutes