Verify email addresses stored in Microsoft 365 Excel worksheet in Hunter

First, we need to connect Microsoft Excel and Hunter to Make.com.

• 

  Create Make.com account.

  Create Make.com account if you don't have one.

• 

  Connect Microsoft Excel to Make.com.

  Give Make.com access to your Microsoft Excel account, using Microsoft Excel credentials.

• 

  Connect Hunter to Make.com.

  Give Make.com access to your Hunter account, using Hunter credentials.

Next, we need to create a workflow automation scenario using graphical no-code web interface of Make.com.

• 

  Set up a Trigger action for Microsoft Excel

  Choose the following trigger: Watch Worksheet Rows (Triggers when a new row is added to a worksheet.).

• 

  Then set up an Action for Hunter

  Choose this action: Verify an Email (Verifies the deliverability of an email address.).

• 

  Then set up another Action for Microsoft Excel

  Choose this action: Update a Worksheet Row (Updates an existing worksheet row.).

Finally, we need to test this automation and publish it.

• 

  Customize data flow

  Configure the data that is exchanged between Microsoft Excel and Hunter.

• 

  Test the workflow and turn it on for production use

  Test your scenario and publish to production. Now you have an automatic workflow, that will Verify email addresses stored in Microsoft 365 Excel worksheet in Hunter!