Daily Product Hunt Launch Tracker to Google Sheets - n8n Workflow

Market Researchers: Users needing daily competitive intelligence on new tech products.
Product Managers: Professionals tracking industry trends and competitor launches.
Automation Enthusiasts: Individuals looking for sophisticated examples of parallel data processing and merging within an n8n workflow.
Data Aggregators: Anyone needing a reliable n8n templates solution for API data ingestion and spreadsheet logging.

Keeping track of new products launched on Product Hunt daily is crucial for market analysis, but manually visiting and cleaning the destination links can be time-consuming. This specialized n8n workflow solves this by automatically running every morning using an n8n trigger.

It queries the Product Hunt API for today's launches, processes the resulting list in parallel to extract core details and resolve the website's final redirect URL, ensuring you capture the product's true landing page rather than a tracking link. The consolidated, clean data is then saved directly into a Google Sheet. This makes the entire process hands-off and provides a reliable, structured dataset for further analysis, showcasing the efficiency of a well-designed n8n node sequence.

This comprehensive n8n workflow operates through seven distinct stages:

1. Scheduling: The automation begins with a Daily Trigger n8n trigger, ensuring the n8n workflow executes once a day.


2. Date Preparation: A Set n8n node calculates and stores the current date, which is dynamically used to filter the Product Hunt API request.


3. API Fetching: An HTTP Request n8n node connects to the Product Hunt GraphQL API. It uses the calculated date to retrieve all products launched specifically today, requiring a valid API key configured in the n8n node.


4. Data Structure Refinement: A Code n8n node, named 'Extracts Product Info', iterates through the complex API response structure and maps the critical data points (name, tagline, description, website) into clean, individual items, preparing them for parallel execution.


5. Parallel Redirection Resolution: The flow splits. While product details are preserved, another HTTP Request n8n node attempts to access the website URL. Critically, it is configured not to follow redirects, allowing the n8n workflow to capture the final destination URL from the response headers (location). This is the key technical insight of this n8n template.


6. Data Merge and Cleaning: A Function n8n node (Merge Data) synchronizes the two parallel paths. It merges the core product details with the resolved website URL, and uses custom code to strip Product Hunt referral tags (?ref=producthunt) from the final URL, ensuring clean data.


7. Logging to Google Sheets: The final Google Sheets n8n node appends the fully structured, clean data (Name, Tagline, Description, Resolved URL) into your designated Google Sheet, completing the automated n8n workflow.

To deploy this powerful n8n workflow, follow these steps:

1. Import the n8n workflow: Copy the provided JSON data and paste it directly into your n8n instance via the 'New' -> 'Import from JSON' option.


2. Product Hunt API Key:

1. Google Sheets Credentials:

1. Activation: Ensure the n8n workflow is activated to run on its daily schedule trigger.


2. Testing: Run the n8n workflow manually once to verify all API calls and the Google Sheets output are working correctly before relying on the daily n8n trigger.

Daily Trigger (n8n trigger):
Function: Starts the n8n workflow daily at the configured time.
Key Configuration: Uses a Schedule Trigger set to run once per day.
Set Date1 (Set n8n node):
Function: Generates today's date in YYYY-MM-DD format using a Javascript expression, necessary for the Product Hunt API filter.
Fetches today’s Product Hunt posts via API. (HTTP Request n8n node):
Function: Executes the Product Hunt GraphQL query to fetch launches between 00:00:00Z and 23:59:59Z of the current date.
Key Configuration: Uses the POST method and requires a Bearer token authorization header.
Extracts Product Info (Code n8n node):
Function: Parses the verbose JSON output from the GraphQL API, extracting and flattening the core product attributes (name, tagline, description, website).
Resolve Website Redirection (HTTP Request n8n node):
Function: Resolves the final destination URL.
Key Configuration: Follow Redirect is set to false and Full Response is enabled, allowing the n8n node to capture the redirect location from the response headers.
Merge Data (Function n8n node):
Function: Custom code that combines the product description data (from 'Data 1') and the resolved URL data (from 'Data 2') into a single output item, simultaneously cleaning the URLs.
Appends all details (Google Sheets n8n node):
Function: Writes the final, merged, and cleaned product launch data into the specified Google Sheet.
Key Configuration: Operation set to Append Or Update to log new entries daily.