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

Posted by ailicious on Friday November 03, 2023 @05:34PM
from the show-hn dept.

https://docs.google.com/spreadsheets/d/1oOIZmTrppLY3QrDu3l6tosDJPNotio4dlytb0MP2dHc/edit?usp=sharing

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...

Re:Show HN: Transforming "Who's Hiring? (November 2023)" Pos... by david927 on Friday November 03, 2023 @06:21PM (#38135812)

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.

[ Parent | on HN ]

Re:Show HN: Transforming "Who's Hiring? (November 2023)" Pos... by ghostfoxgod on Saturday November 04, 2023 @10:02AM (#38141070)

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!