Back to Templates

Remote job updates pipeline with RemoteOK, Airtable, and Telegram

Created by

Created by: Puspak || dpreddy
Puspak

Last update

Last update 4 months ago

Categories

Share


๐Ÿš€ Remote Job Automation Workflow
Automatically fetch, clean, and broadcast the latest remote job listings โ€” powered by RemoteOK, Airtable, and Telegram.

๐Ÿ”ง Key Features
Seamless Data Fetching:
Pulls the latest job listings from the RemoteOK API using an HTTP Request node.

Smart Data Processing (via Code Node):

Filters out irrelevant metadata

Cleans and sanitizes job descriptions (e.g., HTML tags, special characters)

Handles malformed or encoded text gracefully

Extracts and formats salary ranges for clarity

Airtable Integration (Upsert):

Stores each job as a unique record using job ID

Avoids duplication through conditional upserts using Airtable's Personal Access Token

Telegram Bot Broadcasting:

Automatically formats and sends job posts to a Telegram group or channel

Keeps your community or team updated in real-time

๐Ÿ“ฆ Tech Stack
RemoteOK API โ€“ source of curated remote job listings

Airtable โ€“ lightweight, accessible job database

Telegram Bot API โ€“ for real-time job notifications

n8n โ€“ workflow automation engine to tie everything together

๐Ÿ” Workflow Overview
Fetch Jobs from RemoteOK API

Clean & Normalize job descriptions and metadata

Extract Salary ranges and standardize them

Upsert to Airtable (avoiding duplicates)

Format Post for visual clarity

Send to Telegram via bot integration

๐Ÿง  Perfect For
Remote job boards or aggregators

Recruitment agencies/startups

Developers building personal job feeds

Communities or channels sharing curated remote opportunities

Automating newsletters or job digests

โœ… Benefits

Near real-time updates

Minimal maintenance

Full control and extensibility with n8n