Developer & DevOps

Schedule Airtable queries and deliver reports via Telegram

15 nodes 189 92 Scheduled trigger
Download

Workflow Description

A time-based automation that retrieves records and fields from Airtable tables on a recurring schedule, processes the data according to your conditions, and sends formatted reports directly to Telegram channels or direct messages. Reduces manual monitoring overhead and keeps teams informed in real time.

How it works

  1. 1.Cron trigger executes the workflow at specified intervals automatically
  2. 2.Query fetches relevant records and fields from your configured Airtable tables
  3. 3.Data is filtered and formatted based on conditional logic rules
  4. 4.Formatted message is sent to Telegram immediately upon completion

Use cases

  • Send daily sales or productivity reports to your team's Telegram channel without manual intervention
  • Monitor data quality in Airtable and alert the team to errors or critical updates
  • Distribute updated task lists or work schedules to team channels on a recurring basis

Requirements

  • Active Airtable account with tables and fields configured for querying
  • Valid Airtable API key and Telegram bot token with target channel or conversation ID
  • Basic understanding of Cron expression syntax to define your desired schedule

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Schedule Airtable Telegram

Details

Trigger Scheduled trigger
Nodes 15
Apps 3
Views 189
Downloads 92

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (15)

/

Cron

Cron

#1

Airtable2

Airtable

#2

Set

Set

#3

Recipe Photo

Set

#4

Recipe URL

Set

#5

IF

If

#6

Airtable

Airtable

#7

Airtable1

Airtable

#8

Telegram Recipe Image

Set

#9

Telegram Recipe URL

Set

#10

Set1

Set

#11

Get recipes from API

HTTP Request

#12

Get recipes

HTTP Request

#13

Telegram Trigger - people join bot

Set

#14

Telegram - Welcome Message

Set

#15