Google App Script Extracting Data From Website

So I am writing a script which look at review done on google+ pages and updates a google spreadsheet. I have found out that the line in the html which holds this value is

Solution 1:

Use

var response = UrlFetchApp.fetch("http://www.website.com/");

To fetch the html of the page. Then use something like

var cut = response.substring( str.indexOf( "<span class="A7a">" ), response.length);
varvalue = cut.substring(0, cut.indexOf("</span>"));

https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app#fetch(String)

Solution 2:

I agree with the previous answer but there are some omissions

var response = UrlFetchApp.fetch(url);
var str = response.getContentText();
var balise = '<span class="A7a">'var cut = str.substring(str.indexOf( balise ), response.length);
varvalue = cut.substring(balise.length, cut.indexOf("</span>"));

Share