function getKeywordSuggestions() {
var keyword = "car99"; // Yahan apna keyword set kar sakte hain
var url = "http://suggestqueries.google.com/complete/search?client=firefox&q=" + encodeURIComponent(keyword);
var response = UrlFetchApp.fetch(url);
var suggestions = JSON.parse(response.getContentText())[1];
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
sheet.clearContents();
sheet.appendRow(['Suggestions for: ' + keyword]);
sheet.appendRow(["Fetched on:", new Date()]);
suggestions.forEach(function(s) {
sheet.appendRow([s]);
});
}
0 Comments