Automated Affiliate Content Pipeline
An n8n-powered AI pipeline that researches, generates, and publishes SEO-focused affiliate listicles automatically, producing article each day.
Tech Stack
What problem does it solve?
Creating an article required manually researching topics, writing content, finding products and images, generating affiliate links, formatting the article, and uploading it to the CMS.
This automation turns the entire process into a daily pipeline with minimal manual intervention. The generated articles are published on TopListPH.
How it works
Topic selection
A daily n8n Schedule Trigger runs a custom algorithm that selects an unused category to prevent duplicate topics.
AI article generation
An OpenAI LLM with web search researches the topic and generates an SEO-focused listicle. The prompts are engineered around search intent and factors that can improve its potential to rank on Google.
Product research
Serper API searches Google for relevant product images and matching Shopee listings based on the products mentioned in the article.
Affiliate links
Relevant product URLs are passed to the Involve Asia API and converted into trackable affiliate links.
Content publishing
The article, images, products, and affiliate links are transformed into Sanity Block Content and uploaded automatically for the Next.js website.
Result
A fully automated pipeline that turns a topic into a researched, SEO-focused affiliate article with relevant products, images, and monetized links every day.