Gallery
Share
Explore

icon picker
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:
1
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.
2
​
​
domain
Domain to query.
​
3
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!
4
​
​
type
Type of check to perform on the emailAddress parameter.
Optional, if omitted google will be assumed.
Can be any of:
gmail
workspace
google
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:
uji.es
⁠
⁠

DNS record
MX
⁠
⁠


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:
pablo.felip@gedu.es
⁠
⁠

Test type
workspace
⁠
⁠

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
MX
⁠
⁠

⁠
⁠
Test if Email/Domain is of Gmail type
⁠
⁠
Test if email/domain is of GWS type
Domain
🔍 DNS query result
📨 Gmail?
📨 Workspace?
1
⁠
coda.io
⁠
⁠
1 aspmx.l.google.com.,10 aspmx2.googlemail.com.,10 aspmx3.googlemail.com.,5 alt1.aspmx.l.google.com.,5 alt2.aspmx.l.google.com.
​
​
2
⁠
twitch.com
⁠
⁠
1 aspmx.l.google.com.,10 aspmx2.googlemail.com.,10 aspmx3.googlemail.com.,5 alt1.aspmx.l.google.com.,5 alt2.aspmx.l.google.com.
​
​
3
⁠
makenotion.com
⁠
⁠
10 aspmx.l.google.com.,20 alt2.aspmx.l.google.com.,30 aspmx3.googlemail.com.,30 aspmx2.googlemail.com.,20 alt1.aspmx.l.google.com.
​
​
4
⁠
discord.com
⁠
⁠
1 aspmx.l.google.com.,5 alt1.aspmx.l.google.com.,5 alt2.aspmx.l.google.com.,10 aspmx2.googlemail.com.,10 aspmx3.googlemail.com.
​
​
5
⁠
slack.com
⁠
⁠
1 aspmx.l.google.com.,5 alt1.aspmx.l.google.com.,5 alt2.aspmx.l.google.com.,10 aspmx2.googlemail.com.,10 aspmx3.googlemail.com.
​
​
6
⁠
outlook.com
⁠
⁠
5 outlook-com.olc.protection.outlook.com.
​
​
7
upv.es
10 mx2.cc.upv.es.,50 vega.cc.upv.es.,40 mx4.cc.upv.es.,7 mxv.cc.upv.es.
​
​
8
agilcentros.es
20 alt1.aspmx.l.google.com.,10 aspmx.l.google.com.,200 alt3.aspmx.l.google.com.,100 alt2.aspmx.l.google.com.
​
​
9
google.es
0 smtp.google.com.
​
​
10
⁠
ovh.com
⁠
⁠
1 mx1.ovh.net.,5 mx2.ovh.net.
​
​
11
⁠
strato.de
⁠
⁠
200 post14.in.strato.de.,100 post.in.strato.de.
​
​
12
uji.es
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.
​
​
13
⁠
masmenos.tk
⁠
⁠
10 mx.yandex.net.
​
​
14
⁠
gmail.com
⁠
⁠
40 alt4.gmail-smtp-in.l.google.com.,30 alt3.gmail-smtp-in.l.google.com.,10 alt1.gmail-smtp-in.l.google.com.,20 alt2.gmail-smtp-in.l.google.com.,5 gmail-smtp-in.l.google.com.
​
​
15
()&(/)%$
Error: Non-Existent Domain.
​
​
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 .
⁠
User
Is a Google email?
1
User 1
⁠
coordinacion@gedu.es
⁠
⁠
2
User 2
pablo@masmenos.tk
3
User 3
takerna@gmail.com
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 ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.