function chimpSubscribers() {
var API_KEY = 'VOSTRO MAILCHIMP USERID'; // MailChimp API Key
var LIST_ID = 'ID LISTA DA AGGIORNARE'; // MailChimp List ID
  
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("UpdateLista");
  
var dc = API_KEY.split('-')[1];
var api = 'https://'+ dc +'.api.mailchimp.com/3.0';
  
var memberList = '/lists/'+LIST_ID
	options = {"headers": {"authorization": 'apikey '+API_KEY}};
	var apiCall = function(endpoint){
		apiResponseMembers = UrlFetchApp.fetch(api+endpoint,options);
		json = JSON.parse(apiResponseMembers);
		return json
	}

var members = apiCall(memberList);
if (members) {
  var member_count = members.stats.member_count;
  var unsubscribe_count = members.stats.unsubscribe_count;
  var cleaned_count = members.stats.cleaned_count;
  var member_count_since_send = members.stats.member_count_since_send;
  var unsubscribe_count_since_send = members.stats.unsubscribe_count_since_send;
  var cleaned_count_since_send = members.stats.cleaned_count_since_send;
  var campaign_count = members.stats.campaign_count;
  var campaign_last_sent = members.stats.campaign_last_sent;
  var merge_field_count = members.stats.merge_field_count;
  var avg_sub_rate = members.stats.avg_sub_rate;
  var avg_unsub_rate = members.stats.avg_unsub_rate;
  var target_sub_rate = members.stats.target_sub_rate;
  var open_rate = members.stats.open_rate;
  var click_rate = members.stats.click_rate;
  var last_sub_date = members.stats.last_sub_date;
  var last_unsub_date = members.stats.last_unsub_date;
  var list_rating = members.list_rating;

  var report = [member_count, unsubscribe_count, cleaned_count, member_count_since_send, unsubscribe_count_since_send, cleaned_count_since_send, campaign_count, campaign_last_sent, merge_field_count, avg_sub_rate, avg_unsub_rate, target_sub_rate, open_rate, click_rate, last_sub_date, last_unsub_date, list_rating];
	  
Logger.log(report);
  
// Clear MailChimp data in Spreadsheet
   sheet.clear();
// Inserimento dati in GS
   sheet.appendRow(["Subscribers", "Unsubscribe Count", "Cleaned Count", "Member Count Since Send", "Unsubscribe Count Since Send", "Cleaned Count Since Send", "Campaign Count", "Campaign Last Sent", "Merge Var Count", "Average Subscription Rate", "Average Unsubscription Rate", "Average Target Subscription Rate", "Open Rate", "Click Rate", "Date of Last List Subscribe", "Date of Last List Unsubscribe", "List Rating"]);
   sheet.appendRow(report);
 }  
}