Step 2: Connect Google Sheets

Google Sheets stores enriched product rows and the category translation dictionary.

1. Open Find Tool by Title and set the Sheet to Tools and Document to Main Spreadsheet (replace [YOUR_ID] with your sheet ID).
2. In Find Tool by Title, set the filter Title lookup to {{ $json.Title }}.
3. Open Store Enriched Tool Row, set Operation to appendOrUpdate, Sheet to Tools, and map Title to {{ $json.Title }}.
4. Configure Read Category Dictionary to read the Category Dictionary sheet from Main Spreadsheet.
5. Configure Write Category Dictionary with Operation appendOrUpdate and map the columns to {{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Category_Name_English', ``, 'string') }} and {{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Category_Name_French', ``, 'string') }}.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials for Find Tool by Title, Store Enriched Tool Row, Read Category Dictionary, and Write Category Dictionary.

Step 3: Set Up AI Enrichment

The AI agent translates and enriches product data, using a category dictionary as tools.

1. Connect OpenAI Mini Model as the language model for AI Enrich Product Data.
2. In OpenAI Mini Model, set the Model to gpt-4.1-mini.
3. In AI Enrich Product Data, set Text to {{JSON.stringify($json)}} and keep Prompt Type as define.
4. Confirm Read Category Dictionary and Write Category Dictionary are connected as AI tools to AI Enrich Product Data.
5. Credential Required: Connect your openAiApi credentials for OpenAI Mini Model.

Step 4: Configure API Fetch and Pagination

This section requests Product Hunt data, formats it, and manages pagination.

1. In Request Product Hunt API, set URL to https://api.producthunt.com/v2/api/graphql, Method to POST, and Body to the JSON expression: ={ "query": "{ posts(order: RANKING, first:5 , after: \"{{ $json.cursor }}\") { edges { cursor node { name description tagline website thumbnail { url } topics { edges { node { name } } } media { videoUrl type url } productLinks { type url } } } pageInfo { endCursor hasNextPage } } }" } .
2. Enable JSON headers in Request Product Hunt API and set Headers to { "Content-Type": "application/json", "Accept": "application/json" }.
3. Credential Required: Connect your oAuth2Api credentials in Request Product Hunt API.
4. In Format API Response, keep the existing code that maps Product Hunt edges into fields like Title, Description, category, UrlDemo, and UrlLogo.
5. In Get Pagination Details, set cursor to {{ $('Request Product Hunt API').first().json.data.posts.pageInfo.endCursor }} and hasnextpage to {{ $('Request Product Hunt API').first().json.data.posts.pageInfo.hasNextPage }}.
6. In Check Next Page, keep the condition {{ $json.hasnextpage }} so the loop only continues when more pages exist.

Step 5: Configure Output Storage and Loop Control

This stage prevents duplicates, parses AI output, stores enriched rows, and controls pagination timing.

1. In Find Tool by Title → Check New Tool, keep the condition {{ $json.isEmpty() }} to process only new products.
2. In Parse AI JSON Output, keep the JavaScript that strips markdown and parses raw JSON from the AI output.
3. Ensure Store Enriched Tool Row runs after Parse AI JSON Output to write enriched data into the Tools sheet.
4. Configure Delay 15 Seconds with Amount set to 15 to throttle pagination requests.
5. In Iteration Safety Gate, keep the condition {{$runIndex}} > 50 to prevent endless looping.
6. Leave Loop Continuation as a no-op node to continue the pagination loop after delays.

Step 6: Test and Activate Your Workflow

Run a manual test to confirm the Product Hunt API request, AI enrichment, and Google Sheets output all work as expected.

1. Click Execute Workflow and verify Request Product Hunt API returns data.
2. Confirm Format API Response outputs structured items with fields like Title, Description, and UrlDemo.
3. Check AI Enrich Product Data produces valid JSON and that Parse AI JSON Output parses it without errors.
4. Verify new records appear in the Tools sheet via Store Enriched Tool Row.
5. Once verified, toggle the workflow to Active so Daily Schedule Start runs daily.