seo

seo.js

function myFunction() {
  
  var response = UrlFetchApp.fetch("https://www.google.co.jp/search?q=バッグ&num=100");
  var arr = [];
  var myRegexp = /<h3 class=\"r\">([\s\S]*?)<\/h3>/gi;
  var elems = response.getContentText().match(myRegexp);
  for(var i in elems) {
    var title = elems[i];
    
    var site = [];
    
    site[0] = parseInt(i)+1;
    
    title = title.replace(/(^\s+)|(\s+$)/gi, "");
    
    urlReg = /href="\/url\?q=(.*?)&amp;sa/;
    var url = title;
    url = url.match(urlReg);
    
    if(Array.isArray(url)) {
      site[2] = url[1];
    }else {
      site[2] = null
    }

    title = title.replace(/<\/?[^>]+>/gi, "");
    site[1] = title;
    arr.push(site);
  }
  
  Logger.log(arr);
  var sheet = SpreadsheetApp.getActiveSheet().getRange(1, 1, arr.length, arr[0].length );
  sheet.setValues(arr);
}