Google Sheet with custom functions add-on

You are here:

This custom functions add-on allow an easy access to all our features to business analyst, data engineers, data scientific without a development background. You can also import into your Google Sheet your data usage and cross it with our functions without a single line code!

You can find this functions in the Add-ons section of Google Spreadsheet, searching for Apility.io or clicking here

This add-on provides several custom functions to dig inside IP, AS, Domains or Emails.

  • APILITYIP2GEO: This function returns full details about the geolocation of your IP. Example: Write an IP in cell A1. Then in cell B1, enter =APILITYIP2GEO(A1). The results will fill cells B1 to L1 and contains the Latitude, Longitude, Continent, Country, Region, City, Postal code, Autonomous System Number, AS Name, AS Country and hostname.
  • APILITYIP2AS: Returns full details about the Autonomous System of your IP. Example: Write an IP in cell A1. Then in cell B1, enter =APILITYIP2AS(A1). The results will fill cells B1 to D1 and contains the Autonomous System Number, AS Name and AS Country.
  • APILITYASNUM2AS: Returns full details about the Autonomous System of a given AS Number. Example: Write the AS Number in cell A1. Then in cell B1, enter =APILITYASNUM2AS(A1). The results will fill cells B1 and C1 and contains the Autonomous System Name and AS Country.
  • APILITYASNUM2NET: Returns full details about the Autonomous System Networks of a given AS Number. Example: Write the AS Number in cell A1. Then in cell B1, enter =APILITYASNUM2NET(A1). The results will fill cells B1 to Bx with all the CIDRs.
  • APILITYBADIP: Returns full list of blacklists where the given IP was found, or Not Found. Example: Write the IP in cell A1. Then in cell B1, enter =APILITYBADIP(A1). The results will fill cells B1 to Bx with all the lists.
  • APILITYBADDOMAIN: Returns full Scores and list of blacklists where the given Domain was found, or Not Found. Example: Write the Domain name in cell A1. Then in cell B1, enter =APILITYBADDOMAIN(A1). The results will fill cells B1 to B10 and contains in this order the Overall Score, Blackists Score, IP Score, Blacklists of Domain, Blacklists of MX records, Blacklists of NS records, Blacklists of Domain IP, MX recods, NS records, Domain IP
  • APILITYBADEMAIL: Returns full Scores and list of blacklists where the given Email was found, or Not Found. Example: Write the Email name in cell A1. Then in cell B1, enter =APILITYBADEMAIL(A1). The results will fill cells B1 to B10 and contains in this order the Overall Score, Blacklists Email Score, Free Email Provider Score, Disposable Email Provider Score, SMTP Test Score, Address Format Score, Blackists Score, IP Score, Blacklists of Email, Blacklists of Domain, Blacklists of MX records, Blacklists of NS records, Blacklists of Domain IP, Is Freemail, Is Disposable Email Provider, SMTP Configured to catch all emails, SMTP MX records functional, SMTP Email address Exists, Is a Role Address, Address is Well Formed, MX recods, NS records, Domain IP