Data Sync & ETL
Monitor Amazon MAP violations in offer listings with Google Sheets and ScrapeHero
When you run it, it moves and syncs data using Google Sheets, Scrape Hero.
What it does
## Amazon MAP Violation Monitor - Google Sheets + Offer Listings ### How it works This workflow manually checks Amazon listings for MAP violations using product ASINs and MAP prices from Google Sheets. It normalizes each input row, fetches current Amazon offer listings through ScrapeHero, combines them with previous offer history, and analyzes seller-level pricing changes. It then writes violation summaries and updated offer price history back to Google Sheets. ### Setup steps - Configure Google Sheets credentials in n8n for all Sheets nodes. - Configure the ScrapeHero credentials/API access for the Amazon offer listings node. - Set the input sheet to contain ASIN and MAP price columns expected by the normalization code. - Configure the previous offer history, violation output, and offer price history Google Sheets nodes to point to the correct spreadsheets, tabs, and columns. - Review the code nodes for expected field names and date/price formatting before running the manual trigger. ### Customization Adjust the analyzer code to change MAP violation rules, seller matching, price-change thresholds, or the output fields appended to Google Sheets.
The steps
- Manual Execution Start
- Normalize Product Data
- Scrape Amazon Offer Listings
- Analyze MAP Violations
- Compile Final MAP Results
- Fetch Offer History from Sheets
- Expand Offer History Rows
- Append Offer History to Sheets
- Merge Offer and History Data
- Fetch ASIN and MAP Data
- Update Violation Info in Sheets
Similar automations
Web Scraping & ResearchScrape Amazon Keyboard Products into Google Sheets4 stepsMCP Servers & ToolsManage eBay Listing Violations as an MCP Server4 stepsWeb Scraping & ResearchAnalyze Amazon and Flipkart reviews weekly with Apify, OpenAI and Google Sheets56 stepsE-commerce & PaymentsTrack Amazon Product Prices and Email Price Drop Alerts35 steps