-
Notifications
You must be signed in to change notification settings - Fork 0
/
scrape-100-search-results-urls.txt
111 lines (107 loc) · 9.12 KB
/
scrape-100-search-results-urls.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
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
101
102
103
104
105
106
107
108
109
110
111
Mit der URL wie https://www.google.de/search?q=test funktioniert die Abfrage nicht - Google lässt so nur 10 Ergebnisse scrapen. Um alle 100 zu bekommen immer erst die aktuelle URL der Google-Ergebnisseite kopieren und einsetzen. Sie sieht in etwa so aus:
https://www.google.de/search?num=100&safe=off&q=test&oq=test&gs_l=serp.12..0i71l8.0.0.0.895108.0.0.0.0.0.0.0.0..0.0....0...1c..64.serp..0.0.0.pR5I2rYNGEs
Sollte es als Formel funktionieren und die Keywords aus einer Spalte einlesen, dann
1. die aktuelle URL der Google-Ergebnisseite nehmen
2. Keyword liegt in der Zelle A2 → wie im folgenden Beispiel editieren:
=XPathOnUrl("https://www.google.de/search?num=100&safe=off&q="&A$2&"&oq="&A$2&"&gs_l=serp.12..0i71l8.0.0.0.895108.0.0.0.0.0.0.0.0..0.0....0...1c..64.serp..0.0.0.pR5I2rYNGEs"; "//*[@id='rso']/div[2]/li[1]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[1]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[2]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[3]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[4]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[5]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[6]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[7]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[8]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[9]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[10]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[11]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[12]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[13]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[14]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[15]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[16]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[17]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[18]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[19]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[20]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[21]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[22]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[23]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[24]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[25]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[26]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[27]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[28]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[29]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[30]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[31]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[32]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[33]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[34]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[35]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[36]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[37]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[38]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[39]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[40]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[41]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[42]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[43]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[44]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[45]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[46]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[47]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[48]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[49]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[50]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[51]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[52]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[53]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[54]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[55]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[56]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[57]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[58]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[59]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[60]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[61]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[62]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[63]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[64]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[65]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[66]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[67]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[68]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[69]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[70]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[71]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[72]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[73]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[74]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[75]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[76]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[77]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[78]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[79]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[80]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[81]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[82]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[83]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[84]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[85]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[86]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[87]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[88]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[89]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[90]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[91]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[92]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[93]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[94]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[95]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[96]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[97]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[98]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[99]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[100]/div/h3/a"; "href")
=XPathOnUrl("HIER_URL_EINSETZEN"; "//*[@id='rso']/div[2]/li[101]/div/h3/a"; "href")