PLEASE READ THIS SECTION BEFORE USING THIS ADD-ON.
Get the geo location information as simple as using the function from Google Sheet.
NOTE: Do not process more than 400 IPs at a time as Google Sheet has quotas/limitations.
The geo location information for the corresponding IP Address on Column A will now appear.
Now we need to store the results. Select the result cells and right-click. Then click Copy.
Go to another sheet and right-click. Then click Paste special -> Paste values only.
NOTE: We only want to store the values instead of the formula.
Go back to the original sheet and delete the result rows. After that, you can do the next batch of IP addresses.
NOTE: This is so that we don't run the formula on the previously queried IP addresses. Google Sheet will reprocess if you close and reopen the sheet.