n8n Affiliate Offer Search & Scoring via Webhook, Base44 + GPT

Find the best affiliate offers—then score and analyze them automatically

This n8n workflow exposes a POST webhook that searches affiliate offers stored in Base44, filters and ranks matches, and enriches the top results with OpenAI (GPT-4.1-mini) qualitative analysis—returning a ready-to-use JSON list of up to 25 offers with traffic-source suitability scores.

What this workflow does

• Receives a POST request on /offerhunt/search with a search query, optional filters, and requester preferences.
• Normalizes the request into a Base44 search: it converts the search text into a Base44 query that matches against offer title, category, and vendor, while applying filters such as category, network, and a minimum AI score.
• Queries Base44 offers via its API and returns a 502 JSON error if the data source is unavailable.
• Maps results to a consistent schema, derives a competition label from the gravity score, applies additional filters, sorts by AI score, and keeps the top 25.
• Enriches each top offer using OpenAI (GPT-4.1-mini) to generate a score label, strengths, risks, and suitability scores for SEO, YouTube, TikTok, and email based on offer data and requester preferences.
• Returns a final JSON payload including: success, the original query, total_results, and the enriched offers array.

Use cases

• Build an affiliate offer finder inside your SaaS: query Base44 and instantly rank offers with AI insights.
• Automate content planning for YouTube/TikTok/SEO/email campaigns by selecting offers matched to your traffic source.
• Use n8n to power internal “offer hunting” dashboards with consistent scoring and risk/strength summaries.

Technical details

• Webhook endpoint: POST /offerhunt/search
• Base44 integration: create a Base44 personal API key, store it in n8n, and replace the placeholder header in the Base44 request; set BASE44_APP_ID in n8n variables.
• OpenAI enrichment: uses GPT-4.1-mini per selected offer.
• Workflow nodes mentioned: set, code, sticky note, html extract, http request, schedule trigger.