Verify emails and phone numbers in Google Sheets with ApexVerify
UnknownWhat this workflow does
This workflow has 7 nodes and runs on Google Sheets events. Along the way it connects Google Sheets and Apexverify (community).
How it runs
Trigger: On Google Sheets events.
- If: checks a condition and branches into true / false
- If: checks a condition and branches into true / false
- Apex Verify: uses Apex Verify
- Apex Verify: uses Apex Verify
- Update row in my sheet (Google Sheets): update
- Update row in my sheet (Google Sheets): update
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-apexverify is verified or supports 3.0 (used in ApexVerify - Phone Number Verification, ApexVerify - Email Address Verification).
Nodes used (4)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Apex Verify
n8n-nodes-apexverify.apexVerify - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow watches a Google Sheets lead list and uses ApexVerify to verify new or changed email addresses and phone numbers, then writes the verification status back into the same sheet. How it works 1. Triggers when a row is added or…