Check WhatsApp numbers from Google Sheets with WasenderAPI
UnknownWhat this workflow does
This workflow has 12 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Wasenderapi (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Load phone numbers from Google Sheets (Google Sheets): uses Google Sheets
- process one by one (Loop Over Items (Split in Batches)): loops over the items in batches
- Notify check complete (Wasender Api): uses Wasender Api
- Normalize phone number (Code): runs custom JavaScript code
- Validate international phone format (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Wait: waits 10 seconds
- write Invalid format (Google Sheets): append or update
- Check WhatsApp registration with WasenderAPI (Wasender Api): check on whats app (contact)
- Update result in Google Sheets (Google Sheets): append or update
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-wasenderapi is verified or supports 3.0 (used in Check WhatsApp registration with WasenderAPI, Notify error, Notify check complete).
Nodes used (7)
- Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if - Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Wasender Api
n8n-nodes-wasenderapi.wasenderApi
From the author
WhatsApp number checker Verify phone numbers from Google Sheets and check whether they are registered on WhatsApp using WasenderAPI. This workflow is useful for lead validation, contact cleanup, and pre-qualification before outreach. - It uses the Wasender…