Loading

SQL Server + 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.

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.

  1. When this happens...
    SQL ServerSQL Server
    New Row

    Triggered when you add a new row.

    TriggerScheduled
  2. automatically do this...
    IP2LocationIP2Location

    Finds geolocation info about an IP address like city, country, timezone.

    ActionSearch
  3. then do this!
    SQL ServerSQL Server
    New Row

    Triggered when you add a new row.

    ActionWrite
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Table/ViewRequired

    • Order By

    • Dedupe Key

    Trigger
    Scheduled
    Try It
  • SQL Server triggers, actions, and search

    New Table

    Triggered when you add a new table.

    Trigger
    Scheduled
    Try It
    • TableRequired

    Action
    Write
    • TableRequired

    • Lookup ColumnRequired

    • Lookup ValueRequired

    Action
    Search
sql-server logo
sql-server logo

About SQL Server

SQL server (or MS SQL) is a top of the line database geared for the cloud
Learn moreHelp

Related categories

  • Databases

Similar apps

MySQL integrationsMySQL integrations

MySQL

Databases
PostgreSQL integrationsPostgreSQL integrations

PostgreSQL

Databases
Firebase / Firestore integrationsFirebase / Firestore integrations

Firebase / Firestore

Databases
ip2location logo
ip2location logo

About IP2Location

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

Related categories