Step-by-step workflow
1
Set up keyword queue in Google Sheets
Create a Sheet: Keyword, Status, Published URL columns. Add target keywords.
2
Research with Perplexity API
n8n calls Perplexity to research each keyword.
"Research keyword '[keyword]' for SEO. Return JSON: {intent, competitor_angles, key_stats, related_keywords, h2_structure}"
3
Write article with Claude
Pass research to Claude for full article.
"Write a 1500-word SEO article for '[keyword]'. Structure: [research.h2_structure]. Include Amazon affiliate links for: [products]. Indian audience, conversational tone. Return Markdown."
4
Publish to WordPress via REST API
POST to WordPress /wp-json/wp/v2/posts with title, content, tags, status=draft.
5
Mark published and request indexing
Update Google Sheets status. Call Google Search Console API to request indexing.
Pro tips
→
Always review before publishing — add your own examples
→
Target "best [product] under ₹[price] in India" — low competition, high buyer intent
→
At 3 articles/day = 90/month = compounding SEO growth
Why this matters for India
// india context
Amazon Associates India pays 4-9% commission. 50,000 monthly visitors can earn ₹20,000-60,000/month