Looks up a contact by email address.
class ContactsApp method .findByEmailAddress()
ContactsApp is the Apps Script service.
.findByEmailAddress() is the method name you will see after a dot in your code.
What it does
Why it's used
- Look up someone before updating or deduping.
- Match sheet rows to existing contacts by email.
Common errors
- Forgetting parentheses on findByEmailAddress. Write ContactsApp.findByEmailAddress(), not ContactsApp.findByEmailAddress or findByEmailAddress by itself.
- Skipping dots between chained calls. Each step needs a dot, like ContactsApp.findByEmailAddress().
- Adding spaces where they do not belong. Write ContactsApp.findByEmailAddress(), not ContactsApp .findByEmailAddress(), ContactsApp.findByEmailAddress (), or ContactsApp . findByEmailAddress().
- Wrong capitalization. Use ContactsApp and findByEmailAddress, not contactsapp or findbyemailaddress.
Explore
Related methods
-
.getContacts()
Returns contacts from the user's Google Contacts.
-
.getContactGroup()
Returns a contact group by its name or ID.
-
.createContact()
Adds a new person to Google Contacts.
More Apps Script
Better Sheets tutorials
No tagged tutorials yet. Fetch Apps Script from the harvest table and this page fills automatically.