Daily
Get a random recipe from Airtable on Telegram each day
Each morning your Telegram gets one random record from Airtable, such as a recipe, quote or tip, without repeats from recent days.
- Runs
- Daily
- Apps
- Airtable, Telegram
- AI
- Not needed
- Access
- Airtable read; bot token
Send this to your assistant
Create a ClickRuntime automation: every day at 8, pick a random recipe from my Airtable 'Recipes' table that I haven't had in the last 30 days and send it to my Telegram chat with its photo.
First time? Adding ClickRuntime to your assistant takes about two minutes.
Why use it
Why teams use this automation
A home cook has saved two hundred recipes in Airtable over the years, with photos, cooking times and notes. Every evening they still make the same six dishes, because scrolling the base to decide takes longer than just cooking the usual.
A single suggestion in Telegram each morning, with the photo and the ingredients, is easy to say yes to, and it brings the forgotten recipes back into rotation. The same idea works for a team's quote of the day, a language tip or a sales objection to practise.
What you get out of it
Your own collection, resurfaced
Records you saved and forgot about come back one at a time.
No repeats for a month
Recipes sent in the last 30 days are skipped, so the daily pick stays varied.
The photo comes with it
If the record has an image, it is sent as a photo with the text as the caption.
Works for any table
Recipes, quotes, tips or flashcards: point it at a different table and fields.
How it works
What happens, step by step
Every day at 8, ClickRuntime reads the records in your Recipes table.
It leaves out any recipe sent in the last 30 days.
It picks one of the rest at random.
The recipe is sent to your Telegram chat, with its photo if it has one.
The pick is remembered, so it is not sent again for a month.
Before it runs live
- Connect Airtable
- Connect Telegram
What you get
Build your own
Need it to work differently?
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 Telegram steps into one automation
Under the hood
The code that runs this automation
import random
from clickruntime import on_trigger, credentials, http, state
BASE_ID, CHAT_ID = "appXXXXXXXXXXXXXX", "123456789"
@on_trigger
def run(event):
records = http.get(f"https://api.airtable.com/v0/{BASE_ID}/Recipes",
headers={"Authorization": f"Bearer {credentials.connection('airtable', 'work')}"},
params={"pageSize": 100}).json()["records"]
recent = state.get("recent") or []
choices = [r for r in records if r["id"] not in recent] or records
if not choices:
return {"sent": None}
pick = random.choice(choices)
f = pick["fields"]
text = f"Today's recipe: {f.get('Name')}\n{f.get('Time', '')} min\n\n{f.get('Ingredients', '')[:800]}"
api = f"https://api.telegram.org/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}"
photos = f.get("Photo") or []
if photos:
http.post(f"{api}/sendPhoto", json={"chat_id": CHAT_ID, "photo": photos[0]["url"], "caption": text[:1000]}).raise_for_status()
else:
http.post(f"{api}/sendMessage", json={"chat_id": CHAT_ID, "text": text}).raise_for_status()
state.set("recent", (recent + [pick["id"]])[-30:])
return {"sent": f.get("Name")}FAQ
Common questions
What if the table has fewer than 30 records?
Can I limit it to some records, like vegetarian only?
Can it go to a group instead of just me?
What permissions does it need?
Does it need AI?
How many runs does it use?
Can I change how it works?
Related
You might also like
Collect new job listings in Airtable and post them to Telegram
New remote job listings are saved to Airtable every few hours, and only the new ones are posted to your Telegram channel.
See how it worksDraft social posts into Airtable and approve them on Telegram
New articles from your feeds become draft posts in Airtable, you get them on Telegram, and approved ones are tracked through to posted.
See how it worksLog 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.
See how it worksKeep exploring
Set up “Get a random recipe from Airtable on Telegram each day” from your assistant
Copy the prompt above, or connect your assistant first. Free plan, no credit card.