FM
FlowMarket
Ecommerce & Sales Intermediate ⚡ 15 n8n Nodes

Monitor Amazon product prices with Bright Data and Google Sheets

Amazon Price Monitoring Workflow This workflow enables you to monitor the prices of Amazon product listings directly from a Google Sheet, using data provided...

🔌 Nodes & Integrations Used (2)

HTTP Request Google Sheets

📖 Implementation & Setup Guide

Amazon Price Monitoring Workflow

This workflow enables you to monitor the prices of Amazon product listings directly from a Google Sheet, using data provided by Bright Data’s Amazon Scraper API. It automates the retrieval of price data for specified products and is ideal for market research, competitor analysis, or personal price tracking.

✅ Requirements

Before using this template, ensure you have the following: - A Bright Data account and access to the Amazon Scraper API. - An active API key from Bright Data. - A Google Sheet set up with the required columns. - N8N account (self-host or cloud version)

⸻

⚙️ Setup #### 1. Create a Google Sheet with the following columns: - Product URL - ZIP Code (used for regional price variations) - ASIN (Amazon Standard Identification Number)

#### 2. Extract ASIN Automatically using the following formula in the ASIN column:

``` =REGEXEXTRACT(A2, "/(?:dp|gp/product|product)/([A-Z0-9]{10})") ``` - Replace A2 with the appropriate cell reference

#### 3. Obtain an API Key:

  • Sign in to your Bright Data account.
  • Go to the API section to generate an API key.
  • Create a Bearer Authentication Credential using this key in your automation tool.
  • #### 4. Configure the Workflow:
  • Use a node (e.g., “Google Sheets”) to read data from your sheet.
  • Use an HTTP Request node to send a query to Bright Data’s Amazon API with the ASIN and ZIP code.
  • Parse the returned JSON response to extract product price and other relevant data.
  • Optionally write the output (e.g., current price, timestamp) back into the sheet or another data store.

⸻

Workflow Functionality

  • The workflow is triggered periodically (or manually) and reads product details from your Google Sheet.
  • For each row, it extracts the Product URL and ZIP code and sends a request to the Bright Data API.
  • The API returns product price information, which is then logged or updated back into the sheet using ASIN.
  • You can also map the product URL to the product URL, but ensure that the URL has no parameters. If the URL has appended parameters, refer to the input field from the Bright Data snapshot result.

⸻

💡 Use Cases - E-commerce sellers monitoring competitors’ prices. - Consumers tracking price drops on wishlist items. - Market researchers collecting pricing data across ZIP codes. - Affiliate marketers ensuring accurate product pricing on their platforms.

⸻

🛠️ Customization - Add columns for additional product data such as rating, seller, or stock availability. - Schedule the workflow to run hourly, daily, or weekly depending on your needs. - Implement email or Slack alerts for significant price changes. - Filter by product category or brand to narrow your tracking focus.

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Monitor_Amazon_product_prices_with_Bright_Data_and_Google_Sheets.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related Ecommerce & Sales Workflows

View All in Ecommerce & Sales →