7g2dTMGW

1/**
2* Gets all FAQ serp features for a given keyword.
3* @param {"SEO Tips"} keyword input the keyword.
4* @customfunction
5*/
6
7function getSERPSFAQ(keyword) {
8  // enter API KEY from Scaleserp.com
9  var api_key = "CABBAD228E144878A69D0F46DE489820";
10  var keyword = keyword.split(/[ ,]+/).join('+');
11
12  var response = UrlFetchApp.fetch("https://api.scaleserp.com/search?api_key=" + api_key + "&q="+ keyword + "&google_domain=google.co.uk&gl=uk&hl=en&output=json");
13
14  var content = response.getContentText();
15  var json = JSON.parse(content);
16
17  // find out how many keys are in 'organic_results'
18  var organicLength = Object.keys(json.organic_results).length;
19
20  var columns = []; 
21
22  for (let i = 0; i < organicLength; i++) {
23    if(json.organic_results[i].hasOwnProperty(['faq'])) {
24      var loopfaq = json.organic_results[i].faq;
25        for (let i = 0 ; i < loopfaq.length; i++){
26          var faq_question = loopfaq[i].question;
27          var faq_answer = loopfaq[i].answer;
28          columns.push([faq_question, faq_answer]);
29        }
30     }
31  }
32  return columns; 
33}