Discover Business Ideas from HackerNews Posts with GPT-4.1 Analysis and Google Sheets

Last edited 39 days ago

What it is

This n8n workflow monitors top Hacker News posts (in the Front Page) and identifies business-related pain points using AI.

How It Works

It filters posts by engagement (comments > 80, points > 200, and recent date), extracts key metadata, fetches the article content, and uses a GPT-4.1-based agent to detect and summarize pain points.

Results are appended to a Google Sheet for further analysis.

Setup

To run this workflow, you need to set up credentials for:

  1. OpenRouter: Uses an API Key. Generate this key directly from your OpenRouter account settings. (YT Tutorial : https://youtu.be/Cq5Y3zpEhlc)
  2. Google Sheets: Uses OAuth 2.0. Requires setup in Google Cloud Console (enable Sheets API, create OAuth Client ID with n8n redirect URI) to get a Client ID & Secret.

Ensure these credentials are created and selected in the respective n8n nodes (Get Posts, OpenRouter Chat Model nodes, Output The Results).

New to n8n?

Need help building new n8n workflows? Process automation for you or your company will save you time and money, and it's completely free!