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