The moment it happens

Log each sale to Airtable and get a Telegram ping

Every sale from your store is added to Airtable and you get a Telegram message with the product and amount.

Runs: The moment it happens
Apps: Airtable, Telegram
AI: Not needed
Access: Airtable write; bot token

Send this to your assistant

Create a ClickRuntime automation: when my store sends a sale webhook, add the sale to my Airtable 'Sales' table and send me a Telegram message with the product and amount.

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 solo creator sells e-books and presets through an online store. They want every sale in Airtable so they can see which products sell and who buys twice, and they like knowing when a sale happens without opening the store dashboard all day.

Recording each sale in Airtable and pinging Telegram at the same moment gives them a clean sales table and a small, immediate nudge on the phone, with no manual export.

What you get out of it

Every sale in your own table
Product, amount, buyer email and date go into Airtable, ready for your own views and reports.
Know the moment it happens
A short Telegram message tells you what sold and for how much.
No double entries
Each sale id is remembered, so if the store resends the same sale it is recorded once.
Works with your existing store
Any store that can send a sale webhook can point at the trigger link.

How it works

What happens, step by step

Your store notifies a private ClickRuntime link each time a sale is made.
It checks the sale has not been logged already, so a repeated notice is ignored.
The sale is added to your Airtable Sales table.
You get a Telegram message with the product and amount.

Before it runs live

Connect Airtable
Connect Telegram
Paste your automation's link into the other app's webhook settings

What you get

RunsThe moment it happens

Log each sale to Airtable and get a Telegram pingjust nowSucceeded

Telegram · Sales botNew sale: Moody Film Lightroom Presets for $24.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

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

log_sales_to_airtable_and_ping_telegram.pyexample

from clickruntime import on_event, credentials, http, state

BASE_ID, CHAT_ID = "appXXXXXXXXXXXXXX", "123456789"

@on_event
def handle(event):
    sale = event.json or {}
    sale_id = str(sale.get("sale_id") or event.event_id)
    if state.get(f"sale:{sale_id}"):
        return {"duplicate": True}
    product = sale.get("product_name", "")
    amount = round(float(sale.get("price") or 0) / 100, 2)
    http.post(f"https://api.airtable.com/v0/{BASE_ID}/Sales",
              headers={"Authorization": f"Bearer {credentials.connection('airtable', 'work')}"},
              json={"typecast": True, "records": [{"fields": {"Sale ID": sale_id, "Product": product, "Amount": amount,
                    "Email": sale.get("email", ""), "Date": event.received_at[:10]}}]}).raise_for_status()
    http.post(f"https://api.telegram.org/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}/sendMessage",
              json={"chat_id": CHAT_ID, "text": f"New sale: {product} for ${amount:.2f}"}).raise_for_status()
    state.set(f"sale:{sale_id}", True)
    return {"logged": sale_id}

FAQ

Common questions

Will I get a ping for test sales?

Yes, if the store sends them to the same link. Many stores mark test sales with a flag; the script can skip those if you ask.

Can my business partner get the pings too?

Yes. Use a Telegram group with both of you and the bot, and send to the group's chat id.

Which fields from the store are saved?

Product name, price, buyer email and the sale id by default. Any other field the store sends, such as country or discount code, can be added.

What permissions does it need?

Airtable write; bot token. 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 for each event the app sends.

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 happensAI