Skip to main content

EP01Season 1

Reply to Every Lead in 5 Seconds

A form submission triggers an instant WhatsApp reply and saves the lead to Google Sheets. Free n8n template plus a step-by-step setup docs.

Setup time
30–45 min
Level
Beginner
Cost
Free to start

Free n8n template · valerie-ep01-reply-in-5-seconds.json

The Ep01 workflow on the n8n canvas: New Lead (Tally Webhook), Clean Lead, Save to Google Sheet, then Send WhatsApp Reply.
Finished workflow in n8nOpen full size

What it does

Someone fills your form, and within about 5 seconds:

  1. They get a WhatsApp message from your business
  2. 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

ToolWhyCost
n8n (Cloud or self-hosted)Runs the automationFree trial / paid plans
TallyThe formFree
Google accountGoogle Sheets as your CRMFree
Meta developer accountWhatsApp Cloud APIFree test number; per-message fees for real customers

Import the template

  1. Download the template (button above)
  2. In n8n, open Workflows → Create workflow
  3. Click ⋯ (top right) → Import from File → choose valerie-ep01-reply-in-5-seconds.json
  4. You'll see 4 nodes and a yellow Setup note
  5. Click Save

Prepare your accounts

Google Sheet

  1. Create a new Google Sheet, e.g. "Leads"
  2. 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

  1. Go to developers.facebook.com → My Apps → Create App → choose Business
  2. Add the WhatsApp product
  3. Open WhatsApp → API Setup. Note your:
    • Phone Number ID (not the phone number itself)
    • Free test number
  4. 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:

  1. Open business.facebook.com → Settings → Users → System users → Add (role: Admin)
  2. Assign assets: your app (full control) and your WhatsApp account (full control)
  3. Generate token → choose your app → tick whatsapp_business_messaging and whatsapp_business_management
  4. 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.

  1. Open WhatsApp Manager → Message templates → Create template
  2. Category: Utility · Name: lead_ack · Language: English
  3. Body (example):
Hi {{1}}, thanks for contacting us about {{2}}. We have received your enquiry and our team will get back to you shortly.
  1. Samples: {{1}} = Rahul, {{2}} = Home Loan
  2. 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 91 to 10-digit Indian numbers)

🌍 Outside India? Change '91' in the code to your country code.

Node 3: Save to Google Sheet

  1. Credential → Create new → Sign in with Google
  2. Document: paste your Sheet URL
  3. Sheet: pick the tab with your headers

Node 4: Send WhatsApp Reply

  1. URL: replace YOUR_PHONE_NUMBER_ID with your Phone Number ID
  2. Credential → Create new → Header Auth
    • Name: Authorization
    • Value: Bearer YOUR_TOKEN (the word Bearer, a space, then the token)
  3. If your template name isn't lead_ack, change it in the JSON body

Click Save.

Test it

  1. In Tally, open Integrations → Webhooks → Connect and paste the Test URL
  2. In n8n, click Execute workflow (n8n now waits for one event)
  3. Submit your Tally form using your own verified number
  4. Check:
    • ✅ All 4 nodes are green
    • ✅ A new row appears in the Sheet
    • ✅ The WhatsApp message arrives on your phone

Go live

  1. Click Publish (on older n8n versions, switch the workflow to Active)
  2. In Tally, replace the Test URL with the Production URL
  3. 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

ErrorWhat it meansFix
131030 Recipient not in allowed listThe test number can only message verified numbersAdd the number under API Setup → To
132001 Template does not existTemplate name or language is wrong, or it isn't approved yetCheck the exact name, use language en, wait for Active
132000 Parameter count mismatchThe template has a different number of variablesMatch the parameters in the JSON body to your template
190 Access token expiredYou used the 24-hour tokenCreate a permanent system-user token (step 4.4)
100 Invalid parameterThe phone number has the wrong formatUse the country code and digits only, e.g. 919876543210
Green node, no messageThe template is still in review or the number isn't verifiedCheck the template status and the recipient list
Sheet columns are emptyThe header names don't matchMake headers match exactly, including capital letters
Webhook not triggeringYou're using the Test URL while the workflow is published, or the other way roundTest 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.

👉 Get it set up

Want this done for you?

Let's talk