On a schedule

Send top-scoring Airtable submissions to Trello

Submissions that score above your threshold appear as cards on your Trello review board, each one only once.

Runs: On a schedule
Apps: Airtable, Trello
AI: Not needed
Access: Airtable read+write; Trello write

Send this to your assistant

Create a ClickRuntime automation: every hour, find Airtable submissions with a Total Score over 15 that are not on Trello yet, and create a review card for each.

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 grants committee collects applications in Airtable, where each one is scored against a rubric. Only the strongest go to the panel, but moving them onto the panel's Trello board is a manual job that someone does every few days, so good applications wait and some are missed.

An hourly check moves every qualifying submission onto the board soon after it crosses the threshold, and records the card on the Airtable record so nothing is sent twice.

What you get out of it

Strong submissions reach reviewers quickly
Anything over the threshold is on the board within the hour. Reviewers can start on the best candidates without waiting for a batch.
No submission is moved twice
The card ID is written back to the Airtable record. Running every hour never creates duplicates, even if scores are edited later.
Reviewers stay in one tool
The panel works from a Trello board they already know. They do not need Airtable access to see what to review.
The threshold is a single number
Raising or lowering the bar is a one-line change. That makes it easy to adjust when the volume of submissions changes.

How it works

What happens, step by step

Every hour, ClickRuntime looks in your Airtable table for submissions with a total score above your threshold.
Submissions that already have a Trello card recorded are skipped.
Each new qualifying submission becomes a card on your Trello review list with its key details.
The new card's ID is saved on the Airtable record so it is never sent twice.

Before it runs live

Connect Airtable
Connect Trello

What you get

RunsOn a schedule

Send top-scoring Airtable submissions to Trellotoday, 9:00Succeeded

Trello · Review boardNew card: "Contoso Community Garden" (score 18) in To review

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

send_high_scoring_airtable_submissions_to_trello_for_review.pyexample

from clickruntime import on_trigger, credentials, http, report_fetched

BASE_ID = "your-airtable-base-id"
TABLE = "Submissions"
LIST_ID = "your-trello-list-id"
THRESHOLD = 15

@on_trigger
def run(event):
    at = {"Authorization": f"Bearer {credentials.secret('AIRTABLE_TOKEN')}"}
    url = f"https://api.airtable.com/v0/{BASE_ID}/{TABLE}"
    formula = f"AND({{Total Score}} > {THRESHOLD}, {{Trello Card}} = '')"
    records = http.get(url, headers=at, params={"filterByFormula": formula}).json().get("records", [])
    report_fetched(len(records))
    if not records:
        return {"summary": "Nothing new"}
    auth = {"key": credentials.secret("TRELLO_KEY"), "token": credentials.secret("TRELLO_TOKEN")}
    for rec in records:
        f = rec["fields"]
        desc = f"Score: {f.get('Total Score')}\nApplicant: {f.get('Applicant', '')}\n\n{f.get('Summary', '')}\n\nhttps://airtable.com/{BASE_ID}/{rec['id']}"
        card = http.post("https://api.trello.com/1/cards", params={**auth, "idList": LIST_ID, "name": f.get("Name", rec["id"]), "desc": desc}).json()
        http.patch(f"{url}/{rec['id']}", headers=at, json={"fields": {"Trello Card": card["id"]}})
    return {"summary": f"{len(records)} cards created"}

FAQ

Common questions

Which details go on the card?

The submission name as the title, and the score plus fields such as applicant and summary in the description. A link back to the Airtable record is included.

What if a score changes after the card is created?

The card is not updated or removed. Once a record has a card ID it is skipped, so reviewers decide what to do with changed scores.

Do I need to add a field to my Airtable base?

Yes, one text field to store the Trello card ID. That field is how the automation knows which submissions are already on the board.

What permissions does it need?

Airtable read+write; Trello write. 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.

The moment it happens