Irantha Jayasekara
Irantha Jayasekara
Digital Products & Solution Provider

Drink A Coffee With Me Today

Loading...
Success!
Error!

Follow Me On Instagram

alt text alt text alt text alt text alt text alt text
Available For Freelance
Menu
Close
April 24, 2018

Find Geo location of Multiple IP addresses via Google Apps Script

By Irantha
Google Apps Scripts

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.

Let me explain what I have done. I created a Google sheet as below;

Find Geo location of IP addresses


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;

Find Geo location of IP addresses

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.
Cheers!
Author Details
Irantha Jayasekara
Irantha Jayasekara

Software Developer, Web Developer, Freelancer, Project Manager & Google Apps Scripts and API expert

Share Post