IP2Location Integrations

  • Capture IP data from a new PostgreSQL row (via IP2Location) and add it to a different table

    If you're storing IPs in a PostgreSQL table, this integration can scan them for geolocation data and record the results on another. Once active, it will respond to every new row you add on PostgreSQL, automatically sending the IP information to IP2Location and storing the results on a different PostgreSQL table.

    Note: Record the resulting IP location data in a different table from the one that triggers this Zap so you don't cause a loop.

    How this PostgreSQL-IP2Location-PostgreSQL integration works

    1. A new row is added to a PostgreSQL table
    2. Zapier sends an IP from it to IP2Location for geolocation query
    3. Zapier adds the results to another PostgreSQL table row

    Apps involved

    • PostgreSQL
    • IP2Location
  • Capture IP data from a new MongoDB document (via IP2Location) and store it in another document

    Need to know more about the IPs you're logging? Set up this automation, and Zapier will do the digging for you. It will trigger with every new document you add to MongoDB, sending the IP information to IP2Location for processing. The results will then automatically be logged in a new MongoDB document, saving you the trouble of looking them up yourself.

    Note: Record the resulting IP location data in a different document from the one that triggers this Zap so you don't cause a loop.

    How this MongoDB-IP2Location-MongoDB integration works

    1. A new document is added to MongoDB
    2. Zapier sends an IP from it to IP2Location for geolocation query.
    3. Zapier adds the results to another MongoDB collection.

    Apps involved

    • MongoDB
    • IP2Location
  • Capture IP data from a new SQL Server row (via IP2Location) and add it to a different table

    Zapier lets you easily query geolocation data from a database so you don't have to search for it yourself. This automation will trigger with every new row you add to a SQL Server table, automatically looking up IP information via IP2Location and copying the results to a new row on SQL Server.

    Note: Record the resulting IP location data in a different table from the one that triggers this Zap so you don't cause a loop.

    How this SQL Server-IP2Location-SQL Server integration works

    1. A new row is added to a SQL Server table
    2. Zapier sends an IP from it to IP2Location for geolocation query
    3. Zapier adds the results to another SQL Server table row

    Apps involved

    • SQL Server
    • IP2Location
  • Query IP2Location for IPs stored in new MySQL and add geolocation data to a new table row

    Tired of searching for that IP information yourself? Set up this integration, and we'll do it for you. From then on, whenever you add a new row to a specific MySQL table, Zapier will pass the data along to IP2Location, adding the returned response to a new row on a different MySQL table.

    Note: Record the resulting IP location data in a different table from the one that triggers this Zap so you don't cause a loop.

    How this MySQL-IP2Location-MySQL integration works

    1. A new row is added to a MySQL table
    2. Zapier sends an IP from it to IP2Location for geolocation query
    3. Zapier adds the results to another MySQL table row

    Apps involved

    • MySQL
    • IP2Location
  • Look up IP addresses from one Amazon SQS message using IP2Location and add the results to a different queue

    You never have to look up IP data manually again. Set up this automation, queue up messages on Amazon SQS, and we'll do the rest. Whenever we detect a new message, the IP information will be passed through IP2Location, and Zapier will then log the resulting geolocation data in a message on another queue.

    How this Amazon SQS-IP2Location-Amazon SQS integration works

    1. A new message is added to an Amazon SQS queue
    2. Zapier sends an IP from it to IP2Location for geolocation query
    3. Zapier adds the results to another message in an Amazon SQS queue

    Apps involved

    • Amazon SQS
    • IP2Location
  • Get IP2Location data for IP addresses from new AWS DynamoDB items and store them in another table

    If you've got IP addresses stored on Amazon Web Services DynamoDB, Zapier can do the work of looking up their geolocation data. After this automation is active, it will trigger for every new item you add to your table, looking up IP information via IP2Location and feeding the results back into another table in response.

    How this AWS DynamoDB-IP2Location-AWS DynamoDB integration works

    1. A new item is added to a AWS DynamoDB table
    2. Zapier sends an IP from it to IP2Location for geolocation query
    3. Zapier adds the results to another AWS DynamoDB table row

    Apps involved

    • AWS DynamoDB
    • IP2Location
  • Update new Airtable records with geolocation (via IP2Location)

    If you're capturing IP location on Airtable, Zapier gives you an easy way to access more details without any manual entry. Once you've added a new row to Airtable with your customer details—including their IP address—into Airtable, Zapier will send them to IP2Location so geolocation data can be found for them, and automatically update the record with this additional info so you can access it as needed.

    How this Airtable-IP2Location-Airtable integration works

    1. A new customer record is inserted into Airtable
    2. Zapier sends the IP for that customer record to IP2Location for geolocation query
    3. Zapier then updates the customer location field in that Airtable record

    Apps involved

    • Airtable
    • IP2Location
  • Look up IPs from one Google Sheet (via IP2Location) and store them on another worksheet

    You won't ever have to check IP location data manually again. After you set up this automation, it will trigger with every new row you add on Google Sheets, send the IP stored in a cell to IP2Location, and then add the resulting information to a new row and worksheet on Google Sheets.

    Note: Record the resulting IP location data in a different worksheet from the one that triggers this Zap so you don't cause a loop.

    How this Google Sheets-IP2Location-Google Sheets integration works

    1. A new row is added on Google Sheets
    2. Zapier sends an IP from it to IP2Location for geolocation query
    3. Zapier adds the results to a row on another Google Sheet worksheet

    Apps involved

    • Google Sheet
    • IP2Location

Why Zapier?

Free

Get started for free—14 day trial of premium features and apps.

Easy

No coding required—automate any of 1,000+ apps in minutes.

Secure

Enterprise-level security—connect mission-critical apps.

IP2Location Integration Details

Launched on Zapier May 5, 2016

Zapier combines Triggers (like "New Subscriber") and Actions (like "Create Campaign") to complete an action in one app when a trigger occurs in another app. These combos—called "Zaps"—complete your tasks automatically.

The following IP2Location Triggers, Searches, and Actions are supported by Zapier:

Lookup IP Address by Package

Finds geolocation info about an IP address like city, country, timezone. Select package for varying levels of information.

Use our free platform to build a single Zapier integration and instantly connect your app with 1,000+ others.

Become a Zapier Integration Partner

IP2Location is a non-intrusive geo IP solution to help you to identify a visitor's geographical location.