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