回答編集履歴
1
微修正
test
CHANGED
|
@@ -6,7 +6,7 @@
|
|
|
6
6
|
|
|
7
7
|
function test(){
|
|
8
8
|
|
|
9
|
-
var ss = SpreadsheetApp.getActive().getSheetByName('
|
|
9
|
+
var ss = SpreadsheetApp.getActive().getSheetByName('test');
|
|
10
10
|
|
|
11
11
|
var kw = ss.getRange("A1").getValue();
|
|
12
12
|
|
|
@@ -18,7 +18,7 @@
|
|
|
18
18
|
|
|
19
19
|
words.split('').forEach(function(w) {
|
|
20
20
|
|
|
21
|
-
var url = "http://www.google.com/complete/search?hl=ja&output=toolbar&q=" + kw + " "+ w
|
|
21
|
+
var url = "http://www.google.com/complete/search?hl=ja&output=toolbar&q=" + kw + " " + w + "//suggestion/@data";
|
|
22
22
|
|
|
23
23
|
var res = UrlFetchApp.fetch(url).getContentText();
|
|
24
24
|
|