Puspak
Workflows by Puspak
Remote job updates pipeline with RemoteOK, Airtable, and Telegram
🚀 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
Extract and structure Hacker News job posts with Gemini AI and save to Airtable
## Workflow Overview This workflow automatically fetches the latest "Ask HN: Who is hiring?" posts from Hacker News, extracts individual job listings, cleans the raw text, converts them into structured job listings using Google Gemini AI, and saves them into Airtable. ## Components It’s a full end-to-end automation system combining: * **Algolia API** for HN data * **Text cleaning** * **Gemini AI (via LangChain)** for parsing job descriptions * **Structured JSON extraction** * **Airtable integration** to store the final data ## 🎯 Use Cases * Automatically build a job board from HN posts * Track startup hiring trends * Feed remote job alerts into a CRM or Slack * Enrich a hiring intelligence database ## 🔧 Nodes & Services Used * HTTP Request (Algolia + Firebase API) * SplitOut, Set, Filter, Function, Limit * Google Gemini (via LangChain integration) * Output Parser Structured * Airtable (API token required) ## 📌 Credentials Required * Google Gemini (PaLM/Gemini API) * Airtable Personal Access Token * Algolia Application ID & API Key (via Header Auth) ## 📦 Tags hacker-news, jobs, airtable, ai, gemini, automation, hn, langchain, workflow ## Screenshots 