gsheets-api-example.js

gsheets-api-example.js

gapi.client.sheets.spreadsheets.values.get({
	spreadsheetId: '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms',
	range: 'Class Data!A2:E',
}).then(function(response) {
	var range = response.result;
	for (i = 0; i < range.values.length; i++) {
		var row = range.values[i];
		var colA = row[0];
		var colB = row[1];
		var combined = colA + colB;
		console.log(combined)
	}
});