How to use MailboxValidator to validate email in Pipedream?


Pipedream is a minimal code integration platform for developers that allows users to connect to APIs remarkably fast. User are able to connect to any API and schedule their tasks. They can also easily integrate their data to other services. For example, user can import their list in Google Sheets to any ESP in Pipedream.

MailboxValidator is now available in Pipedream for integration. That means Pipedream user can easily validate email addresses by using the MailboxValidator API service. This article will show how to use the MailboxValidator API service in Pipedream. It will use Google Sheet as the source. Users can follow this step-by-step guide while using Pipedream.

Note: A MailboxValidator API key is required before using the service. If you do not have one, you can sign up for a free API key at

Steps to use the MailboxValidator API with Google Sheets in Pipedream

  1. First, login to your Pipedream account.
  2. Go to “Workflows”, and click on the “New +” button to create a new workflow.Screenshot of how to start to create a new workflow in Pipedream
  3. In the “Add a trigger” box, look for the “Google Sheets” option. Click on the option, and choose “New Row Added (Instant)” option. We will going to obtain a new email from the new row added.Screenshot of selecting Google Sheets as the source of email addressesScreenshot of select "New Row Added (Instant)" in the next step
  4. Choose an Google account from the dropdown menu. If you haven’t connected to the Google account before, click on the “Connect Google Sheets” to connect a Google account. Follow the steps in the pop-out screen to connect your account.Screenshot of choosing a Google Sheets account to connect on.
  5. Select your destination drive, and select the spreadsheet ID and worksheet ID from the dropdown menus. Click the “Create Source” button when you have done.Screenshot of setting the Spreadsheet and worksheet ID.
  6. In the same page, click the “+” button to add another step. Search “MailboxValidator” from the search box and click the “MailboxValidator” option. After that, click the “Use any MailboxValidator API” option.Screenshot of clicking the + button to add another step in the workflow.Screenshot of search and choose MailboxValidator.Screenshot of click the “Use any MailboxValidator API” option
  7. Click the “Connect MailboxValidator” option. In the pop-up dialog box, enter the API key you obtained from the MailboxValidator dashboard. Click “SAVE” button to keep the setting.Screenshot of entering MailboxValidator API key in the connection setting.
  8. In the editor box, you will see NodeJS code. Go to the line “email: `{enter_email_to_validate_here}`,”, and change to “email: `${steps.trigger.event.newRow[0]}`,”.
  9. If you want to keep the validation status back to the sheet, click the “+” button to add another step. Click on the “Google Sheets” option, scroll down until you found the “Update Row” option, and click on it.Screenshot of click the “Update Row” to keep the validation result in the same row without overwriting.
  10. Choose back the same Google account, the destination drive, the spreadsheet ID and worksheet ID from the dropdown menus. In the “Row Number” option, enter this “{{event.rowNumber}}” into the textbox. In the “Cells / Column Values” option, enter “{{event.newRow[0]}}” in the first text box. Then, click on the plus sign beside the first text box. After that, enter “{{steps.mailboxvalidator.$return_value.status}}” in the second text box.Screenshot of setting Spreadsheet and worksheet ID, row number and cell values
  11. After you have done all settings, remember to click the save button to save the settings and deploy button to deploy the workflow in real time.Screenshot of click save and deploy button to save and deploy the workflow
  12. You can now check your spreadsheet to see the result.Screenshot of the example output of the workflow


Pipedream has various applications that you can integrate with the MailboxValidator API service. You can reduce the hassle of manually uploading the list, as they provided the scheduling feature.

Was this article helpful?

Related Articles