Update Google Sheets with form responses from Google Forms for valid emails and send a Slack message

First, we need to connect Google Forms, ZeroBounce, Google Sheets and Slack to Make.com.

• 

  Create Make.com account.

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

• 

  Connect Google Forms to Make.com.

  Give Make.com access to your Google Forms account, using Google Forms credentials.

• 

  Connect ZeroBounce to Make.com.

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

• 

  Connect Google Sheets to Make.com.

  Give Make.com access to your Google Sheets account, using Google Sheets credentials.

• 

  Connect Slack to Make.com.

  Give Make.com access to your Slack account, using Slack 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 Google Forms

  Choose the following trigger: Watch Responses in Google Sheets (Watches for new responses in the Google Sheets table.).

• 

  Then set up an Action for ZeroBounce

  Choose this action: Validate Emails (Validates an email. The API requires that you have an active credit balance and will never consume a credit for any unknown result.).

• 

  Then set up another Action for Google Sheets

  Choose this action: Add a Row (Appends a new row to the bottom of the table.).

• 

  Then set up another Action for Slack

  Choose this action: Create a Message (Creates a message.).

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

• 

  Customize data flow

  Configure the data that is exchanged between Google Forms, ZeroBounce, Google Sheets and Slack.

• 

  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 Update Google Sheets with form responses from Google Forms for valid emails and send a Slack message!