回答編集履歴
1
微修正
answer
CHANGED
|
@@ -2,13 +2,13 @@
|
|
|
2
2
|
```GAS
|
|
3
3
|
//サジェスト取得
|
|
4
4
|
function test(){
|
|
5
|
-
var ss = SpreadsheetApp.getActive().getSheetByName('
|
|
5
|
+
var ss = SpreadsheetApp.getActive().getSheetByName('test');
|
|
6
6
|
var kw = ss.getRange("A1").getValue();
|
|
7
7
|
var words = "abcdefghijklmnopqrstuvwxyzあいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわをん";
|
|
8
8
|
|
|
9
9
|
var arr = [];
|
|
10
10
|
words.split('').forEach(function(w) {
|
|
11
|
-
var url = "http://www.google.com/complete/search?hl=ja&output=toolbar&q=" + kw + " "+ w
|
|
11
|
+
var url = "http://www.google.com/complete/search?hl=ja&output=toolbar&q=" + kw + " " + w + "//suggestion/@data";
|
|
12
12
|
var res = UrlFetchApp.fetch(url).getContentText();
|
|
13
13
|
var values = XmlService.parse(res).getRootElement().getChildren("CompleteSuggestion").map(function(e) {return [e.getChild("suggestion").getAttribute("data").getValue()]});
|
|
14
14
|
arr = arr.concat(values);
|