jbutters

varun-raj / pullJSON.js

Last active October 31, 2022 16:19

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()); //