Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Data Sync & ETL

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

  1. Manual Execution Start
  2. Normalize Product Data
  3. Scrape Amazon Offer Listings
  4. Analyze MAP Violations
  5. Compile Final MAP Results
  6. Fetch Offer History from Sheets
  7. Expand Offer History Rows
  8. Append Offer History to Sheets
  9. Merge Offer and History Data
  10. Fetch ASIN and MAP Data
  11. Update Violation Info in Sheets

Similar automations