moayadhani

//This code is developed by Moayad Hani Yacoub Abu Rmilah and can be used freely for whatever purpose

/*This example shows how to:
1- create customized menu on Google Sheet using Google Script
2- Check if a sheet exists using sheet name
3- Get user entry by using UI dialog
4- Add a cell to an existing named range
5- Change text to camel case using regex expressions
6- Showing messages to the user */

moayadhani

var ui = SpreadsheetApp.getUi();
function onOpen(e){
  
  ui.createMenu("Gmail Manager").addItem("Get Emails by Label", "getGmailEmails").addToUi();
  
}

function getGmailEmails(){
  var input = ui.prompt('Label Name', 'Enter the label name that is assigned to your emails:', Browser.Buttons.OK_CANCEL);
  

moayadhani

//Sample email that is received and whose details are extracted:
/*
*Someone* just submitted your form named Online Course Booking from your
website
https://www.abcd.com/
Message Details
Full Name: Mohamed Ali
Email Address: [email protected]
Phone Number: 009725991122334