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)
📖 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:
- Click the Direct Download JSON button above to save
Monitor_Amazon_product_prices_with_Bright_Data_and_Google_Sheets.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Ecommerce & Sales Workflows
View All in Ecommerce & Sales →Add new customers from WooCommerce to Mautic
This workflow uses a WooCommerce trigger that will run when a new customer has been added, It will then add the customer to Mautic. To use this workflow you ...
Add new products to Stripe when product added to Pipedrive
This workflow adds a new product in Stripe whenever a new product has been added to Pipedrive. Prerequisites - Stripe account and Stripe credentials - Pipedr...
Add product ideas to Google Sheets via a Slack
Use Case This workflow is a slight variation of a workflow we're using at n8n. In most companies, employees have a lot of great ideas. That was the same for ...
Add product ideas to Notion via a Slack command
Use Case In most companies, employees have a lot of great ideas. That was the same for us at n8n. We wanted to make it as easy as possible to allow everyone ...