Look up IPs from one Google Sheet (via IP2Location) and store them on another worksheet
When this happensStep 1: New Spreadsheet Row
Then do thisStep 2: Lookup IP Address
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
- A new row is added on Google Sheets
- Zapier sends an IP from it to IP2Location for geolocation query
- Zapier adds the results to a row on another Google Sheet worksheet
- Google Sheet