חיבור אתר ווקמרוס לגוגל שיטס

				
					
function onEdit(event) {
  var sheet = event.source; //get sheet
  var sheetname = sheet.getSheetName();//get sheet name
  if (sheetname != "בדיקה")//condition to match certain sheet comment out if not required
    return;
  var headings = sheet.getDataRange().offset(0, 0, 1).getValues()[0]; //get heading
  var edit_range = event.range; //get edited range
  var column_to_watch = 12; //A=1, B=2, C=3 etc...
  var row = edit_range.getRow();
  if (row == 1 || edit_range.getColumn() != column_to_watch || !edit_range.getValue())
    return;
  var values = sheet.getSheetValues(
    row, // starting row
    1, // starting column
    1, // number of rows
    16 // number of columns
  );
  var payload = {};
  for (i = 0; i < headings.length; i++) {
    var name = headings[i];
    var value = values[0][i];
    payload[name] = value;
  }
  payload["row_number"] = row;
  var options = {
    'method': 'post',
    'contentType': 'application/json',
    'payload': JSON.stringify(payload)
  };
  UrlFetchApp.fetch('https://hook.eu1.make.com/2eyehgxds', options);
  event.range.clearContent();
}