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.
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.
- When this happens...New Spreadsheet Row
Triggered when a new row is added to the bottom of a spreadsheet.
- automatically do this...Lookup IP Address
Finds geolocation info about an IP address like city, country, timezone.
- then do this!Create Spreadsheet Row
Create a new row in a specific spreadsheet.
- Free forever for core features
- 14 day trial for premium features & apps