A Google Sheet AppScript to sync the sheet with a Customer.io Collection

gsheet-appscript-collection-sync.js

//Customer.io Collections Sync w/ Automated Sync

function updateCollection() {
  var api_key = "[YOUR_APP_API_KEY]"; 
  var collection_id = "[THE_COLLECTION_ID]";
  var url = "https://beta-api.customer.io/v1/api/collections/" + collection_id;

  var data = {
    name: SpreadsheetApp.getActiveSheet().getName(),
    url: SpreadsheetApp.getActiveSpreadsheet().getUrl(),
  };
  var payload = JSON.stringify(data);

  var headers = {
    "Content-Type": "application/json",
    Authorization: "Bearer " + api_key,
  };

  var options = {
    method: "put",
    contentType: "application/json",
    headers: headers,
    payload: payload,
  };

  var response = UrlFetchApp.fetch(url, options);
  Logger.log(response.getContentText());
}

//add a menu item to the spreadsheet
function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu("Customer.io")
    .addItem("Sync Collection to Customer.io", "updateCollection")
    .addToUi();
}