Try It

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

  1. When this happensStep 1: New Spreadsheet Row

  2. Then do thisStep 2: Lookup IP Address

  3. Then do thisStep 3: Create Spreadsheet Row

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
Try It

Connect Google Sheets + Google Sheets in Minutes

It's easy to connect Google Sheets + Google Sheets and requires absolutely zero coding experience—the only limit is your own imagination.

All Triggers & Actions

New Spreadsheet Row (Team Drive)

Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.

New Spreadsheet

Triggered when you create a new spreadsheet.

InstantNew or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

New Spreadsheet Row (Team Drive)

Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.

New Spreadsheet

Triggered when you create a new spreadsheet.

InstantNew Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

New or Updated Spreadsheet Row (Team Drive)

Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.

New Worksheet

Triggered when you create a new worksheet in a spreadsheet.

InstantNew Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

New or Updated Spreadsheet Row (Team Drive)

Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.