Why Most Lead Trackers Break Down
Every sales team has the same problem: leads come in from a dozen different places — contact forms, emails, LinkedIn, ad campaigns — and someone has to manually paste them into a spreadsheet. That someone is usually you. And by Friday, the sheet is already out of date.
The fix is not a new CRM. The fix is a lightweight, automated workflow that catches every lead the moment it arrives and writes it to a structured Google Sheet — without you touching a thing. You can build this with n8n in under 20 minutes.
What You Will Build
By the end of this guide you will have a working automation that:
- Triggers whenever a new lead is submitted via a form or webhook
- Extracts key fields: name, email, source, date
- Appends a new row to a Google Sheet automatically
- Optionally tags the lead status and assigns a follow-up date
- Can pipe hot leads directly into activecampaign for immediate nurturing
No code required. No paid plugins. Just n8n and a free Google account.
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
- Follow-Up Date
Keep the sheet clean and do not add any formatting logic yet — the n8n workflow will handle all data population.
Step 2 — Create a New Workflow in n8n
Open your n8n instance (self-hosted or cloud) and click New Workflow. Give it a descriptive name like Lead Tracker — Google Sheets.
Add a Webhook Trigger Node
Your first node will be a Webhook node. This gives you a unique URL that any form, landing page, or third-party tool can POST data to. Set the method to POST and copy the generated webhook URL for use in your form tool.
If you are capturing leads from a Typeform, Tally, or similar tool, paste this webhook URL into that tool's integration settings. Every submission will now hit your n8n workflow instantly.
Add a Set Node to Normalise Data
Different form tools send data in different shapes. Add a Set node after the webhook and map the incoming fields to your standard column names. For example:
first_name→ First Nameemail_address→ Emailutm_source→ Source
Also add two static values here: set Status to New and set Follow-Up Date to today plus three days using the n8n expression engine: {{ $now.plus(3, 'days').toISODate() }}.
Step 3 — Connect Google Sheets
Add a Google Sheets node and authenticate it with your Google account via OAuth2. Select the Append Row operation, then point it at your Lead Tracker sheet.
Map each field from your Set node to the corresponding column. The n8n Google Sheets node will create a new row for every lead that comes through the webhook — no overwrites, no duplicates.
Step 4 — Optional: Push Hot Leads to ActiveCampaign
Want to go further? Add a conditional IF node after the Google Sheets node. If the lead source equals paid-ad or the form includes a field like budget: high, route those leads into activecampaign automatically.
Use the activecampaign node in n8n to create a contact and add them to a specific automation sequence. Hot leads get immediate follow-up. Cold leads stay in the sheet for manual review. All of this happens in milliseconds.
Step 5 — Test and Activate
Use the Test Workflow button in n8n and submit a sample lead through your form. Check that:
- The row appears in Google Sheets with all fields populated
- The timestamp is correct
- The follow-up date is three days from now
- Hot leads (if applicable) appear in activecampaign
Once everything looks good, click Activate. Your lead tracker is now live and fully autonomous.
Scaling the Workflow
This base setup takes 20 minutes. But once it is running, you can extend it without breaking anything:
- Add a Slack or Telegram node to get notified for every new lead
- Use an AI node in n8n to score leads based on their responses
- Add a Duplicate Check by looking up the email in the sheet before appending
- Connect multiple form sources to the same webhook endpoint
Why n8n Is the Right Tool for This
n8n is open-source, self-hostable, and built for exactly this kind of integration work. Unlike Zapier or Make, the n8n pricing model does not punish you for running high-volume workflows. You own the infrastructure, you own the data, and you can customise every node with JavaScript if you need to.
For teams that live in Google Sheets and need a no-nonsense lead pipeline, this workflow is one of the highest-ROI automations you can build. Start simple, then layer in complexity as your process matures.
Final Thoughts
A lead tracker does not need to be complicated. It needs to be reliable, automatic, and always up to date. With n8n handling the workflow logic and Google Sheets acting as your live database, you get exactly that — in 20 minutes flat.
Build it once. Let it run. Focus on closing, not copying and pasting.
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.