Stop Losing Leads — Build a Tracker That Works While You Sleep
Every business loses leads. Not because they are bad at sales, but because the process breaks down between the first touchpoint and the follow-up. An email gets buried, a form submission lands in the wrong folder, or someone just forgets to add a contact to the CRM. Sound familiar?
In this tutorial, you will build a fully automated lead tracker using n8n and Google Sheets — no code required, and you can have it running in under 20 minutes. This setup captures leads from any source, logs them to a spreadsheet, and can even trigger a follow-up email via activecampaign.
What You Will Build
By the end of this guide, you will have a working n8n workflow that:
- Receives lead data via a webhook (from a form, landing page, or other tool)
- Appends each lead as a new row in Google Sheets automatically
- Optionally adds the lead to an activecampaign email list for instant follow-up
- Runs 24/7 without any manual input
What You Need Before You Start
- A free or paid n8n account (cloud or self-hosted)
- A Google account with access to Google Sheets
- An activecampaign account (optional, for email follow-ups)
- A lead source — a Typeform, Tally, or any form tool that supports webhooks
Step 1: Set Up Your Google Sheet
Create a new Google Sheet and name it Lead Tracker. Add the following column headers in row 1:
- Timestamp
- First Name
- Last Name
- Source
- Status
Leave the rest of the sheet empty — n8n will fill it in automatically as leads come in.
Step 2: Create a New Workflow in n8n
Log into your n8n dashboard and click New Workflow. Give it a descriptive name like Lead Tracker – Google Sheets. This keeps your workspace organised as you add more automations later.
Add a Webhook Trigger Node
Your first node will be a Webhook node. This acts as the entry point for all incoming lead data. Configure it as follows:
- HTTP Method: POST
- Path: something memorable like
new-lead - Response Mode: Immediately
Copy the generated webhook URL — you will paste this into your form tool in a later step. The n8n webhook is now ready to receive data.
Step 3: Connect Google Sheets
Add a Google Sheets node after the Webhook node. Connect your Google account when prompted, then configure the node:
- Operation: Append Row
- Spreadsheet: Select your Lead Tracker sheet
- Sheet: Sheet1 (or whatever your tab is named)
Now map the incoming webhook fields to your column headers. In n8n, this is done using expressions. For example, map {{ $json.email }} to the Email column, and {{ $json.first_name }} to First Name. Add a static value like New for the Status column so every lead starts with a clear state.
Step 4: Add ActiveCampaign for Instant Follow-Up (Optional)
If you want to go beyond tracking and actually follow up with leads automatically, connect activecampaign as the next node in your n8n workflow.
- Operation: Create or Update Contact
- Email: Map from the webhook data
- List: Select your sales or nurture list
- Tags: Add a tag like
lead-trackerfor easy segmentation
With this step, every new lead not only gets logged in Google Sheets but is also added to your activecampaign account and enrolled in your email sequence within seconds.
Step 5: Test Your Workflow
Click Execute Workflow in n8n and send a test POST request to your webhook URL using a tool like Postman or even your connected form. Check your Google Sheet — a new row should appear with all the mapped fields filled in correctly.
If you connected activecampaign, log into your account and confirm the test contact was added to your list.
Step 6: Activate and Go Live
Once your test passes, click the Active toggle in your n8n workflow. The workflow is now live and will run automatically every time a new lead submits your form.
Go back to your form tool (Typeform, Tally, etc.) and paste your n8n webhook URL into the form's webhook or integration settings. Save and publish.
Pro Tips to Get More Out of This Setup
- Add a duplicate check: Use an n8n IF node to check if the email already exists in your sheet before appending.
- Colour-code your sheet: Use Google Sheets conditional formatting to highlight hot leads in orange and cold ones in grey.
- Build a dashboard: Connect Google Data Studio (Looker Studio) to your Lead Tracker sheet for real-time visualisations.
- Notify your team: Add a Slack or email node in n8n to ping your sales team every time a high-value lead comes in.
Why This Combination Works So Well
n8n handles the logic and connectivity — it is the glue between your tools. Google Sheets provides a simple, shareable, and universally understood interface that anyone on your team can access without needing to learn new software. And activecampaign adds the marketing muscle to turn a cold lead into a paying customer.
Together, this stack replaces hours of manual data entry, reduces human error, and ensures no lead ever falls through the cracks again.
Ready to Build It?
This entire workflow takes less than 20 minutes to set up with n8n, and once it is running, it requires zero maintenance. Start with the free tier of n8n, connect your existing Google Sheet, and watch your lead tracking become completely hands-free.
The best CRM is the one your team actually uses — and sometimes, that is just a well-automated spreadsheet.
This post was created with tools we use and recommend: n8n for workflow automation, Turbotic as an AI-native automation alternative, ElevenLabs for AI voiceover, Placid for visual content creation, and Hostinger for reliable VPS hosting. Some links are affiliate links.