Library / Chatbots & Messaging Bots
Chatbots & Messaging Bots
Run a WhatsApp Business Bot with Google Sheets
When a WhatsApp message arrives or new answers appear in Google Sheets, it sends template notifications and replies to users, recording responses back to the sheet.
What it does
# WhatsApp business bot ## Overview Automated workflow: WhatsApp business bot. This workflow integrates 11 different services: filter, stickyNote, wait, googleSheetsTrigger, scheduleTrigger. It contains 19 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 19 - Node Types: 11 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - Sent notification template: whatsApp - WhatsApp Trigger: whatsAppTrigger - Is message?: if - Schedule Trigger: scheduleTrigger - Loop Over Items: splitInBatches - Get new answers: googleSheets - Reply to the user: whatsApp - Update message status: googleSheets - Wait 1 sec: wait - New message from the user: googleSheets - ... and 9 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible
The steps
- Sent notification template
- WhatsApp Trigger
- Is message?
- Schedule Trigger
- Loop Over Items
- Get new answers
- Reply to the user
- Update message status
- Wait 1 sec
- New message from the user
- Get new entries
- User consented for WA messages?
- Error Handler for 8f0dc664
- Error Handler for 30f0a7da
17 steps in total.
Similar automations
Chatbots & Messaging BotsRun a Quiz Bot on WhatsApp with Postgres30 stepsChatbots & Messaging BotsAnswer FAQs in a WhatsApp Bot with Postgres22 stepsChatbots & Messaging BotsShow a Product Catalog in a WhatsApp Bot with Postgres16 stepsChatbots & Messaging BotsWhatsApp Business Bot with Google Sheets Message Log12 steps