回答編集履歴
1
少しスクリプトを修正しました。
answer
CHANGED
|
@@ -8,8 +8,8 @@
|
|
|
8
8
|
var word = [" a"," b"," C"];
|
|
9
9
|
var reqs = word.map(function(e) {return {url: "http://www.google.com/complete/search?hl=ja&output=toolbar&q=" + kw + e}});
|
|
10
10
|
var res = UrlFetchApp.fetchAll(reqs);
|
|
11
|
-
var values = res.reduce(function(ar, e, i) {return ar.concat(XmlService.parse(e.getContentText()).getRootElement().getChildren("CompleteSuggestion").map(function(f, j) {return [
|
|
12
|
-
ss.getRange(1,
|
|
11
|
+
var values = res.reduce(function(ar, e, i) {return ar.concat(XmlService.parse(e.getContentText()).getRootElement().getChildren("CompleteSuggestion").map(function(f, j) {return [f.getChild("suggestion").getAttribute("data").getValue()]}))}, []);
|
|
12
|
+
ss.getRange(1, 2, values.length, values[0].length).setValues(values);
|
|
13
13
|
}
|
|
14
14
|
```
|
|
15
15
|
|