Collect WhatsApp leads and add them to Sheets
An n8n agent chats with WhatsApp leads, gathers contact details, and records them in Google Sheets.
- What they did
- The demo uses an n8n flow that begins with a WhatsApp trigger and passes each incoming message to an AI agent. In the chat, the agent requests the lead’s name and email, then sends the collected details straight into Google Sheets. The three parts are connected end to end, so nothing else is needed once the message arrives.
- How it went
- The demo shows the lead being captured and written to Sheets automatically. It does not give any numbers or mention any errors.
- Tips
- A build like this should be tested from the first WhatsApp message through to the spreadsheet so you can spot any step that fails. It also helps to review the sheet mapping before turning the workflow on.
Try it yourself with n8n
Set up an n8n workflow for [business name] that starts when a message lands on [phone number or WhatsApp Business account] through the WhatsApp Cloud API. Add an AI agent that greets the person, collects their name and email in separate turns, and checks that the email format looks right. Before any data is saved, stop and ask me to approve the lead details. After I approve, add a new row in [sheet name] on Google Sheets with the lead’s name, email, phone number, and the time of capture, then reply with a short thank-you message on WhatsApp. Also show me how to test the workflow with a sample conversation before it goes live.
Fill in the [brackets]. Agents can make mistakes, so review anything before it is sent, paid or deleted.
Get 3 agent uses like this every morning
With the day's top AI news. Free, and one click to unsubscribe.
Related agent uses
Build WhatsApp support and application tracking in n8n
A consulting firm used n8n agents to answer WhatsApp questions, gather intake details, read uploads, and keep clients updated on application status.
Build a lead-finding and email-drafting workflow
They used n8n to collect local business leads, enrich them, draft outreach, and store everything in Google Sheets for review.
Use n8n to handle WhatsApp customer chats
An n8n agent can read WhatsApp inquiries, look up information, check availability, and record and answer messages.
Map prospect sites into outreach angles with n8n
They built an n8n workflow that collects company URLs, reads prospect pages, and turns them into sales-ready opportunity summaries.
Sort incoming support mail and prepare review drafts
An n8n flow reads support emails, labels them, and writes reply drafts for a person to check.
Turn your site into a WhatsApp support bot
An n8n workflow turns a business website into a WhatsApp agent that answers questions and books calls.