Hacker News Job Post Extraction with AI & Airtable

This workflow automates job post extraction from Hacker News’ 'Who is Hiring?' threads, replacing manual job board searches for recruiters and job seekers. It fetches posts, extracts details using AI, and stores structured data in Airtable, saving hours of research. Key nodes include Manual Trigger (initiates scraping), HTTP Request (fetches posts via Algolia and Firebase APIs), Code (cleans text), Chain LLM (AI data extraction), Airtable (stores jobs), and Filter (ensures recent posts). It benefits recruitment teams or tech startups with 10-100 employees, processing 50+ job posts monthly, streamlining candidate sourcing and market research.\n\nThe workflow saves 8-12 hours weekly by automating 50+ job post analyses, reducing manual effort by 75%. Use cases include tech startups, freelance recruiters, or job boards. Requirements include n8n, OpenAI (~$0.02/1K tokens), Airtable (~$20/user/month), and Algolia API access (free tier). It scales to 500 posts monthly but is limited by Airtable storage and API quotas. Setup takes 20-30 minutes, needing API credentials and table setup.\n\nInstall n8n from n8n.io or use cloud.n8n.io. Obtain OpenAI API keys from platform.openai.com, Airtable tokens from airtable.com/account, and Algolia API keys from algolia.com. Import the workflow JSON via Workflows menu. Configure HTTP Request nodes with Algolia (x-algolia-api-key header) and Airtable nodes with base and table IDs for Job Postings. No webhook setup is needed for manual triggers.\n\nTest with Manual Trigger, verifying HTTP Request nodes fetch recent posts (e.g., title: 'Ask HN: Who is Hiring?'). Check Code node for cleaned text, Chain LLM for structured data (company, title, salary), and Airtable for saved records. Common errors: invalid API keys (re-authenticate), rate limits (adjust Limit node to 5 items), or empty posts (verify Algolia query). Activate workflow, schedule monthly runs, monitor Airtable for data accuracy, and optimize by tweaking Chain LLM prompts for specific roles.", "businessValue": "Saves 8-12 hours/week processing 50+ job posts", "setupTime": "20-30 minutes", "difficulty": "Intermediate", "requirements": [ "n8n, OpenAI, Airtable, Algolia subscriptions", "API keys for OpenAI, Airtable, Algolia", "Node.js environment, 4GB RAM minimum" "useCase": "Automating job post extraction for recruiters"