How to Connect ZeroBounce as Data Search

Integration with ZeroBounce is implemented as a separate Search block, which can be placed between the Source and Destination data. This will allow you to receive a string in the Data Source by a given value and pass data from the string to the Data Destination fields. Thus, through the search, you can automatically receive data from ZeroBounce and transfer them to the services and systems that you use.

The function allows you to search the ZeroBounce Item and update the data

Navigation:

Connecting Google Sheets as a Data Source:

1. What data can be obtained from Google Sheets?
2. How to connect your Google Sheets account to ApiX-Drive?
3. Selecting the table and sheet from which ZeroBounce will be exported.
4. An example of data that will be transferred from Google Sheets.

Connecting ZeroBounce as Data Search:

1. What data can be obtained from ZeroBounce ?
2. How to connect ZeroBounce account to ApiX-Drive?
3. How can I configure the search for data in ZeroBounce in the selected action?
4. An example of data that will be transferred from ZeroBounce.

Setting up row updates in Google Sheets:
1. What will the Google Sheets integration do?
2. How to connect your Google Sheets account to ApiX-Drive?
3. How to set up data transfer to Google Sheets in the selected action?
4. An example of the data that will be sent to your Google Sheets.
5. Auto-update and communication interval.

Setting Data SOURCE: Google Sheets

Let's take a look at how the Search function works, using the example of updating a Row in Google Sheets.

First, you need to create a new connection.

Select a system as the Data Source. In this case, you must specify Google Sheets.

Next, you need to specify the action "Get ROWS (all)".

The next step is to select the Google Sheets account from which the data will be uploaded.

If there are no logins connected to the system, click "Connect account".

Select which account you want to connect to ApiX-Drive and grant all permissions to work with this account.

When the connected account is displayed in the "active accounts" list, select it.

Attention! If your account is in the "inactive accounts" list, check your access to this login!

Select the Google Sheets table and sheet where the data you need is located.

At this step, you can add a data filter to load not all ZeroBounce, but only those for which data needs to be updated, for example:

1. Select a column from the table in which you have the data you are looking for.

2. Select the "Does not contain" action.

3. Write a value to filter by, for example "company.com".

With such a filter, you will not be unloading rows that already have this domen. Why spend additional actions to rewrite the same domain?

Now you can see the test data for one of the ZeroBounce in your Google Sheets.

If you want to update the test data - click "Load test data from Google Sheets".

If you want to change the settings - click "Edit" and you will go back one step.

Now we connect an additional Data Search block. To do this, click on the "+" and select "Add data SEARCH" from the list.

As the system in which the search will be performed, select "ZeroBounce".

Next, select the action, for example "EMAIL Validation".

The next step is choosing an ZeroBounce account.

If there are no logins connected to the ApiX-Drive system, click "Connect account".

Next, you need to enter the value, where:

API server - is the server through which your requests are routed and data is processed when working with the API. It is selected to comply with privacy and legal requirements, and to ensure that data is processed in the appropriate region.

- API DEFAULT - used by default; requests are processed on servers in the US, and using it constitutes consent to data processing in the US.

- API U.S.A. - a special regional endpoint; data is also processed in the US with your consent.

- API EU - a regional endpoint for Europe, designed for data processing within the EU, taking into account GDPR regulations and data residency.

API key - the key to connect to your personal account. The API key is located in your ZeroBounce profile settings.

Go to your ZeroBounce personal account in the API section, copy the API key and paste it into the appropriate field in ApiX-Drive.

When the connected account is displayed in the "active accounts" list, select it for further work.

In the Email field, you must specify the variable from the Data Source that will contain the search data. This variable is the variable with which the client email column in the Data Receiver will be compared. If a match is found, the row will be updated.

Now you see the test data for one of the Items. You can transfer this data to your receive table.

If the test data does not appear automatically, click "Search in ZeroBounce".

If something does not suit you - click "Edit", go back one step and change the settings for the search fields.

This completes the Data Search setup!

Now we can start setting up Google Sheets as a Data Destination system.

To do this, click "Add Data DESTINATION".

Setup Data Destination system: Google Sheets

Select the system as Data Destination. In this case, you must specify Google Sheets.

Next, you need to specify the action "Update ROW".

The next step is to select a Google Sheets account to which the status of ZeroBounce will be sent. If this is the same account, then select it.

If you need to connect another login to the system, click "Connect account" and repeat the same steps as described when connecting Google Sheets as a Data Source.

Now you need to select the File (Table) and Sheet in which the data of the ZeroBounce Item will be updated.

In the "Search column" field, you need to select the column by which the data will be searched. That is, where to look for data in the table.

Next, in the "Search" field, you need to select a variable from the drop-down list or enter the data manually, by which value the system will search for data to update the row you need. In our case, we select column "A," which contains the email data. The system will update the data in the desired row only if the email address matches.

You also need to specify the Search Type in case multiple lines with the same email are found:

"First found row" - searching and updating data will occur in the first found row that satisfies the search conditions.

"Last found row" - searching and updating data will occur in the last found row that satisfies the search conditions.

"All found rows" - search and update of data will be performed on all found rows that satisfy the search conditions.

Now you need to assign the domain variable, which we retrieve from the Data Search block, to the empty column. This column will subsequently be updated with data regarding the domain of the specified email address.

After setting, click "Continue".

Thus, the Data Search block takes the field in the Data Source in which you have the client's email address, checks it in ZeroBounce and passes the domain of the found contact to the Data Receiver field, for example, to column "F".

This completes the Data Destination system setup!
Now you can start choosing the update interval and enabling auto-update.
To do this, click "Enable update".  

On the main screen, click on the gear icon to select the required update interval or set up scheduled launch. To start the connection by time, select scheduled start and specify the desired time for the connection update to fire, or add several options at once when you need the connection to fire.

Attention! In order for the scheduled run to work at the specified time, the interval between the current time and the specified time must be more than 5 minutes. For example, you select the time 12:10 and the current time is 12:08 - in this case, the automatic update of the connection will occur at 12:10 the next day. If you select the time 12:20 and the current time is 12:13 - the auto-update of the connection will work today and then every day at 12:20.

To make the current connection transmit data only after another connection, check the box "Update connection only after start other connection" and specify the connection after which the current connection will be started.

To enable auto-update, switch the slider to the position as shown in the picture.

To force the connection, click on the arrow icon.

This completes the ZeroBounce Data Search setup!  See how easy it is!?

Now don't worry, ApiX-Drive will do everything on its own!