Everytime a new email is received in Gmail, Integromat will automatically validate the email address using MailboxValidator. If the email address is verified, it will look that peron up using Clearbit. If a result is returned it will add that person to a specific Google Sheet based on the validation result of that email address . If no result is returned from Clearbit an error will occur which will be handled by an error handler. This example uses the sheet in this link.
This is a predefined template that will make the creation of your scenario much easier. Of course, you can always expand and customize the scenario to meet your own individual needs.