Track Amazon Prices & Monitor Competitors with Apify and Google Sheets

Amazon Price Tracker & Competitor Monitoring Workflow (Apify + Google Sheets)

This n8n workflow automates Amazon price tracking and competitor monitoring by scraping product pricing via Apify and updating your Google Sheet every day.

It removes manual price checks, keeps your pricing data always fresh, and helps Amazon sellers stay ahead in competitive pricing, Buy Box preparation, and daily audits.

💡 Use Cases Automatically track prices of your Amazon products
Monitor competitor seller prices across multiple URLs
Maintain a daily pricing database for reporting and insights
Catch sudden competitor undercutting or pricing changes
Support Buy Box analysis by comparing seller prices
Scale from 10 to 1000+ product URLs without manual effort

🧠 How It Works Scheduled Trigger** runs the workflow every morning
Google Sheets node** loads all product rows with seller URLs
Loop node** processes each item one-by-one
Apify Actor node** triggers the Amazon scraper
HTTP Request node** fetches the scraped result from Apify
JavaScript node** extracts, cleans, and formats price data
Update Sheet node** writes the fresh prices back to the right row
Supports additional price columns for more sellers or metrics

➕ Adding New Competitor Columns (Step-by-Step)

1. Add a new column in Google Sheets Add two new columns:

competitor_url_3 price_comp_3

2. Update the Apify Actor (inside n8n) In the Apify Actor node, pass the new competitor URL:

"competitor_url_3": {{$json.competitor_url_3}}

This ensures Apify scrapes the additional competitor product page.

3. Update your Code (JavaScript) node Inside the Code node, extract the new competitor’s price from the Apify JSON and attach it to the output:

const price_comp_3 = item?.offers?.[2]?.price || null; item.price_comp_3 = price_comp_3;

return item; (Adjust the index [2] based on the Apify output structure.)

Update the Google Sheet “Update Row” node To save the new values into your Sheet:

Open your Google Sheets Update Row node Scroll to Field Mapping Map Columns with New Data

Hit the "Save & Execute" Button.🚀

⚡ Requirements Apify account (free tier is enough) Apify "Amazon Product Scraper" API (Costs $40/month - 14-day free trial) Google Sheet containing product URLs
Basic credentials setup inside n8n

🙌 Want me to set it up for you? I’ll configure the full automation — Apify scraper, n8n workflow, Sheets mapping, and error handling.

Email me at: imarunavadas@gmail.com

Automate the boring work and focus on smarter selling. 🚀