On a schedule

Get a daily email of new Airtable records

Each evening you see everything added to your table that day in one email.

Runs: On a schedule
Apps: Airtable
AI: Not needed
Access: data.records:read

Send this to your assistant

Create a ClickRuntime automation: every day at 7pm, email me a table of the records added to my Airtable Orders table in the last 24 hours.

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 shared Airtable base that receives new records from forms, teammates and other tools soon outgrows anyone's ability to watch it. A support lead, a producer or a program manager wants to know what came in today, but opening the base, sorting by created time and scrolling is a small chore that is skipped when things are busy. The result is that new requests sit unseen for a day or two, and people wonder why nobody responded.

Every evening, the automation lists records created in the last day using a formula on CREATED_TIME(), formats the main fields into a readable table and emails it to you. It gives a clear picture of what the day added, in one message, without anyone opening Airtable.

Typical uses are intake tables, request trackers, applicant lists and any base where new rows mean new work.

What you get out of it

Nothing new goes unnoticed overnight
Seeing every record added today in one list means a request submitted at 4pm is known about before the team logs off, and can be picked up first thing tomorrow.
A calmer alternative to constant notifications
One summary at the end of the day replaces a stream of pings. People stay informed without having their focus broken by each new row. It also protects deep work, since nothing interrupts it during the day.
Daily volume becomes a metric
Counting what arrives each day shows busy and quiet periods. That helps you staff the team, set expectations for response times and spot unusual days. Over a quarter, those counts become the basis for planning headcount or asking for budget.
Handoffs between shifts are easier
The evening email is a record of what came in, so the next person starts with the list rather than reconstructing it from the base. Nothing is lost at the end of a shift, and nobody has to write a separate handover note.
Stakeholders get visibility without a login
Managers or clients who do not use Airtable can follow the flow of new work by email, which keeps them informed and cuts down on status requests. Each message works as a short report that needs no explanation.

How it works

What happens, step by step

Every evening at 7, ClickRuntime finds every record added to your Airtable table in the last day.
It lists them in one tidy table with the time and key fields, such as customer and amount.
The list is emailed to you, with the number of new records in the subject line.

Before it runs live

Connect Airtable

What you get

RunsOn a schedule

Get a daily email of new Airtable recordstoday, 9:00Succeeded

Email · New orders today: 709:14 Northwind Traders 420.00 11:02 Acme Corp 1,150.00

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

daily_new_records_summary.pyexample

from clickruntime import on_trigger, credentials, http, notify

BASE_ID = "appXXXXXXXXXXXXXX"

@on_trigger
def run(event):
    records = http.get(f"https://api.airtable.com/v0/{BASE_ID}/Orders",
                       headers={"Authorization": f"Bearer {credentials.connection('airtable', 'work')}"},
                       params={"filterByFormula": "IS_AFTER(CREATED_TIME(), DATEADD(NOW(), -1, 'days'))"}).json()["records"]
    if not records:
        notify.email_me("New orders today: none", "No records were added to Orders in the last 24 hours.")
        return {"count": 0}
    lines = [f"{r['createdTime'][11:16]}  {r['fields'].get('Customer', ''):<24} {r['fields'].get('Total', '')}"
             for r in records]
    notify.email_me(f"New orders today: {len(records)}", "Time   Customer                 Total\n" + "\n".join(lines))
    return {"count": len(records)}

FAQ

Common questions

Which records count as new today?

Those whose creation time falls within the last 24 hours when the summary runs. A record created before the previous run is not repeated, so each record appears in exactly one summary. Edits to older records do not count as new, so the list is only what was created.

Can I include only records from one view or status?

Yes. Add a condition on a field such as Status or Source so the summary only lists matching records. For example, only requests marked as urgent, or only entries from the website form. For example, you might only want records from the website form, or only those in a high-priority status.

What if there are hundreds of new records?

The email lists the key fields for each, and for very high volumes you can show counts by category with a link to the view in Airtable. That keeps the message readable. That is usually easier to scan than a long table.

What permissions does it need?

data.records: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 (on a schedule). 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.

Hourly or daily