Show HN: Transforming "Who's Hiring? (November 2023)" Posts into a Google Sheet (opens in new tab)

(docs.google.com)

27 pointsailicious2y ago2 comments

Hello HN Community!

I've transformed the "Ask HN: Who's hiring? (November 2023)" post into a Google Sheet.

Here's a quick rundown of the method:

I utilized the Hacker News Algolia Search API to extract data. You can find the specific thread URL here: https://hn.algolia.com/api/v1/search_by_date?tags=comment,st...

Using a GET request, I fetched comments from the thread and processed them via the ChatGPT API.

Employing the ChatGPT API for each comment, I parsed crucial job details such as company, position, location, and more. This information was structured and appended to a Google Sheets document, creating a neatly organized view of viable job opportunities.

I believe this resource can aid individuals in more effectively evaluating job offers or possibly be the foundation for a helpful search tool using this standardized data.

For few more details, you can check out this article: https://bulkninja.notion.site/Converting-Ask-HN-Who-is-Hirin...

2 comments

ghostfoxgod2y ago

Nice work, I am currently sending out the relevant links on my discord server on period basis, the idea of using GPT API to extract out information is much better than me manually trying to parse the data (many false positives right now). Will try and do it this way as well, thanks for the tip!

david9272y ago

Thanks for doing that!

I put it into Excel and made a table out of it and could look at it in a much more meaningful way.

j / k navigate · click thread line to collapse