Turn Google Form signups and WhatsApp chats into a simple message desk that runs from Google Sheets. New form entries get a WhatsApp template message if the person gave consent. Incoming WhatsApp messages are logged in a sheet so your team can type a reply and send it out on a timer.

Here is how it works. A Google Sheets trigger watches for new form rows, checks if the person agreed to WhatsApp updates, and sends a template message with their details. A WhatsApp webhook receives user messages, filters out non message events, and writes the message text, name, and phone into a Google Sheet with Status set to New. On a set schedule, the sheet is scanned for rows marked Ready. Each Ready row is processed in a batch loop, a WhatsApp reply is sent using the ReplyText column, the status changes to Replied, and a short wait spaces out sends.

You will need a WhatsApp Business phone number, a template approved in Meta, and Google Sheets access. Results include faster replies, a clean record of all chats, and lower copy and paste work. This setup fits teams that want to manage WhatsApp conversations without buying a full help desk tool and prefer Sheets as the queue.

• Google Sheets trigger monitors new form rows and starts outreach only for contacts who consented.
• WhatsApp template message sender fills placeholders with form data like name and date.
• WhatsApp webhook captures inbound messages and ignores non message status events.
• If filter ensures only real messages get stored to the sheet.
• Inbound logging appends name, phone, text, and Status New to a Google Sheet.
• Schedule trigger scans the sheet for rows with Status Ready at set intervals.
• Batch loop sends WhatsApp replies using the ReplyText field and updates Status to Replied.
• Short wait between sends prevents rate issues and keeps delivery smooth.

• Reduce manual message handling from 2 hours to 10 minutes per day by using a Google Sheet as the reply queue.
• Streamline WhatsApp follow ups by 60% with scheduled batch sending and automatic status updates.
• Improve response time by 50% by logging every inbound message instantly and surfacing it in a single view.
• Connect WhatsApp and Google Sheets without extra tools, keeping costs low and setup simple.
• Maintain a clean audit trail of all messages for reporting and training.

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with WhatsApp Business Platform and Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, open the WhatsApp Trigger node, click Create new credential, then follow the on screen instructions to connect your WhatsApp Business app. Copy the webhook URL from the node and add it as the Callback URL in your Meta app settings. Enable message updates.
4. Open the WhatsApp send nodes and create a WhatsApp credential. Provide your Access Token and Phone Number ID. Use a name you will recognize later, like WhatsApp Prod.
5. In Meta, create and get approval for your WhatsApp template. Copy the template name and set the language in the template send node fields.
6. Create a Google Sheet with columns for UserName, UserPhone, UserMessage, ReplyText, Status, and row_number. Keep the sheet IDs used in the nodes or update the documentId and sheetName fields to your sheet.
7. Open the Google Sheets nodes and create Google Sheets OAuth2 credentials. Click Create new credential and follow the on screen prompts to grant access from your Google account.
8. In the Google Sheets Trigger node, select your form responses sheet. Make sure new form submissions add rows to that sheet. Set the poll time to match your needs.
9. Check the filter node that verifies consent. Map it to the correct column in your form responses sheet that stores the WhatsApp opt in value.
10. Validate inbound messages: send a WhatsApp message to your business number. Confirm the execution runs, the If node passes, and a new row with Status New appears in your sheet.
11. Validate replies: in the sheet, type your response in ReplyText and change Status to Ready. Wait for the schedule to run or click Execute on the schedule chain. Confirm your phone receives the reply and the row updates to Replied.
12. Troubleshooting tips: ensure phone numbers are in E.164 format with country code, confirm the Meta webhook is verified and subscribed to messages, and check that the template name and language match the approved version.