Now, we will create an application to search existing contacts. This application is able to search and list your Gmail Contacts in Sheets. Create a new Sheet and rename Sheet1 to Contacts and set it up as shown in the following screenshot. Create a button and assign the function name searchContacts to it, as you learned in the previous chapter.
Create the searchContacts function as listed here:
function searchContacts(){
var SheetContacts = SpreadsheetApp.getActiveSpreadsheet()
.getSheetByName("Contacts");
// Read input from cell A3
var searchCriteria = SheetContacts.getRange("A3").getValue();
// First 10 contacts.
// [You can change this limit, but advised to keep small.]
var numOfContacts = 10;
// Clear existing sheet data
SheetContacts.getRange(7,1,numOfContacts,4).clear();Here, clear is the Range object's method to clear everything including format and formula, in a range of cells. You can use the clear method of...