Skip to main content

Check WhatsApp numbers from Google Sheets with WasenderAPI

Workflow preview

Workflow preview
100%
Check WhatsApp numbers from Google Sheets with WasenderAPI preview
Open on n8n.io

1. Workflow Overview

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, an...

Best for

  • Lead Generation automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.wait, n8n-nodes-base.if, n8n-nodes-base.manualtrigger, n8n-nodes-base.splitinbatches, n8n-nodes-base.stickynote, n8n-nodes-base.googlesheets, n8n-nodes-base.code, n8n-nodes-wasenderapi.wasenderapi

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Razvan Bara.

Original n8n.io source

1.1 Workflow description

Title
Check WhatsApp numbers from Google Sheets with WasenderAPI
Workflow name
Check WhatsApp numbers from Google Sheets with WasenderAPI

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 community node instead of a generic HTTP Request flow
  • It includes basic phone-format validation before lookup

Who is this for

This workflow is useful for marketers, sales teams, freelancers, and small businesses that manage lead lists and want to validate WhatsApp availability before sending messages. It also fits broader lead-cleaning or contact-verification workflows in n8n.

How it works

  • Loads phone numbers from Google Sheets.
  • Processes the list one row at a time to avoid sending all requests at once.
  • Normalizes each phone number and performs basic international format validation before lookup.
  • Checks valid numbers with WasenderAPI to see whether they are registered on WhatsApp.
  • Writes the result back to Google Sheets for each row.

Why use this workflow

  • Uses the WasenderAPI community node instead of building the request manually with HTTP Request.
  • Filters out obviously invalid phone numbers before calling the verification step.
  • Can be used as a standalone checker or reused as a module inside a larger lead validation workflow.

Requirements

  • Google Sheets access and OAuth2 credentials in n8n.
  • A WasenderAPI account and the n8n-nodes-wasenderapi community node installed.
  • A Google Sheet containing phone numbers in the Mobile Number column.

Setup

  • Duplicate the sample Google Sheet and fill in your phone numbers under Mobile Number.
  • Install the n8n‐nodes‐wasenderapi community nodes.
  • Configure your Google Sheets OAuth2 and WasenderAPI credentials.
  • Adjust the Wait node delay if needed to avoid rate limits.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Wait

Type / Role
n8n-nodes-base.wait - wait
Config choices
Version 1.1

Block 2 - If

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.3

Block 3 - When clicking ‘Execute workflow’

Type / Role
n8n-nodes-base.manualTrigger - manualTrigger
Config choices
Version 1

Block 4 - process one by one

Type / Role
n8n-nodes-base.splitInBatches - splitInBatches
Config choices
Version 3

Block 5 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 6 - Load phone numbers from Google Sheets

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 7 - Normalize phone number

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 8 - Validate international phone format

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 9 - Check WhatsApp registration with WasenderAPI

Type / Role
n8n-nodes-wasenderapi.wasenderApi - wasenderApi
Config choices
Version 1

Block 10 - Update result in Google Sheets

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 11 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 12 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 13 - Notify error

Type / Role
n8n-nodes-wasenderapi.wasenderApi - wasenderApi
Config choices
Version 1

Block 14 - Notify check complete

Type / Role
n8n-nodes-wasenderapi.wasenderApi - wasenderApi
Config choices
Version 1

Block 15 - write Invalid format

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

3. Summary Table

Workflow Check WhatsApp numbers from Google Sheets with WasenderAPI
Complexity advanced
Nodes 15
Categories Lead Generation
Author Razvan Bara
Published 19 Apr 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/15140/15140.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Check WhatsApp numbers from Google Sheets with WasenderAPI do?

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, an...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Lead Generation use case.