Quick overview
This workflow runs daily to fetch your Shopify catalog and a competitor’s Shopify catalog via Bright Data, compares their product pricing against your price range, and emails a digest through Gmail highlighting newly seen products, sell-outs, and how their prices sit relative to yours.
How it works
- Runs every day on a schedule.
- Fetches
/products.json from both your Shopify store and the competitor’s store through Bright Data Web Unlocker.
- Parses each catalog into normalized product records (price range, stock status, product type, published date, and product URL) and stops with an error if a store does not return Shopify JSON.
- Compares each competitor product’s price against your min/max price band for the same product type, falling back to your whole-catalog price range when types don’t match.
- Checks an n8n Data Table to keep only competitor products that have not been reported before and stores their unique product keys for future runs.
- Builds an HTML report (or a “nothing new” message) and sends it to the configured recipient using Gmail.
Setup
- Create a Bright Data Web Unlocker zone and add an HTTP Header Auth credential for the Bright Data API.
- Add a Gmail credential that is allowed to send emails from the account you want to use.
- Create an n8n Data Table named
shopify_products_seen with a product_key column.
- Update the Settings values for
your_store, competitor_store, email_to, and unlocker_zone, and optionally adjust new_within_days, max_products_reported, and currency_symbol.