How to Connect GeoIP as Data Search

Integration with GeoIP is implemented as a separate Search block, which can be placed between the Data Source and Data Destination. This will allow you, when receiving an order, for example, from your website or simply from GoogleSheets, by the client’s IP, to find out additional information about it (continent, country, city). This information, along with the order itself, can be transferred to your CRM. Why is this necessary? For example, this way you can create another integration of your CRM and Email or SMS service and, depending on the country and city, produce more accurate mailings to customers, which will undoubtedly increase the response rate.

The function allows you to get data by IP addresses via GeoIP for further work with them and update data.

Navigation:

Connecting GeoIP as Data Search:

1. What data can be get from GeoIP?
2. How to connect a GeoIP account to ApiX-Drive?
3. How to set up the search for data in GeoIP in the selected action?
4. An example of data that will be transmitted from GeoIP.

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 can I set up the selected action to transfer data to Google Sheets?
4. Example of data that will be sent to your Google Sheets.
5. Auto-update and update interval.

When you have created the "Data Source" block, add a new block such as "Data Search". To do this, click on the “+” under the Data Source block and select “DATA SEARCH” from the list.

Setting up GeoIP Data Search in Google Sheets | Start setting up Data Search

Select the system as the Data Search. In this case, you must specify GeoIP.

Setting up GeoIP Data Search in Google Sheets | System selection

Next, select the action “Get DATA by IP”.

Setting up GeoIP Data Search in Google Sheets | Action selection

There are no access settings for this system, so just click “Continue”.

Setting up GeoIP Data Search in Google Sheets | Access Settings

Now you need to select the variable in which you get the IP address.

Setting up GeoIP Data Search in Google Sheets | Assigning fields

Now you see test data by IP address. You can pass this data to your reception table.

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

If you are not satisfied with something, click Edit, go back a step and change the search field settings.

Setting up GeoIP Data Search in Google Sheets | Test data

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".

Setting up GeoIP Data Search in Google Sheets | GeoIP Test Data

Now you can start setting up the data destination system.

We choose a system where we will transfer all this data. Let's take Google Sheets for example. You can see how to connect the Google Sheets system in this https://apix-drive.com/en/help/how-to-connect-google-sheets-as-destination

Setting up 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 “Add ROW” action.

The next step is to select a Google Sheets account into which the data by IP address will be transferred. If this is the same account, then we select it.

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

Setting up GeoIP Data Search in Google Sheets | Account selection

At the Settings stage, you need to select the File (Table) and Sheet in which rows with IP address data will be added.

Next, you can specify the variables you need from the Data Search block. Also, you can specify text values in front of variables.

Now you can see the test data.

If you want to send test data to Google sheets to check the settings are correct, click "Submit test data to Google sheets" and go to your Sheet to check the result.

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

If you are satisfied with everything, click “Continue”.

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".

Setting up GeoIP Data Search in Google Sheets | Enable auto-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 be triggered, or add several options at once when you need the connection to be triggered.

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.

Setting up GeoIP Data Search in Google Sheets | Update interval

Setting up GeoIP Data Search in Google Sheets | Update priority

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 IP address data via GeoIP in the Data Search block! See how simple it is!?

Now you don’t have to worry, ApiX-Drive will do everything on its own!