Track domain expiry dates with Google Sheets and WHOIS API

Description

Automatically track domain expiry dates from Google Sheets, fetch real-time DNS expiry data via WHOIS API, and update expiry details back to your sheet with zero manual effort.

Automated Domain Expiry Date Tracker with Google Sheets & WHOIS API

Automate the entire process of monitoring domain expiry dates for all your websites directly from Google Sheets.
This workflow reads domain names, fetches DNS SOA expiry information using the WHOIS API, converts timestamps into readable dates, and updates expiry details back into your tracking sheet—fully automated and rate-limit safe.

Perfect for SEO teams, agencies, hosting managers, and businesses managing large domain portfolios.

What this workflow does

This automation handles four key tasks:

Reads domain data

Pulls all website domains directly from a Google Sheet

Fetches expiry details

Uses WHOIS API to retrieve DNS SOA records for each domain

Processes expiry dates

Converts expiry timestamps into human-readable DD-MM-YYYY format
Extracts expiry month and year automatically

Updates tracking sheet

Writes expiry date, month name, and year back to Google Sheets
Processes domains one by one with a controlled delay to avoid API limits

How it works

The workflow starts manually and loads configuration values such as Google Sheet ID and sheet name.
It reads all domains listed in the Websites column and processes them in a loop.

For each domain, the workflow calls the WHOIS API to fetch DNS SOA records.
The expiry timestamp is extracted, converted into a readable date format, and enriched with expiry month and year values.

Once processed, the workflow updates the same Google Sheet row with the new expiry information.
A 30-second pause is applied before moving to the next domain to ensure API safety and stability.

Setup requirements

Accounts needed:

n8n instance (self-hosted or cloud)
Google account with Google Sheets access
RapidAPI account with WHOIS API access

Estimated setup time: 10 minutes

Setup steps

1. Import workflow

Copy the workflow JSON
Open n8n → Workflows → Import from JSON
Paste and import
Verify all nodes are connected correctly

2. Configure Google Sheets

Create a Google Sheet with a Websites column
Add Google Sheets OAuth2 credential in n8n
Paste your Sheet ID and sheet name inside Set Sheet Configuration node

3. Configure WHOIS API

Get your RapidAPI WHOIS API key
Add it to the Fetch DNS Records via WHOIS API HTTP Request node
Test the API request

4. Verify data mapping

Ensure expiry values map correctly to:

Domain Expiry
Expiry Month
Expiry Year

5. Run and monitor

Run the workflow manually
Check execution logs
Verify expiry data updates correctly in Google Sheets

What data gets updated

Domain data:

Domain name
Expiry date (DD-MM-YYYY)
Expiry month (January–December)
Expiry year

Sheet updates:

Existing rows are matched using the Websites column
No duplicate rows are created

Use cases

SEO management:** Prevent domain expiries that can hurt rankings
Agency operations:** Track client domains in one central sheet
Hosting monitoring:** Stay ahead of renewal deadlines
Portfolio management:** Manage hundreds of domains automatically

Important notes

Replace the WHOIS API key before activating
Google Sheets column names must match exactly
Workflow runs sequentially to avoid rate limits
One domain is processed at a time
Expiry accuracy depends on DNS SOA availability

Support
Need help or custom development?

📧 Email: [email protected]

🌐 Website: https://isawow.com/