Import from Google Sheets to Kommo

// 🚀 Initial setup function — run it once!
function setup() {
  var ui = SpreadsheetApp.getUi();
  
  // Ask the user for account_id
  var response = ui.prompt(
    '⚙️ Automatic import setup',
    'Enter your Account ID (in amoCRM: avatar top left → Your client number):',
    ui.ButtonSet.OK_CANCEL
  );
  
  if (response.getSelectedButton() !== ui.Button.OK) {
    ui.alert('❌ Setup cancelled');
    return;
  }
  
  var accountId = response.getResponseText().trim();
  if (!accountId) {
    ui.alert('❌ Account ID cannot be empty');
    return;
  }
  
  // Save account_id
  PropertiesService.getScriptProperties().setProperty('account_id', accountId);
  
  // Remove old triggers
  var triggers = ScriptApp.getProjectTriggers();
  for (var i = 0; i < triggers.length; i++) {
    if (triggers[i].getHandlerFunction() === 'onEdit') {
      ScriptApp.deleteTrigger(triggers[i]);
    }
  }
  
  // Create a new trigger
  ScriptApp.newTrigger('onEdit')
    .forSpreadsheet(SpreadsheetApp.getActive())
    .onEdit()
    .create();
  
  ui.alert(
    '✅ Setup complete!',
    'Account ID: ' + accountId + '\n\n' +
    'Now when the spreadsheet changes, data will be automatically imported into amoCRM within a minute.',
    ui.ButtonSet.OK
  );
}

// Returns spreadsheet timezone or UTC on error
function getSafeTimeZone() {
  try {
    var tz = SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetTimeZone();
    return (tz && tz.trim()) ? tz : 'UTC';
  } catch(e) {
    return 'UTC';
  }
}

// ⚙️ Get account_id from settings
function getAccountIdFromProperties() {
  return PropertiesService.getScriptProperties().getProperty('account_id');
}

// 🔄 Main function — runs automatically when the spreadsheet is edited
function onEdit(e) {
  var accountId = getAccountIdFromProperties();
  
  if (!accountId) {
    Logger.log("❌ Account ID is not configured. Run setup()");
    return;
  }
  
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var activeSheet = e.source.getActiveSheet();
  var sheetId = activeSheet.getSheetId();
  var baseUrl = spreadsheet.getUrl();
  var fullUrl = baseUrl + "?gid=" + sheetId + "#gid=" + sheetId;
  
  var url = "https://qp1-nova.ru/api/events/gimport_market/" + accountId;
  var payload = {
    url: fullUrl,
    timestamp: (function() {
      var tz = getSafeTimeZone();
      var date = new Date();
      return new Date(Utilities.formatDate(date, tz, "yyyy/MM/dd HH:mm:ss")).getTime();
    })(),
    sheet_name: activeSheet.getName(),
    spreadsheet_id: spreadsheet.getId()
  };
  
  var options = {
    method: "post",
    contentType: "application/json",
    payload: JSON.stringify(payload),
    muteHttpExceptions: true
  };
  
  try {
    UrlFetchApp.fetch(url, options);
    Logger.log("✅ Import started for sheet: " + activeSheet.getName());
  } catch (error) {
    Logger.log("❌ Send error: " + error.toString());
  }
}