Collect Hacker News, analyze with AI, and log to Google Sheets
Workflow Description
This automation retrieves the latest tech stories from Hacker News, processes them using OpenAI embeddings and vector storage, analyzes content with LLM intelligence, and automatically logs categorized results into Google Sheets for easy tracking and discovery of important developments.
How it works
- 1.Trigger manually or via webhook to fetch latest posts from Hacker News
- 2.Process text by splitting into chunks, converting to embeddings via OpenAI, and storing in Qdrant Vector Store
- 3.Analyze content with LLM model to classify news by relevance and category
- 4.Send processed results automatically to organized tables in Google Sheets
Use cases
- Monitor and categorize daily tech news updates without manual intervention
- Centralize tech market insights in a searchable spreadsheet for strategic decision-making
Requirements
- Google account with edit permissions on Google Sheets
- OpenAI API key for embeddings and language model analysis
- Access to Qdrant Vector Store database for storing embeddings
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (36)
When clicking ‘Test workflow’
Manual Trigger
Hacker News
Hacker News
Split Out
Split Out
Get Comments
Set
Qdrant Vector Store
Vector Store Qdrant
Embeddings OpenAI
OpenAI
Default Data Loader
Document Default Data Loader
Recursive Character Text Splitter
Text Splitter Recursive Character Text Splitter
Set Variables
Set
Clear Existing Comments
HTTP Request
Get Payload of Points
HTTP Request
Clusters To List
Split Out
OpenAI Chat Model
OpenAI
Only Clusters With 3+ points
Filter
Set Variables1
Set
Prep Output For Export
Set
Export To Sheets
Google Sheets
Execute Workflow Trigger
Execute Workflow Trigger
Trigger Insights
Execute Workflow
Prep Values For Trigger
Set
Find Comments
HTTP Request
Sticky Note6
Sticky Note
Sticky Note2
Sticky Note
Sticky Note1
Sticky Note
Sticky Note
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note7
Sticky Note
Sticky Note8
Sticky Note
Sticky Note9
Sticky Note
Apply K-means Clustering Algorithm
Code
Sticky Note10
Sticky Note
Information Extractor
Information Extractor
Sticky Note12
Sticky Note
Sticky Note11
Sticky Note