n8n Apify Google Sheets E-commerce Automation

Automate Amazon Price Tracking & Competitor Monitoring

Free n8n workflow template that scrapes daily prices with Apify and logs data to Google Sheets—eliminate manual checks and stay competitive.

Download Template JSON · n8n compatible · Free
Visual diagram of Amazon price tracking automation workflow connecting Apify, n8n, and Google Sheets

What This Workflow Does

For Amazon sellers, staying competitive means constantly monitoring prices—both your own and your competitors'. Manual checking is tedious, error-prone, and doesn't scale. This automation solves that by running daily price checks automatically.

The workflow connects Apify's web scraping power with Google Sheets' flexibility. Each morning, it reads your product list from a Sheet, scrapes current prices and competitor offers via Apify, processes the data, and writes fresh pricing intelligence back to your spreadsheet. This creates a living pricing database that informs your strategy.

Beyond basic tracking, it helps you prepare for Buy Box competition, spot sudden price drops, and maintain historical price records—all without lifting a finger after setup.

How It Works

1. Scheduled Trigger

The workflow activates daily at your chosen time (typically early morning). This scheduled trigger ensures fresh data is waiting when your team starts work.

2. Load Product Data from Google Sheets

It reads your master product spreadsheet containing Amazon URLs, ASINs, and competitor links. Each row represents a product to monitor.

3. Loop Through Each Product

A loop node processes items one-by-one, ensuring reliable scraping even with hundreds of products. It handles errors gracefully without stopping the entire workflow.

4. Scrape with Apify Actor

For each product, an Apify actor visits the Amazon page, extracts current price, seller information, Buy Box status, and competitor offers. Apify handles proxies and anti-bot measures.

5. Process and Clean Data

A JavaScript node formats the raw scraped data: converting prices to numbers, extracting key metrics, and calculating price differences from your target.

6. Update Google Sheets

The cleaned data writes back to the same row in your spreadsheet, updating price columns and timestamps. Historical data is preserved for trend analysis.

Pro tip: Add conditional alerts by extending this workflow. When a competitor's price drops below your threshold, trigger an email or Slack notification immediately.

Who This Is For

This template is ideal for Amazon sellers, e-commerce managers, brand owners, and agencies managing multiple products. If you sell on Amazon and compete on price, this automation is essential.

It's particularly valuable for businesses with 10+ SKUs, those in competitive categories where prices change frequently, and teams spending hours weekly on manual price checks. Agencies can use it to provide pricing intelligence as a service to clients.

What You'll Need

  1. n8n instance (cloud or self-hosted) with basic credentials configured.
  2. Apify account with access to an Amazon scraper actor (free tier available).
  3. Google Sheet prepared with columns for product URLs and competitor links.
  4. Google Cloud Project with Sheets API enabled (one-time setup).
  5. Basic understanding of how to import and activate n8n workflows.

Quick Setup Guide

Get this automation running in under 30 minutes:

  1. Download the template using the button above and import it into your n8n instance.
  2. Prepare your Google Sheet with columns: Product Name, Your ASIN URL, Competitor 1 URL, Competitor 2 URL, etc.
  3. Configure credentials in n8n for Google Sheets and Apify (follow the in-app prompts).
  4. Test with one product by running the workflow manually to verify scraping works.
  5. Set the schedule to run daily at 6 AM (or your preferred time).
  6. Monitor the first few runs and adjust any field mappings if needed.

Pro tip: Start with 5-10 products to validate the setup before scaling to your entire catalog. This helps troubleshoot any issues with specific product pages or data formats.

Key Benefits

Save 10-20 hours per week previously spent manually checking prices across multiple products and competitors. That time can be redirected to strategy and growth.

Improve Buy Box win rate by 15-30% by responding to price changes within hours instead of days. The Buy Box algorithm rewards competitive, timely pricing.

Create a pricing intelligence database with historical data that reveals trends, seasonal patterns, and competitor pricing strategies over time.

Scale effortlessly from 10 to 1,000+ products without additional manual work. The automation handles the volume while maintaining accuracy.

Reduce human error in price recording and comparison. Automated data entry eliminates typos and missed updates that cost sales.

Frequently Asked Questions

Common questions about Amazon price tracking automation and integration

Automated price tracking is crucial because Amazon's Buy Box algorithm heavily favors competitive pricing. Manual checks are slow and inaccurate, leading to lost sales. Automation ensures you react within minutes to competitor price changes, protecting your margins and winning the Buy Box more often.

Without automation, sellers often discover they've been underpriced for days, resulting in significant revenue loss. Real-time monitoring allows for strategic repricing rather than panic reactions.

Apify provides reliable, scalable scraping without getting blocked. Manual scraping is slow, breaks often, and can't handle thousands of products. Apify actors run in the cloud, handle proxies and CAPTCHAs, and deliver structured data ready for analysis, saving dozens of hours per week.

Unlike simple scripts, Apify maintains scraping infrastructure, updates for website changes, and offers legal compliance—critical for business use. The data quality is consistently high, enabling confident business decisions.

Google Sheets becomes a live pricing dashboard. Automation populates it with daily price data, enabling trend analysis, historical comparisons, and data visualization. Teams can make informed repricing decisions, spot seasonal patterns, and share insights instantly without manual data entry.

Sheets integration allows non-technical team members to access pricing intelligence. You can build charts, set up conditional formatting for alerts, and connect to other tools like Data Studio for executive reporting.

Yes, the same automation principle works for eBay, Walmart, Etsy, and other marketplaces. You would adjust the Apify actor or scraping target, but the workflow structure—schedule, scrape, process, log to Sheets—remains identical. It's a flexible framework for any online price monitoring.

Many sellers use variations to track prices across multiple channels, giving a complete competitive view. This helps maintain consistent pricing strategy and identify where your products are most competitive.

Businesses typically see ROI within 1-2 months. Savings come from regained staff hours (10-20 hours/week), increased Buy Box win rate (15-30% boost), and preventing revenue loss from being underpriced. For a mid-sized seller, this can mean thousands in additional monthly profit.

The investment is minimal compared to hiring staff for manual tracking. Automation also provides consistency that human monitoring can't match, especially during holidays or peak seasons when prices change rapidly.

Use professional tools like Apify that rotate IP addresses, respect robots.txt, and mimic human browsing patterns. Avoid simple HTTP requests that get blocked. Schedule scraping at reasonable intervals, not continuously. Proper tools handle these complexities so you get data without risk.

Ethical scraping practices are important: only collect publicly available data, don't overwhelm servers, and use data responsibly. Professional services ensure compliance while delivering the intelligence you need.

Yes, GrowwStacks specializes in custom e-commerce automation. We can build a tailored system that tracks your specific products, competitors, and marketplaces, integrates with your inventory management, and triggers automatic repricing. We handle the technical setup so you focus on strategy.

Custom solutions might include multi-marketplace tracking, integration with repricing tools, alert systems for price thresholds, and dashboards tailored to your team's workflow. We start with a free consultation to understand your specific needs.

  • Tailored to your product catalog and competitors
  • Integration with your existing tools and workflows
  • Ongoing support and optimization as your business grows

Need a Custom Amazon Price Tracking Automation?

This free template is a starting point. Our team builds fully tailored automation systems for your specific business needs.

Get Free Consultation → Browse More Workflows