I have a AppSheet to control somethings and send me some notificatios during the day, but I need to recive a notification on my cellphone that is trigged by a AppScript, so I tried to use the AppSheet.

I tryed to just append a row in the spreadsheet of my AppSheet, like this

function notificationAppSheet(number){
  const ss = SpreadsheetApp.openById("")  //the id of the SpreadSheet
  const sheet = ss.getSheetByName("test")

  const lr = sheet.getLastRow() + 1
  sheet.insertRowBefore(lr)

  var today = new Date()
  var tomorow = new Date(today)
  tomorow.setDate(tomorow.getDate() +1) 

  sheet.getRange(lr,1).setValue("New order " + number)
  sheet.getRange(lr,2).setValue("logos/flexlogo.jfif")
  sheet.getRange(lr,3).setValue(today)
  sheet.getRange(lr,4).setValue("test@gmail.com")
  sheet.getRange(lr,5).setValue(tomorow)
  sheet.getRange(lr,6).setValue(true)
 }

That worked to add a announcement on my app, but it don't send me a notification, despite I have a bot that send me a notification every time that a new announcement is create.

I don't need to use the AppSheet necessarily, but it's more easy than code a new app in Android I guess. Someone knows how can I send this notification with AppScript?