Qualify Product Hunt leads with Google Gemini, Apify, and Google Sheets
UnknownWhat this workflow does
This AI workflow has 15 nodes and runs on a schedule (every day at 11:00). Along the way it connects Google Sheets, HighLevel, Google Gemini Chat Model and Apify (community). It also calls api.producthunt.com over HTTP.
How it runs
Trigger: On a schedule (every day at 11:00).
- Fetch Product Hunt Posts (HTTP Request): calls api.producthunt.com (POST)
- Split Post Edges (Split Out): splits a list into separate items
- Resolve Website URL (HTTP Request): calls an HTTP API (HEAD)
- Prepare Data for Analysis (Code): runs custom JavaScript code
- Lead Qualification Agent (AI Agent): runs an AI agent, with model: Gemini Model; output parser: Define Output Schema
- If: checks a condition and branches into true / false
- Run Apify Scraper Actor (Apify): run actor and get dataset
- Group Data by Domain (Code): runs custom JavaScript code
- Sync Lead to Sheets (Google Sheets): append or update
- Check if Email Exists (If): checks a condition and branches into true / false
…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
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Run Apify Scraper Actor).
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Code
n8n-nodes-base.code - Apify
@apify/n8n-nodes-apify.apify - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - HighLevel
n8n-nodes-base.highLevel - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured
From the author
Quick overview Youtube Video: https://youtu.be/h47YeiivZvs?si=V-S1X-ME5V24Tuch This workflow runs daily to pull the latest Product Hunt posts, qualifies them with Google Gemini, scrapes ICP-matching product websites with Apify to find emails, then writes the…