noder5

noder5 / pullJSON.js

Created July 6, 2016 17:02 — forked from varun-raj/pullJSON.js

Google App Script To Fetch Data From JSON Webservice and Write them to google spreadsheet.

	function pullJSON() {
	var ss = SpreadsheetApp.getActiveSpreadsheet();
	var sheets = ss.getSheets();
	var sheet = ss.getActiveSheet();


	var url="http://example.com/feeds?type=json"; // Paste your JSON URL here

	var response = UrlFetchApp.fetch(url); // get feed
	var dataAll = JSON.parse(response.getContentText()); //