This n8n workflow automates the process of fetching daily top posts from Product Hunt and populating a Google Sheets document with detailed product information. The workflow is scheduled to run daily and performs several key steps:
1. **Schedule Trigger:** Initiates the workflow every day at a specified interval.
2. **Date Setup:** Sets the current date for filtering Product Hunt posts.
3. **API Request:** Sends a GraphQL query to Product Hunt’s API with the current date to fetch the latest posts.
4. **Data Extraction:** Extracts product details such as name, tagline, description, and website from the API response.
5. **Website Redirection Handling:** Resolves any URL redirects for product websites to ensure accurate links.
6. **Data Merging:** Combines product details with their corresponding redirect URLs.
7. **Google Sheets Upload:** Appends or updates the information in a designated Google Sheets document for easy tracking and analysis.
This workflow is ideal for marketers, content curators, or product managers who want to keep a daily record of trending products on Product Hunt for analysis, reporting, or content creation purposes. By automating data collection and storage, users can save time and ensure data consistency.
