Getting lookup information on a list of IP addresses directly within Google Sheets has never been simpler. We’ve partnered with ipstack, the top IP lookup provider used by thousands of tech giants, to get geo-location, currency, timezone and ISP data. Here’s how you can pull IP lookup information to spreadsheets with just a few clicks.
One easy way to import JSON to Google Sheets is with the Google Sheets Add-on KPIBees. With just a few clicks, JSONs can be imported into Google Sheets.
Open KPIBees Gsuite Marketplace listing and install the Google Sheets Add-on.
STEP 2
You will need to provide standard add-on access to KPIBees – don’t worry, we are 100% GDPR compliant.
STEP 3
Open any spreadsheet and go the Add-ons toolbar. Find KPIBees add-on and click on Launch.
STEP 4
Find ipstack in the list of available connectors and click on it.
STEP 5
Go to ipstack, create an account and retrieve your API Key. Then save your ipstack key within KPIBees.
STEP 6
Select the report fields that you want to pull to the spreadsheet. And add the list of IPs that you want to query separated by , or ;
STEP 7
Click on Create Query and get the IP lookup information in your selected spreadsheet cell. That’s it!
Google Spreadsheets
