Learn how to scrape Amazon Search using a simple formula on Google Sheets.
This tutorial shows you step-by-step how to collect Amazon products listings from any Amazon query.
No technical knowledge required!
▬ Useful Links ▬▬▬▬▬▬▬▬▬▬
To install the add-on: workspace.google.com/marketpl...
To access the Amazon Search scraper template:
docs.google.com/spreadsheets/...
▬ Contents of this video ▬▬▬▬▬▬▬▬▬▬
00:00 - What is ImportFromWeb and how to install it
01:02 - Open a new google sheets and activate ImportFromWeb
01:15 - the =IMPORTFROMWEB( ) function to scrape any Amazon Search page
04:20 - scrape multiple search pages
05:48 - a step ahead, scrape the Amazon product details
10:40 - the Amazon scraper template
▬ How does the Google Maps scraper work ? ▬▬▬▬▬▬▬▬▬▬
1. Install the ImportFromWeb add-on
2. Open a new Google Sheets and activate ImportFromWeb from the menu Extensions
3. Type in any query within the Amazon search bar
4. Take the URL you get (www.amazon.com/s?k=YOUR_QUERY)
4. Paste the URL in your google sheets
5. Write: =IMPORTFROMWEB("URL", "asin,title,price,rating")
6. And voilà!
23 июл 2024
