IP Address Lookup Integration for IP2Location.io and Integrately

Integrately is a great way to build complex workflow tasks using integrations. With zero coding and no technical skills required, anyone can link multiple apps to perform tasks like perform analyses, generate reports and so on. Data can flow from one app to another seamlessly via automation. Create your automation, turn it on and that’s it.

IP2Location.io Integrately integration

IP2Location.io provides a fast and accurate IP Geolocation API tool to determine a user’s location and use the geolocation information in different use cases. By using the IP2Location.io Integrately integration, users can seamlessly retrieve IP geolocation data based on IP address stored on various services like Google Sheet.

IP2Location.io Integrately integration: https://integrately.com/integrations/ip2location-io

NOTE: An IP2Location.io API key is required. Sign up for a Free IP2Location.io API key if you don’t have one.

Demo: Integrating IP2Location.io and Google Sheet via Integrately

For our demonstration, we’ll show how to read IP addresses from Google Sheet and sending it to IP2Location.io to retrieve the IP geolocation. Then, we will store the results back into Google Sheet.

Step 1: Go to your Google Sheet and create a new blank spreadsheet called “Test Integrately”. Add another worksheet because we’ll need 2 sheets in that spreadsheet. In the first sheet, create a header called “IP” and add a row below it with “8.8.8.8”. This will be our test data.

Step 2: Go to the 2nd sheet and add headers for IP, country_code, country_name, region_name and city_name. We’ll use this sheet to store the IP geolocation results.

Step 3: Sign up for an Integrately account and login. You should see the page below. If you don’t see the Google Sheet app, search for it and click on it.

Step 4: You should see Google Sheet selected as the first app.

Step 5: Now search for IP2Location.io and click on it to add as the 2nd app.

Step 6: Search for Google Sheet again and click on it to add as the 3rd app.

Step 7: Select “Spreadsheet row is created in Google Sheets” for the “When” and “Get geolocation info from IP address in IP2Location.io” for the “Do”. Then, click “Go”.

Step 8: Sign in to your Google Sheet account and give the required permissions.

Step 9: You will see the below after signing in to your Google Sheet account. Choose “Test Integrately” as our spreadsheet and “Sheet1” as the worksheet.

Step 10: Set the IP2Location.io API key and click on “Continue”.

Step 11: If you are asked if you want to add more apps/conditions/branching, click on “Yes” and you’ll see the below:

Step 12: Click on the IP2Location.io and configure the IP address input field as coming from the Google Sheet. Then, click “Test It”.

Step 13: You’ll see the IP2Location.io test results for the IP address. Click on “Add Filter / Condition / App” below the IP2Location.io app.

Step 14: Search for Google Sheet and click on it. Then click on “Create spreadsheet row”.

Step 15: Select “Test Integrately” as the spreadsheet and “Sheet2” as the worksheet.

Step 16: Provide mapping for the IP2Location.io result fields to the columns in the Sheet2 for output. Click “Test It”.

Step 17: Go to Sheet2 and see the results.

Conclusion

That’s basically how you create an Integrately automation to read IP addresses from Google Sheet, query the IP geolocation from IP2Location.io and finally store the results back into Google Sheet. You’ll note that the IP geolocation results have a lot more fields than what we’re storing so you can modify your automation to keep whatever fields you desire.