ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Link To DealWebsiteTitlePriceImage URL Extraction FormulaImage
2
https://www.banggood.com/Soloop-328pcs-21-Polyolefin-Halogen-Free-Heat-Shrink-Tube-Sleeving-5-Color-8-Size-p-969574.html?rmmds=flashdeals&cur_warehouse=CNbanggood#REF!#REF!#REF!#REF!
3
https://www.banggood.com/Xiaomi-Business-Card-Case-Automatic-Pop-Up-Metal-Credit-Card-Holder-Sliver-Card-Protector-p-1349018.html?rmmds=collection&utmid=6085&cur_warehouse=CNbanggood#REF!#REF!#REF!#REF!
4
https://www.amazon.com/TCL-40S325-Inch-1080p-Smart/dp/B07GB61TQR/ref=sr_1_2_sspa?s=tv&ie=UTF8&qid=1550241744&sr=1-2-spons&keywords=TV&psc=1amazon#REF!#REF!
5
https://www.aliexpress.com/item/33028030113.html?spm=a2g0o.productlist.0.0.408f3ab6f8975q&s=p&ad_pvid=202006171041099424263148054650023285678_1&algo_pvid=3127fe68-2b08-4116-94d9-d531333adb58&algo_expid=3127fe68-2b08-4116-94d9-d531333adb58-0&btsid=0ab6f82415924156697186435e0c31&ws_ab_test=searchweb0_0,searchweb201602_,searchweb201603_aliexpress#REF!#REF!#REF!
6
0//span[@itemprop='price']#REF!
7
https://www.aliexpress.com/item/32809415553.html?spm=a2g0s.8937420.0.0.53ab2e0ex20Laialiexpress#REF!#REF!
8
Formulas Used
9
10
Website
=REGEXEXTRACT(A2,"\.(.*?)\.")
Ok
11
12
Title
=IMPORTXML(A2,"//strong[@class='title_strong']")
Ok
13
14
Price
=IMPORTXML(A2,"//div[@class='item_now_price']")
Ok
15
16
Image URL
=IMPORTXML(A2,"//img[@class='dynamic-image']/@src")
Ok
17

18
Image=image(E3)Ok
19
20
21
22
23
24
25
26
#REF!
27
#REF!
28
//span[@class='old-price']
29
30
31
32
33
#ERROR!
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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