A | B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Amazon Storefront extractor | |||||||||||
2 | Extract the entire catalog of any Amazon sellers in Google Sheets. | |||||||||||
3 | ||||||||||||
4 | ||||||||||||
5 | β | Install ImportFromWeb | INSTALL | |||||||||
6 | ||||||||||||
7 | β | Copy this spreadsheet and activate ImportFromWeb | MAKE A COPY | |||||||||
8 | ||||||||||||
9 | < Expand to learn more | |||||||||||
17 | ||||||||||||
18 | β | Set up | ||||||||||
19 | ||||||||||||
20 | Competitor Catalog URL | https://www.amazon.com/s?me=A1M34UMDNRJ691&marketplaceID=ATVPDKIKX0DER | To retrieve the URL: 1. click on the seller name below the buybox 2. then, click on the catalog store URL 3. copy the URL | |||||||||
21 | ||||||||||||
22 | ||||||||||||
23 | β Number of pages: | 2 | ||||||||||
24 | ||||||||||||
25 | < Expand to unveil the calculation section | |||||||||||
51 | ||||||||||||
52 | π‘ | β ImportFromWeb has fetched your data | ||||||||||
53 | ||||||||||||
54 | Check the IMPORTFROMWEB function | |||||||||||
55 | image | asin | title | price | rating | reviews_count | url | featured_image_source | ||||
56 | B0BZ4HM5JD | SGIN Wired USB Computer Mouse, Right or Left Hand Use, Silent USB Computer Mouse with Smooth Precise Scrolling, 1000 DPI for Computer, Laptop, PC, Black | 13.99 | 3.5 | 2 | https://www.amazon.com/s?me=A1M34UMDNRJ691&marketplaceID=ATVPDKIKX0DER&page=1 | https://m.media-amazon.com/images/I/6196UTc3XSL._AC_UY218_.jpg | |||||
57 | B0BZ4JV9H6 | SGIN Computer Mouse, Right or Left Hand Use, Silent USB Computer Mouse with Smooth Precise Scrolling, 1000 DPI for Computer, Laptop, PC, Black | 13.99 | 5 | 3 | https://www.amazon.com/s?me=A1M34UMDNRJ691&marketplaceID=ATVPDKIKX0DER&page=1 | https://m.media-amazon.com/images/I/617XP+iWahL._AC_UY218_.jpg | |||||
58 | B0CVGQDL7S | SGIN 10 Inch Tablets, Android 13 Tablet with 4GB RAM 128GB ROM, Octa-Core (2.0Ghz) with 1280 * 800 IPS Screen, 2MP+8MP Camera, 6000mAh, WiFi, Bluetooth 5.0(Black) | 159.99 | 3.8 | 4 | https://www.amazon.com/s?me=A1M34UMDNRJ691&marketplaceID=ATVPDKIKX0DER&page=1 | https://m.media-amazon.com/images/I/71nmFl9WolL._AC_UY218_.jpg | |||||
59 | B0CTM6NFW6 | SGIN Laptops, 15.6 Inch Laptop, 12GB DDR4 512GB SSD Laptops Computer with Intel Celeron N5095 Processor(Up to 2.9GHz), FHD 1920x1080 IPS Display, Bluetooth 4.2, Webcam, WiFi | 259.99 | 5 | 1 | https://www.amazon.com/s?me=A1M34UMDNRJ691&marketplaceID=ATVPDKIKX0DER&page=1 | https://m.media-amazon.com/images/I/71570gBFTFL._AC_UY218_.jpg | |||||
60 | B0CB67F1DS | SGIN Laptop, 15.6 Inch Windows 11 Laptops with 24GB DDR4 1024GB SSD Laptops Computer, Intel Celeron N5095 Processor(Up to 2.9GHz), FHD 1920x1080, Mini HDMI, Webcam, USB 3.0, 2.4/5.0G WiFi, Type-C | 3.3 | 7 | https://www.amazon.com/s?me=A1M34UMDNRJ691&marketplaceID=ATVPDKIKX0DER&page=1 | https://m.media-amazon.com/images/I/71TWKtKuvvL._AC_UY218_.jpg | ||||||
61 | B0CDGW26CY | SGIN USB Type C to USB Hub, USB C to USB Hub, 5V/3A USB-C 4 Ports Adapter, USB C Splitter for PC, Laptop, MacBook, Chromebook and More USB Type C Devices | 9.99 | 5 | 8 | https://www.amazon.com/s?me=A1M34UMDNRJ691&marketplaceID=ATVPDKIKX0DER&page=1 | https://m.media-amazon.com/images/I/51T+aJLB2VL._AC_UY218_.jpg | |||||
62 | B0BZP6CZBX | SGIN USB C Hub, 4 Port USB 3.0 Hub, USB C to USB Splitter, 5V/3A, USB Splitter for Laptop, MacBook, Chromebook, PC, Flash Drive | 5.98 | 4.7 | 2 | https://www.amazon.com/s?me=A1M34UMDNRJ691&marketplaceID=ATVPDKIKX0DER&page=1 | https://m.media-amazon.com/images/I/51ngg1E6HDL._AC_UY218_.jpg | |||||
63 | B0CB5D7G3D | SGIN Laptop 15.6 inch Intel Celeron N5095 Processor(Up to 2.9GHz), 15.6" FHD 1920x1080 Display, 12GB DDR4 512GB SSD, WiFi, Bluetooth 4.2, HDMI, USB 3.0 | 269.99 | 2.8 | 9 | https://www.amazon.com/s?me=A1M34UMDNRJ691&marketplaceID=ATVPDKIKX0DER&page=1 | https://m.media-amazon.com/images/I/71sEegi0KmL._AC_UY218_.jpg | |||||
64 | B0BZP6CW5J | SGIN USB C Hub, 5V/3A USB C Splitter, USB C to USB Adapter, USB Type C Hub for Laptop, PC, Chromebook, MacBook and More USB Type C Devices | 5.98 | https://www.amazon.com/s?me=A1M34UMDNRJ691&marketplaceID=ATVPDKIKX0DER&page=1 | https://m.media-amazon.com/images/I/51ASbJVDttL._AC_UY218_.jpg | |||||||
65 | B0CDGW24ZG | SGIN USB Type C Hub, USB C to USB Multiport Adapter, USB C Hub, 5V/3A USB 3.0 Splitter for Laptop, PC, Chromebook, MacBook and More USB Type C Devices | 9.99 | 5 | 10 | https://www.amazon.com/s?me=A1M34UMDNRJ691&marketplaceID=ATVPDKIKX0DER&page=1 | https://m.media-amazon.com/images/I/51-40P7VeKL._AC_UY218_.jpg | |||||
66 | B0CVH4MZGP | SGIN 10 Inch Tablets, 4GB RAM 128GB ROM Android 13 Tablet, Octa-Core (2.0Ghz) with 1280 * 800 IPS Screen, 2MP+8MP Camera, 6000mAh, WiFi, Bluetooth 5.0(Black) | 199.99 | https://www.amazon.com/s?me=A1M34UMDNRJ691&marketplaceID=ATVPDKIKX0DER&page=1 | https://m.media-amazon.com/images/I/61ErIu0j+lL._AC_UY218_.jpg | |||||||
67 | B0CDGVMXZT | SGIN USB 3.0 Hub, 4 in 1 USB C Splitter, 5V/3A USB-C Hub, USB Type C Hub Multiport Adapter for PC, Laptop, MacBook, Chromebook and More Devices | 9.99 | 5 | 9 | https://www.amazon.com/s?me=A1M34UMDNRJ691&marketplaceID=ATVPDKIKX0DER&page=1 | https://m.media-amazon.com/images/I/61FnRp0M36L._AC_UY218_.jpg | |||||
68 | -- | https://www.amazon.com/s?me=A1M34UMDNRJ691&marketplaceID=ATVPDKIKX0DER&page=2 | ||||||||||
69 | ||||||||||||
70 | ||||||||||||
71 | ||||||||||||
72 | ||||||||||||
73 | ||||||||||||
74 | ||||||||||||
75 | ||||||||||||
76 | ||||||||||||
77 | ||||||||||||
78 | ||||||||||||
79 | ||||||||||||
80 | ||||||||||||
81 | ||||||||||||
82 | ||||||||||||
83 | ||||||||||||
84 | ||||||||||||
85 | ||||||||||||
86 | ||||||||||||
87 | ||||||||||||
88 | ||||||||||||
89 | ||||||||||||
90 | ||||||||||||
91 | ||||||||||||
92 | ||||||||||||
93 | ||||||||||||
94 | ||||||||||||
95 | ||||||||||||
96 | ||||||||||||
97 | ||||||||||||
98 | ||||||||||||
99 | ||||||||||||
100 | ||||||||||||
101 | ||||||||||||
102 | ||||||||||||
103 | ||||||||||||
104 | ||||||||||||
105 | ||||||||||||
106 | ||||||||||||
107 | ||||||||||||
108 | ||||||||||||
109 | ||||||||||||
110 | ||||||||||||
111 | ||||||||||||
112 | ||||||||||||
113 | ||||||||||||
114 | ||||||||||||
115 | ||||||||||||
116 | ||||||||||||
117 | ||||||||||||
118 | ||||||||||||
119 | ||||||||||||
120 | ||||||||||||
121 | ||||||||||||
122 | ||||||||||||
123 | ||||||||||||
124 | ||||||||||||
125 | ||||||||||||
126 | ||||||||||||
127 | ||||||||||||
128 | ||||||||||||
129 | ||||||||||||
130 | ||||||||||||
131 | ||||||||||||
132 |