Capture WhatsApp Messages and Store in Google Sheets
Workflow Description
Automate message reception from WhatsApp, process them in controlled batches, and store them in Google Sheets with conditional filtering and scheduled execution. Perfect for centralizing customer inquiries and creating lightweight CRM workflows without code.
How it works
- 1.Receive incoming WhatsApp messages automatically
- 2.Split messages into manageable processing batches
- 3.Apply conditional filters to qualify messages
- 4.Save processed data to Google Sheets rows
- 5.Schedule execution based on your business hours or frequency
Use cases
- Log customer inquiries from WhatsApp into a centralized spreadsheet database
- Build a simple CRM linking conversations to actionable records
- Archive important messages automatically for compliance and follow-up
Requirements
- WhatsApp Business account or linked WhatsApp number connected to n8n
- Google Sheets document with edit permissions configured
- Basic understanding of conditional logic and batch processing
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
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