Bulk WhatsApp Number Verification via Unofficial API
detail.loadingPreview
Automate the verification of thousands of WhatsApp numbers directly from your Google Sheet. This workflow ensures you only reach out to active WhatsApp users, saving you time and resources.
About This Workflow
Tired of sending messages to invalid WhatsApp numbers? This powerful n8n workflow leverages an unofficial API (WasenderAPI.com) to automatically verify your contact list. It efficiently processes numbers from a Google Sheet, checking their WhatsApp registration status and updating the sheet with the verification results. To prevent rate limiting and ensure smooth operation, the workflow incorporates batch processing and strategic delays. This is an essential tool for any sales or marketing team looking to optimize their outreach and improve campaign effectiveness by focusing on engaged leads.
Key Features
- Automated Verification: Effortlessly check if a WhatsApp number is active without manual intervention.
- Google Sheets Integration: Seamlessly read contacts from and write verification status back to your Google Sheets.
- Scalable Processing: Handles large volumes of numbers with built-in batching and rate-limiting strategies.
- Customizable Triggers: Schedule the verification process to run at regular intervals.
- Cost-Effective Solution: Utilizes an affordable unofficial API to keep verification costs low.
How To Use
- Set up Google Sheets: Create a Google Sheet with columns like 'WhatsApp No', 'Verified/Unverified', and 'Status'. Ensure the 'Status' column is initially empty for rows to be processed.
- Configure n8n Schedule: Set the 'Trigger Every 5 Minute' node to your desired frequency.
- Fetch Contacts: In the 'Fetch All Pending Contacts for Verifing' node, connect your Google Sheets account and specify your document and worksheet. Configure the filter to only fetch rows where the 'Status' column is empty.
- Limit and Batch: Use the 'Limit' node to set a maximum number of items to process per run (e.g., 60) and the 'Loop Over Items' node to process in smaller batches.
- Verify WhatsApp Number: In the 'Verify WhatsApp Number Using HTTP Request' node, configure the URL to
https://www.wasenderapi.com/api/on-whatsapp/{{ $json['WhatsApp No'] }}@s.whatsapp.net. Ensure you have correctly set up theWasenderAPIcredential with your Bearer token. - Conditional Logic: Use the 'If' node to check the
existsproperty from the HTTP request response. Iftrue, pass to 'Set Status' ('Verified'); otherwise, pass to 'Set Status1' ('Unverified'). - Update Google Sheets: In the 'Change State of Rows in Checked' node, specify your Google Sheet details. Map the 'Verified/Unverified' column to the output of the 'Set Status' or 'Set Status1' nodes, and the 'Status' column to 'Checked'. Use the
row_numberfrom the 'Loop Over Items' node to update the correct row.
Apps Used
Workflow JSON
{
"id": "6df80d2e-b1ba-49e1-9f2e-683404114c3e",
"name": "Bulk WhatsApp Number Verification via Unofficial API",
"nodes": 21,
"category": "Sales",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 6df80d2e-b1ba...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
AI-Powered Stack Overflow Lead Generation
Unleash the power of AI to automatically scrape valuable lead data from Stack Overflow user profiles. This workflow intelligently identifies and extracts key information like names, locations, skills, and reputation, then seamlessly organizes it into your Google Sheet for effortless lead management.
AI-Powered Upwork Proposal Automation Suite
This n8n workflow leverages AI to automate the entire freelance proposal process, from crafting personalized application text to generating professional Google Doc proposals and visual workflow diagrams. It significantly reduces manual effort, allowing freelancers to scale their client acquisition rapidly and effectively.
Automate Local Business Outreach with AI-Powered Yelp Scraper
This workflow automates the process of scraping local business details from Yelp using AI, then leverages that data to send personalized partnership proposals via Gmail. It's perfect for sales and marketing teams looking to streamline lead generation and outreach campaigns.