What it does
Someone fills your form, and within about 5 seconds:
- They get a WhatsApp message from your business
- Their details are saved to Google Sheets
Flow: Tally form → n8n Webhook → Clean Lead → Google Sheet → WhatsApp reply
Why it matters: the first business to reply usually wins the lead. This one replies while the customer is still holding their phone.
What you need
| Tool | Why | Cost |
|---|---|---|
| n8n (Cloud or self-hosted) | Runs the automation | Free trial / paid plans |
| Tally | The form | Free |
| Google account | Google Sheets as your CRM | Free |
| Meta developer account | WhatsApp Cloud API | Free test number; per-message fees for real customers |
Import the template
- Download the template (button above)
- In n8n, open Workflows → Create workflow
- Click ⋯ (top right) → Import from File → choose
valerie-ep01-reply-in-5-seconds.json - You'll see 4 nodes and a yellow Setup note
- Click Save
Prepare your accounts
Google Sheet
- Create a new Google Sheet, e.g. "Leads"
- Type these headers in row 1, exactly as written (same spelling and capital letters):
Name | Phone | Service | Message | Timestamp | Status
Tally form
Create a form with these fields. The labels must contain these words:
- Name
- Phone
- Service (a dropdown works well)
- Message
WhatsApp Cloud API
- Go to developers.facebook.com → My Apps → Create App → choose Business
- Add the WhatsApp product
- Open WhatsApp → API Setup. Note your:
- Phone Number ID (not the phone number itself)
- Free test number
- Under To, add your own number as a test recipient and verify it with the code
- ⚠️ The test number can only message numbers on this list (up to 5)
Permanent access token
The token on the API Setup page expires in 24 hours. Create a permanent one:
- Open business.facebook.com → Settings → Users → System users → Add (role: Admin)
- Assign assets: your app (full control) and your WhatsApp account (full control)
- Generate token → choose your app → tick
whatsapp_business_messagingandwhatsapp_business_management - Copy it and keep it private
- 🔒 Never paste a token into chats, screenshots or videos. If one leaks, generate a new one.
Message template
WhatsApp only lets businesses start a conversation with an approved template.
- Open WhatsApp Manager → Message templates → Create template
- Category: Utility · Name:
lead_ack· Language: English - Body (example):
Hi {{1}}, thanks for contacting us about {{2}}. We have received your enquiry and our team will get back to you shortly.
- Samples:
{{1}}=Rahul,{{2}}=Home Loan - Submit and wait until the status is Active (usually minutes to a few hours)
Tips for approval:
- Don't start or end the message with a variable
- Avoid sales words (offer, discount, free) in Utility templates
Connect the nodes
Node 1: New Lead (Tally Webhook)
Nothing to change. Copy its Test URL and Production URL; you'll need them below.
Node 2: Clean Lead
Nothing to change. It:
- Reads the Tally answers by label
- Turns dropdown IDs into readable text
- Formats the phone number for WhatsApp (digits only, adds
91to 10-digit Indian numbers)
🌍 Outside India? Change
'91'in the code to your country code.
Node 3: Save to Google Sheet
- Credential → Create new → Sign in with Google
- Document: paste your Sheet URL
- Sheet: pick the tab with your headers
Node 4: Send WhatsApp Reply
- URL: replace
YOUR_PHONE_NUMBER_IDwith your Phone Number ID - Credential → Create new → Header Auth
- Name:
Authorization - Value:
Bearer YOUR_TOKEN(the word Bearer, a space, then the token)
- Name:
- If your template name isn't
lead_ack, change it in the JSON body
Click Save.
Test it
- In Tally, open Integrations → Webhooks → Connect and paste the Test URL
- In n8n, click Execute workflow (n8n now waits for one event)
- Submit your Tally form using your own verified number
- Check:
- ✅ All 4 nodes are green
- ✅ A new row appears in the Sheet
- ✅ The WhatsApp message arrives on your phone
Go live
- Click Publish (on older n8n versions, switch the workflow to Active)
- In Tally, replace the Test URL with the Production URL
- Done. Every new lead now gets a reply automatically.
To message real customers (not just test numbers), complete Meta Business Verification and add your own business phone number.
Common errors
| Error | What it means | Fix |
|---|---|---|
131030 Recipient not in allowed list | The test number can only message verified numbers | Add the number under API Setup → To |
132001 Template does not exist | Template name or language is wrong, or it isn't approved yet | Check the exact name, use language en, wait for Active |
132000 Parameter count mismatch | The template has a different number of variables | Match the parameters in the JSON body to your template |
190 Access token expired | You used the 24-hour token | Create a permanent system-user token (step 4.4) |
100 Invalid parameter | The phone number has the wrong format | Use the country code and digits only, e.g. 919876543210 |
| Green node, no message | The template is still in review or the number isn't verified | Check the template status and the recipient list |
| Sheet columns are empty | The header names don't match | Make headers match exactly, including capital letters |
| Webhook not triggering | You're using the Test URL while the workflow is published, or the other way round | Test URL with Execute workflow; Production URL after Publish |
Customise it
- Use any form with webhooks (Typeform, Google Forms via Apps Script, your own website)
- Add a Gmail node to alert yourself about every lead
- Write different templates for different services
- Next episode: let AI score each lead Hot, Warm or Cold
Want it done for you?
We can set this up for your business, with your number, your template and your form, in 48 hours.
