SMS sending and Clear Google Sheet data MIT Inventor

MIT App Inventor Help
1

I am trying to build an SMS sending App using Google Sheets and App script. What I want is to create the login for the App user, a CRUD for contact data and type in the message to be sent. The concept into Google sheet is of,
Login and validation
Message entry for the SMS
Contact Entry
and I want to clear a particular column data, which I am able to do using App Script,

function clearTheMessage() {
  var sheet = SpreadsheetApp.openByUrl(SHEET_URL).getSheetByName(SHEET_NAME);
  var data = sheet.getDataRange().getDisplayValues();
  var range = [];
      data.forEach(function(e, i){
    if (e[0] == "SMS Sent") range.push("E" + (i + 1));
  });
  sheet.getRange("E2:E").clearContent();
}

I have started with the SMS Sending with Google sheet, tried to combine the CRUD, got stuck.
In MIT Inventor I want help to create the blocks for the refresh button to execute the clearContent function.
And also update the name and number record.

2

Show how this function is connected to your web app script?

3

Kindly Look into the attachments and suggest the development. Thank you.
CRUD Immi SMS - CRUDIII.csv (104 Bytes) CRUD.txt (4.0 KB) CRUDImmiSMS.aia (14.8 KB)