Track Daily Product Hunt Launches with Website Verification in Google Sheets

This workflow streamlines staying updated with new Product Hunt launches by running daily. It fetches posts using the Product Hunt GraphQL API, extracts key details like name, tagline, description, and website URL via a code node, checks for redirects on each site, and appends the finalized data to a Google Sheet.

Benefits include saving hours of manual scraping, ensuring accurate final URLs (crucial for broken links or trackers), and providing a centralized log for analysis. Ideal for indie hackers spotting trends, product managers researching competitors, content curators finding stories, or marketers tracking SaaS launches.

Setup is straightforward: add your Product Hunt API token, connect Google Sheets credentials, and ensure your sheet has columns for Name, Tagline, Description, Original URL, and Final URL. The workflow handles parsing complex API responses and HTTP redirects automatically, making it reliable for long-term use.

Use cases extend to building launch databases, generating reports, or triggering further automations like email alerts on specific keywords.