Skip to content
Share
Explore

DNS Query demo

A demo doc for a very, very simple DNS Query Pack built in a rush for the Coda Packathon 2022 (while learning how Packs are built ๐Ÿ˜…).
Pablo Felip


โ“ What


This Pack is a port of
these two Apps Script custom functions
โ 
for Google Sheets I built a while ago. It uses Cloudflareโ€™s 1.1.1.1 DNS API, as demonstrated
here
โ 
, to retrieve information about different DNS records of any domain.


โš™๏ธ How


This Pack just adds these two custom formulas:
DnsRecord()
Returns the value of the specified DNS record of the provided domain.
dnsRecordType
DNS record to fetch.
Supports A, AAAA, CAA, CNAME, DS, DNSKEY, MX, NS, NSEC, NSEC3, RRSIG, SOA and TXT records.
โ€‹
โ€‹
domain
Domain to query.
โ€‹
IsGoogleEmail()
Returns a true value if an email address is of the Gmail or Google Workspace type
emailAddress
Email address to test.
Also admits a domain name!
There are no rows in this table
โ 

โ˜๏ธ The IsGoogleEmail() formula is also available as a column format. In that case, its type parameter will default to google.
โ 
image.png
โ 
โ 


๐Ÿ•น๏ธ Demos


โ 
number-one.png
โ 
โ 
โ 
Input a domain and choose a DNS record type to fetch its value.
โ 

Domain:
โ 
โ 

DNS record
โ 
โ 


DnsRecord([dnsRecordType 1], domain)
โ 
10 aspmx.l.google.com.,20 alt1.aspmx.l.google.com.,30 alt2.aspmx.l.google.com.,40 aspmx2.googlemail.com.,50 aspmx3.googlemail.com.
โ 
โ 


โ 
number-two.png
โ 
โ 
โ 
Type an email (or domain) and select the type of test to perform to get a true or false result.
โ 

Email address:
โ 
โ 

Test type
โ 
โ 

IsGoogleEmail(email,testType)
โ 
true
โ 
โ 


โ 
number-three.png
โ 
โ 
โ 
Add domains to the table, choose a record type and enable or disable โœ‰๏ธ email type checks.
โ 

DNS record
โ 
โ 

โ 
โ 
Test if Email/Domain is of Gmail type
โ 
โ 
Test if email/domain is of GWS type
There are no rows in this table
โ 


โ 
number-four.png
โ 
โ 
โ 
Please, change column type of Is a Google email? in the table below to Is a Google email .
โ 
There are no rows in this table
โ 
โ 
image.png
โ 
โ 

โ 

Cover photo by
Wilhelm Gunkel
โ 
in
Unsplash
โ 
โ 
~ Onions, for no particular reason ๐Ÿคทโ€โ™‚๏ธ ~

Want to print your doc?
This is not the way.
Try clicking the ยทยทยท in the right corner or using a keyboard shortcut (
CtrlP
) instead.