Daily Amazon Keyword Price Tracking with n8n, Scrapewise & Google Sheets

Track Amazon keyword prices every day—automatically log results to Google Sheets

This n8n workflow searches Amazon using your chosen keywords via Scrapewise, then saves each product’s price and metadata (ASIN, rating, reviews, link) into Google Sheets every day—creating a clean, dated price history for monitoring and decision-making.

What this workflow does

• Runs daily at 07:00 on a schedule.
• Loads your configured `keywords`, Amazon marketplace (e.g., de or com), and page count from the workflow configuration.
• Calls Scrapewise’s search_amazon tool to retrieve Amazon search results (or a background job ID for larger requests).
• If Scrapewise returns a running job ID, the workflow waits 30 seconds, then fetches completed data using Scrapewise’s get_results tool.
• Normalizes the response into one item per product and adds a checkedAt date field.
• Appends rows to Google Sheets to build a time series log with: Date, Title, ASIN, Price, Rating, Reviews, Link.

Use cases

• Monitor competitor pricing for specific Amazon keyword searches and identify price drops over time.
• Build an auditable price log for SaaS operators tracking market shifts by keyword and marketplace.
• Maintain historical data in Google Sheets for internal reviews, dashboards, or follow-up analyses.

Technical details

• Scrapewise integration using an HTTP Bearer Auth credential with Scrapewise calls.
• Google Sheets OAuth2 connection to append daily product rows to a specified spreadsheet tab.
• n8n nodes used: if, set, code, wait, sticky note, and google sheets.
• Supports scheduled execution and configurable wait duration for Scrapewise job completion.