Find Geolocation of the IP addresses via Google Apps Script

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;

IPFinder

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;

IPFinder Result

Here is the link to the document. You may try yourself.

https://goo.gl/1qaMzh

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.

Cheers!

Advertisements

Your JIRA issues to Google spreadsheet

I was wondering how could I get my all unresolved JIRA issues to my spreadsheet. I made a research and find this simple way to get all my issues.I used JIRA REST API. 

Here, In my JIRA I have this in progress issue;

jirra-open-issues
Unresolved JIRA Issues

I wanted to get this open issue data to my spreadsheet as this;

spreadsheet
Final Result

I opened script editor and wrote this code;

Have fun !