Utility Functions

Overview

SheetMagic includes utility functions for tasks beyond AI and web scraping, such as domain availability checking.

DOMAINCHECK

Check if a domain is available for registration.

Syntax

=DOMAINCHECK(domain)

Parameters

Parameter	Type	Required	Description
`domain`	string	Yes	Domain name to check (e.g., "example.com")

Returns

Status	Description
`AVAILABLE`	Domain is available for registration
`TAKEN`	Domain is already registered
`ERROR: [message]`	An error occurred during lookup
`UNKNOWN`	Could not determine status

Examples

Basic check:

=DOMAINCHECK("example.com")

From cell reference:

=DOMAINCHECK(A1)

With URL (automatically parsed):

=DOMAINCHECK("https://example.com/page")

Returns status for "example.com".

Supported TLDs

DOMAINCHECK uses the RDAP (Registration Data Access Protocol) and supports the following TLDs:

Generic TLDs

.com
.net
.org
.info
.biz
.name

Technology TLDs

.io
.ai
.app
.dev
.cloud

Regional TLDs

.us
.uk
.ca
.de
.fr
.eu

Other TLDs

.co
.tv
.me
.xyz

Support for additional TLDs depends on RDAP availability for that registry.

Use Cases

Brand Name Research

Check availability across multiple TLDs:

A	B
mybrand.com	`=DOMAINCHECK(A1)`
mybrand.io	`=DOMAINCHECK(A2)`
mybrand.co	`=DOMAINCHECK(A3)`
mybrand.ai	`=DOMAINCHECK(A4)`

Bulk Domain Checking

Create a list of potential domain names and check them all:

// In column A: domain names
// In column B: =DOMAINCHECK(A1), =DOMAINCHECK(A2), etc.

Domain Availability Report

Combine with conditional formatting:

Green for "AVAILABLE"
Red for "TAKEN"
Yellow for "UNKNOWN" or "ERROR"

Competitive Research

Check if competitor brand variations are available:

=DOMAINCHECK(A1 & "hq.com")
=DOMAINCHECK(A1 & "app.com")
=DOMAINCHECK("get" & A1 & ".com")

Combining with AI

Generate Domain Name Ideas

=AITEXT("Generate 10 domain name ideas for a " & A1 & " business")

Then check availability for each suggestion.

Domain Scoring

=AITEXT("Rate this domain name on a scale of 1-10 for brandability, memorability, and SEO: " & A1)

Best Practices

1. Clean Domain Input

DOMAINCHECK automatically handles:

URLs (extracts domain)
www prefixes
Trailing slashes

// All return the same result:
=DOMAINCHECK("example.com")
=DOMAINCHECK("www.example.com")
=DOMAINCHECK("https://example.com/page")

2. Batch Checking

For large lists, space out requests to avoid rate limiting:

// Check in batches of 20-50 at a time

3. Verify with Registrar

DOMAINCHECK provides a quick lookup, but always verify availability with an accredited domain registrar before purchasing.

Error Handling

Result	Meaning	Action
`AVAILABLE`	Domain appears to be unregistered	Verify with registrar
`TAKEN`	Domain is registered	Consider alternatives
`ERROR: timeout`	Request timed out	Try again later
`ERROR: invalid`	Invalid domain format	Check domain syntax
`UNKNOWN`	Status unclear	Check manually with registrar

Limitations

Rate limiting: Excessive requests may be throttled
RDAP coverage: Not all TLDs are supported
Real-time accuracy: Results may be cached; always verify with registrar
Premium domains: May show as available but have premium pricing

On this page