Developer & DevOps
Connect WhatsApp with Google Sheets
15 nodes
200
125
Automatic trigger
Workflow Description
Automation that connects WhatsApp with Google Sheets to capture incoming messages, process them in batches, and save them automatically with filtering and scheduling capabilities.
How it works
- 1.Activate WhatsApp trigger to receive new messages in real-time
- 2.Process messages in batches using Split In Batches node
- 3.Save filtered data to your designated Google Sheets spreadsheet
Use cases
- Collect customer inquiries from WhatsApp and organize them in a centralized table
- Build a simple CRM system for managing contacts and conversation history
- Generate periodic reports of incoming messages categorized by predefined criteria
Requirements
- Active WhatsApp Business account connected to a verified phone number
- Google Sheets spreadsheet with clear column structure (sender, message text, date)
- API permissions enabled between n8n and both services
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
WhatsApp
Split In Batches
Google Sheets
Details
Trigger
Automatic trigger
Nodes
15
Apps
3
Views
200
Downloads
125
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (15)
/
Sent notification template
Whats App
WhatsApp Trigger
Whats App Trigger
Is message?
If
Schedule Trigger
Schedule Trigger
Loop Over Items
Split In Batches
Get new answers
Google Sheets
Reply to the user
Whats App
Update message status
Google Sheets
Wait 1 sec
Wait
New message from the user
Google Sheets
Get new entries
Google Sheets Trigger
User consented for WA messages?
Filter
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note