AI-powered Product Hunt data collection & translation with GPT-4 and Google Sheets
Needs changesWhat this workflow does
This AI workflow has 17 nodes and runs on a schedule (every day at 09:00). Along the way it connects Google Sheets and OpenAI Chat Model. It also calls api.producthunt.com over HTTP.
How it runs
Trigger: On a schedule (every day at 09:00).
- Initialize Starting Cursor (Edit Fields (Set)): sets 1 field: cursor
- Fetch Products from Product Hunt API (HTTP Request): calls api.producthunt.com (POST)
- Restructure API Response to JSON (Code): runs custom JavaScript code
- Lookup Existing Tool by Title (Google Sheets): uses Google Sheets
- Is Tool New? (If): checks a condition and branches into true / false
- AI Agent: runs an AI agent, with model: OpenAI GPT-4.1 Mini; 2 tools (Lookup Category Dictionary (Read), Update Category Dictionary (Write))
- Extract Pagination Info (Edit Fields (Set)): sets 2 fields: cursor, hasnextpage
- Clean & Parse AI JSON Output (Code): runs custom JavaScript code
- Has Next Page? (If): checks a condition and branches into true / false
- Save Enriched Tool to Sheet (Google Sheets): append or update
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: api.producthunt.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent: Translate & Enrich Product Data (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent: Translate & Enrich Product Data (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (11)
- Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - HTTP Request
n8n-nodes-base.httpRequest - AI Agent
@n8n/n8n-nodes-langchain.agent - Wait
n8n-nodes-base.wait - No Operation, do nothing
n8n-nodes-base.noOp
From the author
This n8n template automates the collection and enrichment of Product Hunt posts using AI and Google Sheets. It fetches new tools daily, translates content, categorizes them intelligently, and saves everything into a structured spreadsheet—ideal for building…