Who's it for
Who's it for Indian Amazon affiliate marketers, content creators, and dropshipping researchers who waste hours every morning hunting for trending products — only to pick items that pay 1% commission on electronics. This workflow does that hunt for you and only surfaces products that pay 4% or more. How it works Every morning at 08:02 IST, the workflow: Detects the current Indian retail season — Summer (Mar–May), Monsoon (Jun–Aug), Festive/Diwali (Sep–Nov), or Winter (Dec–Feb) — and randomly picks one matching Amazon Bestsellers category for the day. Scrapes the top 50 products from that category page via the Apify Amazon Bestsellers actor, with a hard $0.05/run cost cap so your daily spend stays predictable. Scores every product against a 4-layer formula: category commission rate (drops anything under 4%), review count, average rating, and seasonal keyword match in the title. Saves the Top 10 winners to a Google Sheet with status = Pending, ready for any downstream content or posting workflow to pick up. The output sheet is pre-structured with status columns for Facebook, Instagram, LinkedIn, Twitter, Threads, and YouTube — so it slots cleanly into a multi-platform affiliate content engine. How to set up Total setup time: ~10 minutes. Install the Apify community node (@apify/n8n-nodes-apify) from Settings → Community Nodes. Add your Apify API credential and select it inside the Apify nodes. Create a Google Sheet with the column headers listed in the Setup sticky note on the canvas, then paste your Sheet ID into the final node. Connect a Google Sheets OAuth2 credential. Activate the workflow. Full step-by-step instructions are in the colored sticky notes on the canvas. Requirements Apify account (free tier is enough). Google account with Sheets access. Apify community node installed in your n8n instance. How to customize Edit the seasonal category map in the Seasonal Category Selector Code node to target other countries (just swap amazon.in URLs for amazon.com, amazon.co.uk, etc.) or to focus on a single niche. Tweak the commission percentage map and minimum-commission floor in the Score & Select Top 10 Code node to match your region's affiliate rates. Change the Schedule Trigger to run multiple times a day, or only on weekdays, depending on your content cadence. An n8n automation workflow template by Rahul Shah.
Rahul Shah
web
paid
Others in the same category, ranked by how often they are opened.
