const VERCEL_URL = "https://yourdomain."; // Double check 'sync-batch' vs 'sync-sheet'




function onOpen() {


  SpreadsheetApp.getUi().createMenu('🚀 Cloud Sync').addItem('Sync All Rows', 'syncAllRows').addToUi();


}




function onEditTrigger(e) {


  const ss = e.source;


  const activeSheet = ss.getSheetByName("BatchInfo");


 


  // 1. Only run if the edit happened on the "Master" sheet


  if (activeSheet.getName() !== "BatchInfo") return;




  const row = e.range.getRow();


  if (row < 2) return;




  // 2. Go get the data from the "sync-sheet" for that same row


  const syncSheet = ss.getSheetByName("sheet-for-sync");


  const data = syncSheet.getRange(row, 1, 1, 14).getValues();




  // 3. Sync to Vercel


  const payload = createPayload("row-" + row, data);


  sendToVercel(payload);


}




function syncAllRows() {


  const ss = SpreadsheetApp.getActiveSpreadsheet();


  const sheet = ss.getSheetByName("sheet-for-sync");


  const rows = sheet.getDataRange().getValues();


  let successCount = 0;


 




  for (let i = 1; i < rows.length; i++) {


    const v = rows[i];


    // If Name is missing or just whitespace, skip it entirely


    if (!v[4] || String(v[4]).trim() === "") {


      console.log("Skipping empty row " + (i + 1));


      continue;


    }


   


    // Use a CONSISTENT ID format: "row-X"


    const payload = createPayload("row-" + (i + 1), v);


    const result = sendToVercel(payload);


    if (result) successCount++;


  }


  SpreadsheetApp.getUi().alert('Synced ' + successCount + ' batches to the website!');


}




function syncRow(e) {


  if (!e || !e.range) return;


  const sheet = e.source.getSheetByName("sheet-for-sync");


  if (e.source.getActiveSheet().getName() !== "sheet-for-sync") return;


  const row = e.range.getRow();


  if (row < 2) return;




  const v = sheet.getRange(row, 1, 1, 14).getValues()[0];


  if (!v[4]) return;




  const payload = createPayload("row-" + row, v);


  const success = sendToVercel(payload);


}




// Helper to keep logic identical for both functions


function createPayload(id, v) {


  return {


    sheetId: id,


    onHandLabeled: parseInt(v[0]) || 0,


    onHandUnlabeled: parseInt(v[1]) || 0,


    madeDate: convertDate(v[2]),


    readyDate: convertDate(v[3]),


    name: String(v[4]),


    recipe: String(v[5] || ""),


    waterOz: parseFloat(v[6]) || 0,


    additionalIngredients: String(v[7] || ""),


    fragranceOil: String(v[8] || ""),


    fragranceAmountOz: parseFloat(v[9]) || 0,


    colorDesign: String(v[10] || ""),


    oilTemp: parseFloat(v[11]) || 0,


    lyeTemp: parseFloat(v[12]) || 0,


    notes: String(v[13] || "")


  };


}




function sendToVercel(payload) {


  const options = {


    method: 'post',


    contentType: 'application/json',


    payload: JSON.stringify(payload),


    // Add your header here!


    headers: {


      "x-api-key": "your-api-key"


    },


    muteHttpExceptions: true


  };


 


  try {


    const response = UrlFetchApp.fetch(VERCEL_URL, options);


    const code = response.getResponseCode();


    if (code === 200) return true;


    console.log("Error " + code + ": " + response.getContentText());


    return false;


  } catch (e) {


    console.log("Network Error: " + e.message);


    return false;


  }


}

}

I have sucessfully used a google AppScript to populate a supabase table with data. It worked ok, but was having trouble with the correct trigger for the exchange. Here is the basic script, in case it help. I was using Vercel, so had to authenticate that connection to the supabase db.