Track domain expiry dates with Google Sheets and WHOIS API
Ready for 3.0What this workflow does
This workflow has 8 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls whois-api6.p.rapidapi.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Sheet Configuration (Edit Fields (Set)): sets 3 fields: Sheet ID, sites sheet, Email Size
- Read All Domains from Sheet (Google Sheets): uses Google Sheets
- Loop Through Each Domain (Loop Over Items (Split in Batches)): loops over the items in batches
- Fetch DNS Records via WHOIS API (HTTP Request): calls whois-api6.p.rapidapi.com (POST)
- Convert Expiry Timestamp to Date (Code): runs custom JavaScript code
- Write Expiry Data to Sheet (Google Sheets): update
- Pause Before Next Domain (Wait): waits 30 seconds
Services it uses
HTTP calls to: whois-api6.p.rapidapi.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait
From the author
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…