Hi, i would like to return values from an apps script call from Appsheet, i dont know if this is actually posible.

Inside of drive folder, select a google sheet, to search a value with scan barcode-qr function, if not found give an alert of not found , else give a ok alert and update. (This is to generate reports of inventory checkin).Greetings from Chile.