On a schedule

Get your open Coda tasks each morning

Every morning one email lists the tasks in your table that aren't done yet.

Runs: On a schedule
Apps: Coda
AI: Not needed
Access: read

Send this to your assistant

Create a ClickRuntime automation: every weekday at 8am email me the rows in the Tasks table of my Coda doc where Status isn't Done, sorted by Due Date.

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 tables only help when someone reads them. A team keeps its open requests, support follow-ups or hiring pipeline in a Coda table, but each person must remember to open the doc and filter for what is open. On busy days the doc is forgotten, and items that should have moved sit untouched.

Each morning, this queries the table using a filter you define, such as status is Open, and emails you the matching rows as a short list. The work comes to your inbox instead of waiting for you to go and find it.

It suits managers and coordinators who run their operations from a Coda table but live in email during the day. The list is built with a filter you define, so the email shows exactly the rows your team considers open, such as overdue, unassigned or urgent items.

What you get out of it

Start the day with a clear to-do list
A morning email listing open rows removes the step of opening the doc and applying filters. You see what needs attention before the first meeting. The email arrives before the first meeting, so the day starts with a plan and you spend no time applying filters.
Stop items going stale
Rows that appear in the email day after day become hard to ignore. That visible repetition nudges owners to close or reassign them. A row that appears in the email day after day becomes hard to ignore, and owners tend to close or reassign it.
Include people who rarely open Coda
Stakeholders who prefer email still see the state of the table. They are informed without needing a Coda seat or knowing how the doc is organised. People who prefer email still see the state of the table, and do not need a Coda seat to stay informed.
Reduce status meeting time
If everyone reads the same list beforehand, the standup can skip reading it aloud. The meeting becomes about decisions and blockers. If everyone reads the same list beforehand, the standup can move straight to blockers and decisions and skip the roll call.
Work with your own definition of open
The filter is yours, whether it is overdue, unassigned or high priority. The digest reflects how your team actually works instead of a fixed template. Since the filter is yours, the digest follows how the team really works and does not impose a fixed idea of what counts as open.

How it works

What happens, step by step

Every morning at 8, ClickRuntime reads your Coda tasks table.
It keeps the tasks that are still open.
You get one email listing them with their due dates and status.

Before it runs live

Connect Coda

What you get

RunsOn a schedule

Get your open Coda tasks each morningtoday, 9:00Succeeded

Email · 7 open tasks2026-10-20 Send Acme invoice (In progress) 2026-10-22 Update onboarding doc (Not started)

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 Coda 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_table_digest.pyexample

from clickruntime import on_trigger, notify, http, credentials

DOC, TABLE = "AbCDeFGH", "Tasks"  # your doc id and table

@on_trigger
def run(event):
    rows = http.get(f"https://coda.io/apis/v1/docs/{DOC}/tables/{TABLE}/rows", headers={
        "Authorization": "Bearer " + credentials.secret("CODA_API_TOKEN")}, params={
        "useColumnNames": "true", "valueFormat": "simple", "limit": 500,
    }).json()["items"]
    open_rows = [r for r in rows if r["values"].get("Status") != "Done"]
    open_rows.sort(key=lambda r: r["values"].get("Due Date") or "9999")
    lines = [f"{(r['values'].get('Due Date') or 'no date')[:10]}  {r['name']} ({r['values'].get('Status')})" for r in open_rows]
    notify.email_me(f"{len(open_rows)} open tasks", "\n".join(lines) or "Everything is done.")
    return {"open": len(open_rows)}

FAQ

Common questions

Which rows appear in the email?

The rows matching the query filter you set, such as a column equal to Open. Rows that do not match the filter are left out, so the list stays short and relevant to what you asked for.

Can I send the digest to several people?

Yes. The email can go to more than one address, or to a shared inbox. Tell your AI assistant who should receive it and approve the updated recipient list before it takes effect. Adding more recipients or pointing it at a shared inbox is a small change, and the proposal is yours to accept.

What if no rows match?

You can choose whether to send a short note saying nothing is open or to skip the email. Skipping avoids a daily email that carries no information, and it is a small adjustment to request. On days when nothing matches you can choose between a short note and no email at all, and a no-email option avoids empty daily messages.

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

On a schedule