n8n

How to Sync Airtable Hacker News Hiring Data?

Collect hiring posts from the monthly Who is hiring thread and turn them into clean job records in Airtable. Recruiters, job boards, and founders can build a live list of roles without copy and paste.

When you run it, an HTTP call searches the index on Algolia for the latest Who is hiring post. The flow splits the results and keeps key fields like title, dates, and story id. A filter keeps the newest thread. The official API returns the main story and a list of child comments. Each child is a job post. The flow fetches each comment, pulls the text, and removes HTML. You can turn on a limit for safe testing. OpenAI with a structured parser turns messy text into neat fields such as company, role, location, type, salary, description, apply url, and company url. Finally, each job is written as a row in Airtable.

Set up is simple once you have credentials. For Algolia, copy the request headers from your browser network tab and paste into the HTTP Request node. Hacker News API needs no key. Map Airtable fields to match the schema. Expect a big time save each month and cleaner data for sourcing and outreach. Common uses include daily candidate outreach, tracking competitor hiring, and building a niche job feed.

What are the key features?

  • Manual test trigger to control when runs happen
  • Algolia HTTP search to find the latest Who is hiring post
  • Set and Filter steps keep only the newest thread and key fields
  • Hacker News API calls pull the main story and all comment IDs
  • Loop fetches each comment and extracts only the text
  • Code step cleans HTML and special characters from job posts
  • Optional limit node caps the number of jobs during testing
  • OpenAI with a structured parser converts raw text into company, title, location, type, salary, and links
  • Airtable node writes each job as a row ready for sorting and filters

What are the benefits?

  • Reduce manual work from 4 hours to 10 minutes per monthly thread
  • Streamline sourcing by 80 percent with one click ingestion
  • Improve data quality by 90 percent using structured parsing and cleaning
  • Handle 10 times more job posts without extra staff
  • Connect Algolia, Hacker News API, OpenAI, and Airtable in one flow

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Algolia, Hacker News API, OpenAI and Airtable. See the Tools Required section above for links to create accounts with these services.
  3. OpenAI credentials: In the n8n credentials manager, create an OpenAI API credential. Use your API key from the OpenAI dashboard. Select this credential on the OpenAI Chat Model node and keep the model as gpt-4o-mini.
  4. Airtable credentials: In the Airtable account, create a Personal Access Token with data read and write on your base. In n8n, create an Airtable credential using that token and select it on the Airtable node.
  5. Prepare your Airtable table: Create fields for company, title, location, type, salary, description, apply_url, and company_url. In the Airtable node, map each output field to the matching column.
  6. Algolia search setup: Go to hn.algolia.com, search for "Ask HN: Who is hiring?", sort by date, open the browser Network tab, find the search request, and copy as cURL. In the HTTP Request node named Search for Who is hiring posts, import the cURL or add the x algolia headers using a Header Auth credential.
  7. Verify search output: Run the workflow with the manual trigger and check the Split Out node to confirm you see recent threads. The Set and Filter nodes should pass only the newest thread.
  8. Hacker News API nodes: No credentials are needed. Ensure the HN API Get Main Post node uses the storyId from the previous step and that Split out children sends each kid ID to the individual post request.
  9. Text extraction and cleaning: Confirm the Extract text node returns the comment text and the Clean text Code node removes HTML tags and entities. If content looks broken, adjust the cleaning code.
  10. Testing volume: In the Limit for testing node, set a small number like 5 while you validate mappings. Disable or increase this limit once everything looks correct.
  11. Structured parsing: On the Trun into structured data node, ensure the Structured Output Parser is linked and the prompt asks to extract the JSON fields. Test one item to confirm valid JSON output.
  12. Troubleshooting: If Algolia returns 403 or empty results, refresh the cURL from the Network tab or update the x algolia headers. If OpenAI errors, check API quota. If Airtable rows fail, confirm field names and that the credential has write access.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Airtable

Sign up

Free (1,000 API calls / mo)

Algolia

Sign up

Free

Hacker News API

Sign up

Free: $0, no API key required, no documented rate limit

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.