Extract and Structure Hacker News Job Posts with Gemini AI and Save to Airtable

Description

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