Collect new product launches every day without manual copy and paste. The flow pulls the latest Product Hunt posts and saves clean details into a Google Sheet. It helps growth teams, product marketers, and founders track market trends and build a daily research log.

A scheduled trigger runs once per day and sets today’s date. An HTTP request calls the Product Hunt GraphQL API for up to 10 posts within the current day. A code step extracts name, tagline, description, and website. Another HTTP call checks if the website redirects and captures the destination URL. Two set nodes keep fields clean, a merge step combines product and redirect details, and Google Sheets appends the rows. You get a consistent, ready to analyze sheet without manual effort.

You will need a Product Hunt access token and a Google Sheets connection. Expect to cut research time from about an hour to a few minutes per day while improving data quality. Use it for newsletter curation, partnership scouting, and competitor tracking. Follow the setup to connect your credentials and pick the sheet where new rows will be stored.

• Daily schedule trigger that runs at a set time
• Date builder creates an ISO today value for time bound queries
• GraphQL API call pulls the day’s Product Hunt posts
• Code step extracts name, tagline, description, and website
• HTTP call captures the final website after redirect using headers
• Set nodes keep only the needed fields for a clean dataset
• Google Sheets appends rows to the selected sheet for easy analysis

• Reduce manual research from 60 minutes to 5 minutes daily
• Automate 100 percent of daily Product Hunt logging
• Improve data consistency by 90 percent with structured fields
• Connect Product Hunt and Google Sheets in one flow
• Handle up to 10 new launches per day without extra work

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Product Hunt and Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. Create your Product Hunt access token. Follow the official OAuth guide to generate a user access token, then copy the token value.
4. Open the HTTP Request node that fetches Product Hunt posts. In the Headers section, set Authorization to Bearer YOUR_TOKEN. You can store the token in an environment variable if desired.
5. In n8n credentials manager, create a Google Sheets credential using Service Account. Upload the service account JSON and save the credential.
6. Share your target Google Sheet with the service account email so it can write rows. Give Editor permission.
7. Open the Google Sheets node. Select your credential, choose the document, and pick the sheet tab. Keep operation as Append to add new rows.
8. Check the Set Date node to confirm the today field uses the correct timezone for your use case. Adjust schedule time in the trigger so the run happens after Product Hunt posts are live for the day.
9. Run a test. Execute from the schedule or click Execute Node on the HTTP nodes and Google Sheets node to verify that rows are created with name, tagline, and description.
10. Troubleshoot common issues: 401 from Product Hunt means the token is wrong or expired, generate a new token. 403 or Not Found on Google Sheets means the sheet is not shared with the service account or the document ID is incorrect.
11. Optional check on redirects: Open the Resolve Website Redirection node response. If the location header is empty, the site did not redirect, which is normal for some links.