I was challenged to find Geolocation of list of IP addresses lately. I know there are plenty of online resources to find the location of an IP one by one. However, it was difficult to find a bulk approach. Hence I thought to automate the process and share with you all.
Here I used IPSTACK which offers one of the leading IP to geolocation
APIs and global IP database services worldwide.
I have a google sheet as below;
I’m going to paste all my IP addresses in column A and click on IP finder menu item and press process. The result will be displayed in next tab as below;
Here is the link to the document. You may try yourself.
To run it on your own sheet, create below function in your Google Apps Script Editor. Make sure your sheet looks like above in my sample.
Hope you find it useful. Contact me if you need further improvements and changes.