Noon Search scraper

	B	C	D	E	F	G	H	I
1			Noon Search scraper
2			Extract products data from Noon Search Results pages 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	➌	Your Query		sun glasses
19
20		Set up Noon Store:		noon.com/uae-en
21
22		Number of search pages:		2
23
24	< Expand to unveil the calculation section
25
26		💡	IMPORTFROMWEB works by fetching data from one or several URLs. We generate a list of search URLs to feed the IMPORTFROMWEB function in C57
27
28		⚙️ URLs Generation
29		https://noon.com/uae-en/search/?q=sun%20glasses&page=1
30		https://noon.com/uae-en/search/?q=sun%20glasses&page=2
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47		💡	Data is still loading... If it takes more than 30 seconds or an error is displayed, consider toggling the "shake" option.
48
49		image	title	price	rating	reviews_count	featured_image_source	sku
50			#ERROR!
51
52
53
54
55
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