function getCollaborationLeads() {
  var apiKey = 'YOUR_API_KEY';
  var tag = 'collaboration_interested';
  var sheetName = "Collaborations";
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName(sheetName);

  if (!sheet) {
    sheet = ss.insertSheet(sheetName);
    sheet.getRange("A1").setValue("Last Synced:");
    sheet.getRange("B1").setValue("");
    sheet.appendRow(["First Name", "Social Media Handles", "Email", "Country", "Social Media Stats", "Content", "Ideas", "Created At"]);
  }

  var lastSync = sheet.getRange("B1").getValue();
  if (!lastSync) lastSync = new Date(0).toISOString();

  var endpoint = 'https://api.omnisend.com/v3/contacts?limit=100&tag=' + tag + '&createdAfter=' + encodeURIComponent(lastSync);
  var options = {
    method: 'get',
    headers: {
      'X-API-KEY': apiKey,
      'Content-Type': 'application/json'
    }
  };

  var response = UrlFetchApp.fetch(endpoint, options);
  var json = JSON.parse(response.getContentText());

  if (!json.contacts || json.contacts.length === 0) return;

  var existingData = sheet.getDataRange().getValues();
  var existingEmails = new Set();
  for (var i = 1; i < existingData.length; i++) {
    existingEmails.add(existingData[i][2]); // email column
  }

  var newSyncTime = lastSync;
  var emailRecipients = ['jenburch@hightailhair.com', 'jondazeley@hightailhair.com'];

  json.contacts.sort(function(a, b) {
    return new Date(a.createdAt) - new Date(b.createdAt);
  });

  json.contacts.forEach(function(contact) {
    if (existingEmails.has(contact.email)) return;

    var custom = contact.customProperties || {};

    sheet.appendRow([
      contact.firstName || "",
      custom.Social_Media_Handles || "",
      contact.email || "",
      contact.country || "",
      custom.Stats || "",
      custom.Content || "",
      custom.Ideas || "",
      contact.createdAt || ""
    ]);

    var emailBody =
      "New Collaboration Interest:\n\n" +
      "First Name: " + (contact.firstName || "") + "\n" +
      "Email: " + (contact.email || "") + "\n" +
      "Social Media Handles: " + (custom.Social_Media_Handles || "") + "\n" +
      "Country: " + (contact.country || "") + "\n" +
      "Social Media Stats: " + (custom.Stats || "") + "\n" +
      "Content: " + (custom.Content || "") + "\n" +
      "Ideas: " + (custom.Ideas || "") + "\n" +
      "Created At: " + (contact.createdAt || "");

    MailApp.sendEmail({
      to: emailRecipients.join(","),
      subject: "New Collaboration Form Submitted",
      body: emailBody
    });

    newSyncTime = contact.createdAt;
  });

  if (newSyncTime !== lastSync) {
    sheet.getRange("B1").setValue(newSyncTime);
  }
}