Extract & Structure HN Job Posts with Gemini AI to Airtable

This workflow automates the extraction of job listings from Hacker News 'Ask HN: Who is hiring?' threads. It starts by querying the Algolia API for the latest posts, splits out individual job hits, cleans the raw text, and uses Google Gemini AI via LangChain to intelligently parse and structure the unstructured job descriptions into JSON format with fields like company, role, location, salary, and requirements.

The structured output is then filtered, limited, and upserted into an Airtable base, enabling seamless data management. Benefits include real-time job board building, trend analysis for startups, and integration with CRMs or notification systems, saving hours of manual scraping and parsing.

Ideal use cases: Track remote jobs, build hiring intelligence databases, feed alerts to Slack/Email, or analyze hiring patterns across tech companies. Requires Gemini API, Airtable token, and Algolia credentials for full operation.