Find daily Amazon India bestsellers with Apify and Google Sheets (4%+ commission)

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:

1. 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. 2. 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. 3. 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. 4. 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.