Skip to main content

Automate product Hunt lead generation with Apify and Google Sheets

Workflow preview

Workflow preview
100%
Automate product Hunt lead generation with Apify and Google Sheets preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

Product Hunt Scraper Automated Lead Generation Workflow Turn Product H...

Best for

  • Lead Generation automation workflows
  • AI Summarization automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.set, n8n-nodes-base.scheduletrigger, n8n-nodes-base.code, n8n-nodes-base.if, n8n-nodes-base.datatable, n8n-nodes-base.httprequest, n8n-nodes-base.webhook, n8n-nodes-base.switch

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Jay Emp0.

Original n8n.io source

1.1 Workflow description

Title
Automate product Hunt lead generation with Apify and Google Sheets
Workflow name
Automate product Hunt lead generation with Apify and Google Sheets

Product Hunt Scraper - Automated Lead Generation Workflow

Turn Product Hunt Launches Into Qualified Leads and Reach out Automatically

Stop manually searching Product Hunt for potential customers. This n8n workflow automatically scrapes the latest products from Product Hunt every day, enriches them with contact details, and delivers organized lead lists straight to your Google Sheets.

What You Get

This powerful automation workflow delivers:

  • Daily Lead Generation: Automatically scrapes top 50 Product Hunt products every day at 9 AM
  • Weekly Top Performers: Every Monday, captures the top 100 products from the previous week (configurable)
  • Rich Contact Data: Extracts emails, Twitter handles, LinkedIn profiles, Discord usernames, phone numbers, and more
  • Organized Google Sheets: All leads exported to a structured spreadsheet with product details, maker info, and contact data
  • Automated Outreach: Optional email system to reach out to makers with personalized messages
  • Fresh Leads Daily: Never miss a new product launch or potential customer


Why This Workflow Is a Game Changer

For Sales & Business Development Teams

  • Build a targeted prospect list of innovative companies launching new products
  • Reach decision makers directly with founder emails and social profiles
  • Beat your competition to newly launched products looking for partnerships or tools
  • Scale your outreach without hiring additional SDRs

For SaaS Founders & Indie Hackers

  • Find integration partners by identifying products that complement yours
  • Discover competitors and track their launches in real time
  • Connect with fellow makers for collaboration opportunities
  • Source beta testers from engaged Product Hunt communities

For Marketing & PR Agencies

  • Identify potential clients who just launched and need marketing support
  • Build media lists of active founders for outreach campaigns
  • Track industry trends and emerging products in your niche
  • Automate lead qualification by capturing product categories and descriptions

For Investors & VCs

  • Monitor emerging startups launching on Product Hunt
  • Track portfolio company launches and engagement
  • Discover investment opportunities in specific categories
  • Build deal flow with minimal manual research

Key Features

Intelligent Data Extraction

The workflow captures comprehensive product data:

  • Product name, description, and tagline
  • Product categories and launch date
  • Upvotes and engagement metrics
  • Maker information with social profiles
  • Website URLs and demo links
  • Banner images and screenshots

Multi Channel Contact Discovery

Advanced contact enrichment pulls:

  • Primary email addresses (founder emails, sales, feedback, hello)
  • Secondary email addresses for CC'ing multiple contacts
  • Social media profiles: Twitter, LinkedIn, Discord, Facebook, Instagram
  • Communication channels: YouTube, TikTok, Telegram, WhatsApp, Reddit
  • Phone numbers (when publicly available)
  • Company domains for additional research

Automated Daily Operations

  • Set and forget scheduling: Runs automatically every morning at 9 AM
  • Smart deduplication: Removes duplicate entries to keep your data clean
  • Error handling: Continues processing even if individual products fail
  • Webhook driven architecture: Efficiently processes results as they're ready
  • Batch processing: Handles large datasets without overwhelming your system
  • Gmail integration: Professional email sending via Gmail API for better deliverability

Automated Outreach System

The workflow includes a sophisticated Gmail powered email system that:

  • Sends personalized outreach emails to product makers with their product details
  • CCs secondary email addresses for better reach
  • Professional HTML email templates that are customizable to your brand
  • Better deliverability through Gmail API (not SMTP)
  • Tracks delivery and engagement through Gmail
  • Free to use - 500 emails/day (personal Gmail) or 2,000/day (Workspace)

Email Template Features:

  • Dynamic product name and details
  • Reference to Product Hunt launch
  • Personalized value proposition
  • Clear call to action
  • Unsubscribe link for compliance
  • Your branding and contact info

What's Included

When you purchase this workflow, you get:

  • Complete n8n workflow JSON file ready to import
  • Detailed technical setup guide with step by step instructions
  • Pre configured Apify actors for Product Hunt scraping and contact enrichment
  • Email templates for outreach campaigns

Real Results

Cost Effective Lead Generation

Run this workflow for approximately $65 to $95/month and generate:

  • 1,900+ leads per month (50 products/day × 30 days + weekly top 100)
  • Cost per lead: ~$0.03 to 0.05 which is far cheaper than any lead database
  • Fresh, verified contacts that aren't available in purchased lists
  • Zero manual work after initial setup

Sign up for Apify: Use our affiliate link or referral code 99h7ds


Technical Highlights

  • Built on n8n - the powerful open source automation platform
  • Uses Apify actors for reliable scraping at scale
  • Google Sheets integration for easy data access and sharing
  • Gmail API integration for professional email outreach
  • Webhook based architecture for real time processing
  • Smart batching to stay within API rate limits
  • Modular design making it easily customize which data points to collect
  • Error recovery built into every step
  • Active testing data pinned for easier debugging

Requirements

To run this workflow, you'll need:

Detailed setup instructions are provided in the Technical Setup guide.


Comparison: DIY vs This Workflow

Task Manual Process With This Workflow
Find daily products 30 mins/day checking Product Hunt Automatic
Extract contact info 5 mins per product × 50 = 4+ hours Automatic
Organize in spreadsheet 30 mins/day Automatic
Send outreach emails 3 mins per email × 50 = 2.5 hours Automatic
Total time saved 7+ hours/day 0 hours
Monthly cost Your time + assistant salary ~$50/month

Customization Options

This workflow is fully customizable:

  • Adjust scraping schedule: Change from daily to twice daily or weekly
  • Filter by category: Only scrape products in specific categories (AI, Developer Tools, etc.)
  • Modify top N products: Increase/decrease the number of products scraped
  • Custom email templates: Edit the outreach message to match your brand
  • Add email verification: Integrate ZeroBounce or similar services
  • Connect to your CRM: Pipe leads directly to Salesforce, HubSpot, or Pipedrive
  • Slack/Discord notifications: Get alerted when new leads are found

Support & Updates

  • Lifetime updates: Get all future improvements and bug fixes
  • Email support: Questions? We're here to help with setup, Email Us
  • Community access: Join our Skool community with other users sharing tips and customizations
  • Documentation: Comprehensive guides covering every feature

Get Started Today

Stop losing leads to competitors. Start automatically capturing fresh Product Hunt leads every single day.

Purchase Workflow - One time payment, lifetime access

View Technical Setup Guide - See what's involved

Join Community - Connect with other users


Frequently Asked Questions

Q: Do I need coding skills? A: No! The workflow is pre built and ready to import. Basic n8n familiarity is helpful but not required.

Q: What are the ongoing costs? A: Approximately $65 to $95/month total ($40-60 for Apify scraping services + $20 for n8n cloud, or $0 if you self host on Railway or Hostinger).

Q: Is this legal? A: Yesm all data is publicly available on Product Hunt and product websites. Follow ethical outreach practices.

Q: Can I scrape more/fewer products? A: Absolutely! The workflow is fully customizable. Adjust the "topNProducts" parameter in the config.

Q: What if emails bounce or accounts get banned? A: The guide includes best practices for email deliverability and warnings about sending volume limits.

Q: Can I use this for specific product categories? A: Yes! You can filter by category in the Apify scraper configuration.

Q: Does this work with Gmail? A: Yes! The workflow now uses Gmail API by default for better deliverability and tracking. You can customize it for other providers by using the SMTP node


Ready to automate your lead generation? Get the Product Hunt Scraper workflow today and start building your pipeline on autopilot.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Prepare CC

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 2 - Schedule Trigger1

Type / Role
n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices
Version 1.2

Block 3 - Build Config2

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 4 - Check Schedule Trigger2

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 5 - Fetch Webhook Status2

Type / Role
n8n-nodes-base.dataTable - dataTable
Config choices
Version 1

Block 6 - Check Webhook Exists2

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 7 - Create External Webhook2

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 8 - Mark Webhook as Created2

Type / Role
n8n-nodes-base.dataTable - dataTable
Config choices
Version 1

Block 9 - Check Weekly Run (Monday)2

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 10 - Combine Run IDs2

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 11 - Store Run Data2

Type / Role
n8n-nodes-base.dataTable - dataTable
Config choices
Version 1

Block 12 - Receive Apify Webhook2

Type / Role
n8n-nodes-base.webhook - webhook
Config choices
Version 2.1

Block 13 - Fetch RUNS Data2

Type / Role
n8n-nodes-base.dataTable - dataTable
Config choices
Version 1

Block 14 - Update Run Status2

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 15 - Save Updated RUNS Data1

Type / Role
n8n-nodes-base.dataTable - dataTable
Config choices
Version 1

Block 16 - Extract Dataset IDs2

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 17 - Switch

Type / Role
n8n-nodes-base.switch - switch
Config choices
Version 3.3

Block 18 - Run Actor "Daily Top Products"2

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 19 - Run Actor "Weekly Top Products"2

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 20 - Create Daily Log Sheet2

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 21 - Extract Sheet Info2

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 22 - Store Sheet Metadata2

Type / Role
n8n-nodes-base.dataTable - dataTable
Config choices
Version 1

Block 23 - Loop Over Sub Items2

Type / Role
n8n-nodes-base.splitInBatches - splitInBatches
Config choices
Version 3

Block 24 - Map Category by Topic2

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Showing the first 24 of 56 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Automate product Hunt lead generation with Apify and Google Sheets
Complexity advanced
Nodes 56
Categories Lead Generation, AI Summarization
Author Jay Emp0
Published 19 Dec 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/11947/11947.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Automate product Hunt lead generation with Apify and Google Sheets do?

Product Hunt Scraper Automated Lead Generation Workflow Turn Product H...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Lead Generation, AI Summarization use case.