Filter WhatsApp messages using a Google Sheets blacklist and rate limiting
Ready for 3.0What this workflow does
This workflow has 15 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set — Mock WhatsApp Input (Edit Fields (Set)): sets 2 fields: phoneNumber, message
- Google Sheets: uses Google Sheets
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
- Merge: merges the data from its input branches
- Code: runs custom JavaScript code
- If: checks a condition and branches into true / false
- Set — Max messages per minute (Edit Fields (Set)): sets 1 field: limitThreshold
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
…plus 2 more steps. See the full node list below.
Services it uses
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 - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp
From the author
Quick overview This workflow validates an incoming WhatsApp-style message by normalizing the sender phone number, checking it against a Google Sheets blacklist, and applying a per-minute rate limit before passing approved messages onward. How it works 1. Runs…