I am attempting to create a google doc for our Printing/Mail vendor to easy grab info on the members that renwed or signed up in the last 30 days. The idea is the vendor would just open this share google doc once a month, run the report, export the data.

I am using your example from: https://github.com/WildApricot/ApiSamples/tree/master/GoogleScript

function getCardData(){
Logger.clear();

var ui = SpreadsheetApp.getUi();

var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var urls = urlBuilder();

var token = getToken(ui, urls.getAuthServiceUrl());
var accountId = getDataFromApi(urls.getAccountsListUrl(), token)[0].Id;
var filter = '\'Renewal date last changed\' ge 2017-10-01 AND \'Mebership Status\' eq Active'
var query = getDataFromApi(urls.getCardDataUrl(accountId, filter), token)[0];
Logger.log(query);
var resultID = query.Resultid
Logger.log(resultID);

sheet.getRange('A2').setValue(contacts.FirstName);
sheet.getRange('B2').setValue(contacts.LastName);
sheet.getRange('C2').setValue(contacts.Address);
sheet.getRange('D2').setValue(contacts.City);
sheet.getRange('E2').setValue(contacts.State);
sheet.getRange('F2').setValue(contacts.Zip);
sheet.getRange('G2').setValue(contacts.RenewalDate);
sheet.getRange('H2').setValue(contacts.ExpireDate);

}

Having a hard time getting it to work. Any help would be apprciated.