DNS in Google Sheets
Create a function
1.1.1.1 works directly inside Google Sheets. To get started, create a Google Function with the following code:
Using 1.1.1.1
When you feed the function NSLookup
a record type and a domain, you will get a DNS record value in the cell you called NSLookup
.
Supported DNS record types
A
AAAA
CAA
CNAME
DS
DNSKEY
MX
NS
NSEC
NSEC3
RRSIG
SOA
TXT
For example, typing:
Or - depending on your regional settings - you may have to use this formula:
Returns