Sasha Gerrand sgerrand

👣

Manual controls

Professional aficionado. An Australian abroad.

sgerrand / import_sat_via_Zendesk_API.js

Created January 20, 2023 15:05 — forked from sbkinney/import_sat_via_Zendesk_API.js

This is a method for pulling Zendesk data from a view via the API into a Google Docs spreadsheet

	/* This function runs when the spreadsheet is opened and populates a menu option
	labelled Zendesk that contains two options (7 days and 30 days) which are tied
	to the listed functions
	*/

	function onOpen() {
	var sheet = SpreadsheetApp.getActiveSpreadsheet();
	var entries = [{
	name : "Pull Satisfaction Data (last 7 days, rolling)",
	functionName : "getSatisfactionDataLast7"