# Extract and structure job listings from Hacker News to Airtable using AI
This workflow automates monitoring and analysis of IT job postings from the popular "Who is hiring" section on Hacker News. It eliminates manual data collection by transforming unstructured text into clean, structured records in Airtable — including company, role, salary, location, and other key fields. Ideal for HR professionals, recruiters, and labor market analysts who need speed and accuracy.
## Who it´s for
- Recruiters tracking new IT job openings
- Developers seeking jobs through automated monitoring
- Labor market analysts in the tech sector
- HR automation specialists collecting data from public sources
## What the automation does
- Periodically queries Hacker News via Algolia API for new or updated "Who is hiring" posts
- Extracts individual job comments
- Cleans text from HTML and extraneous characters
- Sends cleaned content to Google Gemini via LangChain to extract structured data (company, role, salary, employment type, location, application link)
- Stores results in a designated Airtable base
- Runs on a cron schedule without user intervention
## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on cron_schedule
- Integrations with Hacker News API, Algolia Search, Google Gemini (PaLM), and Airtable
- Basic textual guide for setup and adaptation
## Requirements for setup
- n8n account (cloud or self-hosted)
- Algolia API key for querying Hacker News data
- Airtable account with base/table ID for storing job entries
- Google Gemini API key for AI parsing
## Benefits and outcomes
- Saves time on manual scraping and job data entry
- Centralized, structured job database in Airtable
- Filterable by salary, location, employment type
- Automatic updates every 2 minutes (or custom schedule)
- Supports labor market trend analysis in IT
- Scalable: adaptable to other platforms or sources
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet