{"product_id":"amazon-best-sellers-rank-tracker-w-n8n-google-sheets-slack","title":"Amazon Best Sellers Rank Tracker w\/ n8n, Google Sheets \u0026 Slack","description":"\u003ch3\u003eTrack Amazon Best Seller rank changes automatically—every morning, straight to Google Sheets and Slack\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eAmazon Best Sellers Rank Tracker\u003c\/strong\u003e workflow for \u003cstrong\u003en8n\u003c\/strong\u003e pulls the \u003cstrong\u003eTop 50\u003c\/strong\u003e products from an Amazon Best Sellers category every day, compares their ranks to yesterday, writes a daily history to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and alerts you in \u003cstrong\u003eSlack\u003c\/strong\u003e when a product enters the \u003cstrong\u003eTop 10\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 06:00\u003c\/strong\u003e using an n8n Schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches Amazon Best Sellers charts\u003c\/strong\u003e by calling the \u003ca href=\"https:\/\/apify.com\/kestrel\/amazon-best-sellers-scraper\" target=\"_blank\" rel=\"noopener\"\u003eAmazon Best Sellers Scraper\u003c\/a\u003e (Apify) via the workflow’s core \u003cstrong\u003eHTTP Request\u003c\/strong\u003e node.\u003c\/li\u003e\n  \u003cli\u003eRequests one Best Sellers page with \u003cstrong\u003ecategories: [\"electronics\"]\u003c\/strong\u003e, \u003cstrong\u003elimit capped at 50\u003c\/strong\u003e, and \u003cstrong\u003efillRanks enabled\u003c\/strong\u003e so ranks 1–50 are complete (Amazon renders only 30 entries per page unless ranks are filled).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes rank moves\u003c\/strong\u003e in a \u003cstrong\u003eCode\u003c\/strong\u003e node: it keeps \u003cem\u003etype = product\u003c\/em\u003e rows, looks up yesterday’s rank using workflow static data (up to \u003cstrong\u003e5,000 keys\u003c\/strong\u003e) by \u003cstrong\u003ecategory|chart|asin\u003c\/strong\u003e, and calculates \u003cstrong\u003echange\u003c\/strong\u003e (e.g., \u003cem\u003e+3\u003c\/em\u003e, \u003cem\u003e-2\u003c\/em\u003e, \u003cem\u003e0\u003c\/em\u003e, or \u003cem\u003enew\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends all 50 rows\u003c\/strong\u003e to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e as a daily tracking history.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack alert for new Top 10 entries\u003c\/strong\u003e: if \u003cstrong\u003echange = new\u003c\/strong\u003e and \u003cstrong\u003erank ≤ 10\u003c\/strong\u003e, it posts \u003cstrong\u003eone message per new entry\u003c\/strong\u003e; otherwise it does nothing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBrand managers\u003c\/strong\u003e monitoring category momentum in Amazon Best Sellers.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProduct researchers\u003c\/strong\u003e hunting “movers” based on rank change.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAgencies\u003c\/strong\u003e reporting daily chart positions to stakeholders with an audit-friendly Google Sheets history.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify actor\u003c\/strong\u003e: Amazon Best Sellers Scraper (invoked via \u003cstrong\u003eHTTP Request\u003c\/strong\u003e run-sync endpoint).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuthentication\u003c\/strong\u003e: use an n8n credential named \u003cstrong\u003eApify Header Auth\u003c\/strong\u003e with header \u003cstrong\u003eAuthorization\u003c\/strong\u003e = \u003cstrong\u003eBearer \u0026lt;your Apify token\u0026gt;\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: Schedule Trigger, HTTP Request, Code, IF, Slack, NoOp, Sticky Note.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916547023027,"sku":"N8N-18838","price":47.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/I98lp5_K454BIM9QQfRXF_xmpVFkvZ.png?v=1788035010","url":"https:\/\/buyflowscripts.com\/products\/amazon-best-sellers-rank-tracker-w-n8n-google-sheets-slack","provider":"N8N Commerce","version":"1.0","type":"link"}