Skip to content
FlowHubFluxonLab
Airtable
AI Automationfree

Scrape Hacker News hiring threads with OpenAI GPT-4o-mini and Airtable

by Redowan Ahmed Farhanadapted from n8n official workflow galleryUpdated Aug 2026
RequiresAirtableAirtableBBasic LLM ChainCCodeHTTP RequestHTTP RequestOpenAI Chat ModelOpenAI Chat ModelStructured Output ParserStructured Output Parser
Share Post Share
MaWhen clicking ‘Test workflow’When clicking ‘…SOSplit OutOpenAI Chat ModelOpenAI Chat Mod…OPStructured Output ParserStructured Outp…HRSearch for Who is hiring postsSearch for Who …SeGet relevant dataGet relevant da…FiGet latest postSOSplit out children (jobs)Split out child…CLTrun into structured dataTrun into struc…SeExtract textCoClean textLiLimit for testing (optional)Limit for testi…Write results to airtableWrite results t…HRHI API: Get the individual job postHI API: Get the…HRHN API: Get Main PostHN API: Get Mai…1234567891011121314
1/5
STEPS · 14
Run manually by an operator

Quick overview This workflow manually runs a scraper that finds the latest Hacker News “Ask HN: Who is hiring?” thread via the Algolia HN Search API, pulls each job comment from the Hacker News Firebase API, uses OpenAI to structure postings into fields, and saves the results to Airtable. How it works Starts when you manually execute the workflow. Queries the Algolia Hacker News Search API for recent “Ask HN: Who is hiring?” stories and keeps only the relevant thread metadata. Filters the results to the most recent thread (created within the last 30 days) and fetches the full thread from the Hacker News Firebase API. Iterates through the thread’s comment IDs, fetching each individual job comment from the Hacker News Firebase API. Extracts and cleans the job text to remove HTML/entities and normalize links and whitespace. Sends the cleaned text to OpenAI (GPT-4o-mini) to extract a structured JSON record (company, title, location, type, salary, description, and URLs). Creates a new record in Airtable for each structured job posting. Setup Add an Airtable credential and set the target base and table in the Airtable create step. Add an OpenAI credential for the GPT-4o-mini chat model.

Tags

n8nreference-onlyairtablechain-llmlm-chat-open-aioutput-parser-structured
Connects
airtableAirtableBBasic LLM ChainCCodeWHTTP RequestopenaichatmodelOpenAI Chat ModelstructuredoutputparserStructured Output Parser
CategoryAI Automation
Triggermanual
Complexitycomplex
Nodes15
AddedJun 25, 2026

Related workflows

See all AI Automation
BWopenaichatmodelstructuredoutputparser
free

Generate CCTV-style animal TikTok videos with OpenAI, Seedance and Blotato

Quick Overview This workflow runs every four hours to generate a CCTV-style animal video concept with OpenAI, renders an 8-second vertical clip using AtlasCloud Seedance, then publishes it to TikTok via Blotato and sends a preview to Telegram. How it works Runs every 4 hours on a schedule. Uses OpenAI to create a hyper-realistic CCTV-style image and video prompt based on a random (or overridden) animal, location, action, and a current timestamp overlay. Starts a Seedance text-to-video render on AtlasCloud with the generated prompt, duration, aspect ratio, and optional audio. Polls AtlasCloud at a fixed interval until the render status is completed or succeeded and retrieves the output video URL. Uses OpenAI to generate a TikTok-ready title and exactly five hashtags from the video concept. Publishes the generated video to TikTok via Blotato with the title/hashtags and the selected privacy level, flagged as AI-generated. Sends the rendered video and title as a preview to a specified Telegram chat. Setup Add OpenAI API credentials and set the prompt and caption models in the Configuration values if you want to change them. Add an AtlasCloud API key (HTTP Header Auth) and ensure it is

by Dr. Firas
Bsheetsopenaichatmodel
free

Create and approve AI social posts with OpenAI, Telegram and Blotato

Quick overview This workflow runs daily to generate an AI-written social post and DALL·E image with OpenAI, sends it to Telegram for approval, and—if approved—publishes it to LinkedIn, X, Instagram, Facebook, and Threads via Blotato while logging outcomes to Google Sheets. How it works Runs every 24 hours on a schedule trigger. Uses OpenAI to generate a single content topic (title, angle, and hook) based on your niche, audience, and language settings. Uses OpenAI to write one social post with a separate hashtag line and an image prompt in your specified tone and style. Uses OpenAI Images (DALL·E) to generate a matching image and extracts a shareable image URL. Sends the post text, hashtags, and image link to Telegram and waits for you to approve or skip within the configured time window. If approved, publishes the post with the image to LinkedIn, X, Instagram, Facebook, and Threads using Blotato and appends a “Published” log row to Google Sheets. If skipped or not approved, appends a “Skipped” log row to Google Sheets. Setup Add OpenAI API credentials and ensure the selected chat model and image model in the configuration match models available to your account. Add Telegram credent

by Dr. Firas
autofixingoutputparserBopenaichatmodelstructuredoutputparser
free

Force AI to use a specific output format

This workflow is for anyone looking to automatically fetch, validate, and parse complex language-based queries into a structured format. Its unique capability lies in not only processing language but also fixing invalid outputs before structuring them. Note that to use this template, you need to be on n8n version 1.19.4 or later.

by n8n Team