I was challenged to find Geo location 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 geo location APIs and global IP database services worldwide.
I'm going to paste all my IP addresses in column A of the first tab and click on IP finder menu item and start the process. The result will be displayed in the next tab as below;
Here is the link to the document. You may try yourself. Request access and I will grant you. Please do not change structure or code behind.
Open Google Sheet
To run it to your own sheet, create below function in your Google Apps Script Editor. Make sure your sheet looks like above in my sample.
Also you may need to create an API Access Key from IPSTACK use it as an access key.
Hope you find it useful! Please comment your thoughts and like the post.