Find work emails across your contact list

The scenario takes a list from a sheet, finds a work email for each and writes it back, and for the ones it couldn't find it sends an alert to your messenger.

  • A work email for each contact
  • What's found — straight into the sheet
  • An alert for the ones not found
  • The list fills up on its own
Google Sheets