🚀 Amazon Storefront Extractor

	B	C	D	E	F	G	H	I	J
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 Storefront URL	https://www.amazon.com/s?me=A294P4X9EWVXLJ&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:	3
24
25	< Expand to unveil the calculation section
51
52
53				Check the IMPORTFROMWEB function
54		image	asin	title	price	rating	reviews_count	url	featured_image_source
55			Loading... Wait a few more moments
56
57
58
59
60
61
62
63
64
65
66
67
68
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