Scraping Amazon manually is inefficient, especially when you're trying to gather product data across multiple variations like color or model.
This workflow simplifies that process - just send a search term and get detailed product information and variants directly into Google Sheets.
What does this workflow do?
- Triggered via a webhook with a search query (e.g. "kitchen")
- Uses the Amazon Search API to retrieve a list of ASINs matching the search
- For each ASIN, calls the Amazon Product API to fetch detailed product data and all available variants
- Extracts and stores the following information:
- ASIN
- Product title
- Product URL
- Price & Currency
- Rating & Rating Count
- Main image
- All product images
- Features
- Stock availability
- Best Sellers Rank
- Date First Available
- Saves all collected data into a Google Sheet for further filtering and analysis
Perfect for product research, dropshipping, competitive monitoring, or building internal product databases.
