---
title: "DNSQuery and G Suite domain detection in Google Sheets using the Cloudflare name resolution service"
author: "Martin Hawksey"
date: 2020-05-12T15:05:00+00:00
modified: 2020-05-11T21:15:53+00:00
canonical_url: https://pulse.appsscript.info/p/2020/05/dnsquery-and-g-suite-domain-detection-in-google-sheets-using-the-cloudflare-name-resolution-service/
markdown_url: https://pulse.appsscript.info/p/2020/05/dnsquery-and-g-suite-domain-detection-in-google-sheets-using-the-cloudflare-name-resolution-service.md
categories:
  - "Sheets"
  - "Solutions"
tags:
  - "@pfelipm"
  - "GitHub"
featured_image: https://pulse.appsscript.info/files/2020/05/79800243-289f9b80-835c-11ea-9bad-20dd3b8a4829.gif
description: "Dos funciones personalizadas para hojas de cálculo de Google desarrolladas en Apps Script que proporcionan un envoltorio para la función NSLookup, tal y como aparece en la documentación del servicio de resolución de nombres de..."
---

# DNSQuery and G Suite domain detection in Google Sheets using the Cloudflare name resolution service

![DNSQuery and G Suite domain detection in Google Sheets using the Cloudflare name resolution service](https://pulse.appsscript.info/files/2020/05/79800243-289f9b80-835c-11ea-9bad-20dd3b8a4829.gif)

> [https://github.com/pfelipm/dnsquery](https://github.com/pfelipm/dnsquery)
> Dos funciones personalizadas para hojas de cálculo de Google desarrolladas en Apps Script que proporcionan un envoltorio para la función NSLookup, tal y como aparece en la documentación del servicio de resolución de nombres de CloudFlare. Consulta el registro indicado en el o los dominios que se pasan como parámetro utilizando el servicio de resolución de nombres de CloudFlare. Determina si un email o dominio (o lista de emails o dominios) está gestionado por Google o no. – pfelipm/dnsquery

Pablo Felip Monferrer has shared two custom functions for Google Sheets that provide an extension to the `NSLookup` function [originally shared by Cloudflare**](https://developers.cloudflare.com/1.1.1.1/fun-stuff/dns-in-google-sheets/). The first is a wrapper that makes it easy to list specific DNS record types for a single or list of domains. The second function uses the domains `MX` record to automatically detect if a domain has G Suite Gmail settings applied.

Source: *[pfelipm/dnsquery*](https://github.com/pfelipm/dnsquery)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/05/dnsquery-and-g-suite-domain-detection-in-google-sheets-using-the-cloudflare-name-resolution-service/](https://pulse.appsscript.info/p/2020/05/dnsquery-and-g-suite-domain-detection-in-google-sheets-using-the-cloudflare-name-resolution-service/)*