Track Daily Product Hunt Launches with Website Verification in Google Sheets
This workflow helps you stay updated with daily launches on Product Hunt. It automatically fetches product details (name, tagline, description, and website), checks if the website redirects to another URL, and logs the final information into a Google Sheet.
Perfect for indie hackers, product managers, content curators, and anyone tracking daily launches.
How It Works
Schedule Trigger – Runs the workflow daily.
Set Date – Captures today’s date in ISO format for filtering Product Hunt posts.
HTTP Request (Product Hunt API) – Retrieves Product Hunt posts for the day using GraphQL.
Extract Product Info (Code Node) – Parses the response to pull key details:
Name
Tagline
Description
Website URL
HTTP Request (URL Check) – Follows each website URL to detect if it redirects.
Merge Data – Combines product info with the final destination URL.
Google Sheets Node – Appends all processed product info to your sheet.
Pre-conditions
A valid Product Hunt API token A Google account with access to Google Sheets A Google Sheet already created with the correct columns (see below) Connected Google Sheets and HTTP credentials in n8n
Google Sheets Setup
Your spreadsheet should include the following columns (in order):
Name
Tagline
Description
Original URL
Final URL (after redirect)
Ensure your Google Sheets node uses the correct Spreadsheet ID and Sheet Name.
Setup Instructions
Product Hunt API Auth:
Replace {{YOUR_PRODUCT_HUNT_API_KEY}} in the HTTP Request headers:
{
"Authorization": "Bearer {{YOUR_PRODUCT_HUNT_API_KEY}}"
}
Google Sheets Node:
Connect your Google account.
Insert your Spreadsheet ID in the settings.
Specify the sheet name (e.g., Daily Launches).
Use the “Append” operation and map the 5 data fields accordingly.
Notes
Only fetches the first 10 posts for the day (can be extended). Consider adding Slack, Discord, or Email nodes to notify you of new entries. Useful for building launch databases, research, or content inspiration.
Related Templates
AI Weather Forecasts with MCP Integration
Real-time Weather Forecasts with MCP Tools This n8n workflow demonstrates how to integrate real-time weather intelligen...
Google Sheets UI for n8n Workflow
Google Sheets UI for Workflow Control This n8n template provides a practical and efficient way to manage your n8n workf...
Demo Workflow - How to use workflowStaticData()
This workflow demonstrates how to use the workflowStaticData() function to set any type of variable that will persist wi...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments