{"product_id":"track-amazon-map-violations-with-scrapehero-google-sheets-n8n","title":"Track Amazon MAP Violations with ScrapeHero + Google Sheets (n8n)","description":"\u003ch3\u003eTrack Amazon MAP Violations Automatically with ScrapeHero + Google Sheets (n8n)\u003c\/h3\u003e\n\u003cp\u003eRun an n8n workflow to check Amazon ASINs in your Google Sheets against your defined MAP prices using \u003cstrong\u003eScrapeHero’s Amazon Offer Listings API\u003c\/strong\u003e, then log violations and seller-level price history back to the sheet—one up-to-date audit trail at a time.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual trigger:\u003c\/strong\u003e Start the workflow on demand in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads inputs from Google Sheets:\u003c\/strong\u003e Pull ASINs and “MAP Price” values from a specified input tab, and load prior snapshots from an \u003cem\u003e“Offer Price History”\u003c\/em\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes each row:\u003c\/strong\u003e Clean up ASIN formatting and parse the MAP price before querying Amazon offers.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks current seller offers:\u003c\/strong\u003e For each ASIN, query \u003cstrong\u003eScrapeHero’s Amazon Offer Listings API\u003c\/strong\u003e (amazonOfferListing) to retrieve current seller offers.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlags MAP violations:\u003c\/strong\u003e Compare each offer price to the MAP price and mark violations where \u003cstrong\u003eoffer price \u0026lt; MAP\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates per-seller changes:\u003c\/strong\u003e Match offers to the latest saved history entry to compute price movement by seller.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results with upsert by ASIN:\u003c\/strong\u003e Store a per-ASIN summary (violation status, counts, lowest price, violating sellers, and JSON details) in the results tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends audit history:\u003c\/strong\u003e Add one row per seller offer to \u003cem\u003e“Offer Price History”\u003c\/em\u003e to keep an append-only record for future change detection.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor multiple products for \u003cstrong\u003eAmazon MAP policy compliance\u003c\/strong\u003e without manual checks.\u003c\/li\u003e\n  \u003cli\u003eTrack which sellers are discounting below MAP and view their \u003cstrong\u003eprice history\u003c\/strong\u003e over time.\u003c\/li\u003e\n  \u003cli\u003eProvide SaaS operators or ecommerce teams a repeatable \u003cstrong\u003eMAP violation reporting\u003c\/strong\u003e workflow using n8n + Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e Manual Trigger, Code, Merge, Sticky Note, Google Sheets, and \u003cstrong\u003en8n-nodes-scrapeheroes\u003c\/strong\u003e ScrapeHero integration.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapeHero API:\u003c\/strong\u003e Amazon Offer Listings API using the \u003ccode\u003eamazonOfferListing\u003c\/code\u003e configuration.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSpreadsheet requirements:\u003c\/strong\u003e Input tab includes headers for at least \u003cem\u003eASIN\u003c\/em\u003e and \u003cem\u003eMAP Price\u003c\/em\u003e; results and history tabs use the configured tab names and IDs.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46275697017011,"sku":"N8N-21451","price":22.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/a5RvTA1dZBSiYj1RHarcs_3sPeMd3A.png?v=1792833433","url":"https:\/\/buyflowscripts.com\/products\/track-amazon-map-violations-with-scrapehero-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}