## Introduction
Conversion rate tracking—specifically the form-to-lead ratio—is vital for startup teams, marketers, and operations specialists who want to measure the quality and effectiveness of lead capture forms. HubSpot’s built-in analytics provide this, but it comes at a subscription cost and vendor lock-in. If you want to regain control, reduce costs, and build a tailored solution, n8n, an open-source automation tool, is an excellent alternative.
In this article, we’ll show you how to build a workflow in n8n that tracks form submissions and correlates them with lead creation events to calculate and report your conversion rates. This empowers your team with real-time, customizable insights without relying on HubSpot.
—
## Problem Statement
HubSpot’s conversion rate feature simplifies form-to-lead ratio calculations by automatically correlating form submissions with leads created in the system. Without HubSpot, you lose that seamless analytics layer and thus risk insufficient visibility into how well your lead capture efforts perform.
This automation aims to:
– Track submitted form data from your web forms
– Capture lead creation events (e.g., in your CRM or database)
– Calculate conversion rates over customizable time windows
– Report or alert teams with actionable metrics in common channels (e.g., Slack, email, or Google Sheets)
Beneficiaries include startup CTOs wanting self-managed analytics, automation engineers building data pipelines, and marketing teams needing better visibility without SaaS expenses.
—
## Tools and Services Integrated
– **n8n:** Workflow automation platform
– **Form Service:** Any webhook-capable form provider (e.g., Typeform, Gravity Forms, custom webhooks)
– **CRM or Database:** Any system where leads are stored (e.g., Airtable, Google Sheets, PostgreSQL, or a CRM with API)
– **Reporting Destinations:** Google Sheets for report storage, Slack or Email for alerts
—
## Overview of the Workflow
### Trigger
– New form submission webhook received
– Lead creation event captured from CRM or database
### Processes
– Store or update form submission counts per time frame
– Store or update lead counts per corresponding timeframe
– Calculate conversion rate = (Leads / Form Submissions) * 100
### Output
– Append or update records in Google Sheets with conversion rate metrics
– Optional: Send Slack notification or Email summary to stakeholders
—
## Step-by-Step Workflow Tutorial
### Step 1: Set Up Incoming Webhook for Form Submissions
1. In n8n, create a **Webhook** node.
2. Configure it to receive POST requests from your form provider.
3. Test it by submitting sample form data and verify n8n receives the payload.
*Tips:*
– Ensure CORS and authentication as needed.
– Keep form fields consistent for easy parsing.
### Step 2: Capture Lead Creation Event
– If your CRM supports webhooks or API event polling:
– Use a **Webhook** node to catch lead creation events OR
– Use a **Cron** node combined with an **HTTP Request** node to poll the CRM API to fetch new leads since last run.
*Example:* Poll your Airtable or Google Sheets leads table for new entries.
### Step 3: Store and Increment Counts
– Use a data store to persist daily form submission and lead counts.
– Options:
– Use Google Sheets as a simple database with date-based rows
– Use Airtable or an actual database for scaling
*Implementation:*
1. Upon new form submission, increment the count for that day.
2. Upon new lead detected, increment lead count for that day.
*Node suggestions in n8n:*
– **Google Sheets node:** Read and update counts.
– **Set node:** Prepare increment parameters.
### Step 4: Calculate Conversion Rate
– After updating counts, calculate the conversion rate:
“`javascript
conversionRate = (leadCount / formSubmissionCount) * 100;
“`
– Round to two decimals for clarity.
– Store this in your reporting sheet or database.
### Step 5: Reporting
– Use the **Google Sheets node** to log the date, submissions, leads, and calculated conversion rate.
– Optionally, add:
– **Slack node** to send a daily update message
– **Email node** to email summary reports to stakeholders
### Additional n8n Node Flow Sample:
1. **Webhook** (Form Submission) →
2. **Google Sheets (Read current count)** →
3. **Set (Increment count)** →
4. **Google Sheets (Update count)** →
5. **Function (Calculate conversion)** →
6. **Google Sheets (Append/report stats)** →
7. **(Optional) Slack / Email Notification**
—
## Common Errors and Tips
– **Data Consistency:** Ensure form IDs and lead IDs correspond; mismatched keys can skew counts.
– **Concurrency Issues:** Use n8n’s resource locking or atomic operations when incrementing counts to avoid race conditions.
– **API Rate Limits:** If polling CRM APIs, respect rate limits and paginate correctly.
– **Time Zones:** Normalize timestamps to UTC or your business timezone for accurate daily reporting.
– **Failed Runs:** Use n8n’s error workflows to catch and retry failures.
—
## Adapting and Scaling the Workflow
– **Multi-Form Support:** Extend the workflow to handle multiple forms by tagging submissions with form identifiers.
– **Granular Time Windows:** Modify the data store to aggregate by week, month, or campaign.
– **Real-Time Dashboards:** Integrate with BI tools like Metabase or Google Data Studio for visualization.
– **Additional Metrics:** Calculate other KPIs such as time-to-lead, lead source performance.
Scaling Options:
– Migrate from Google Sheets to a SQL database as data volume grows.
– Use n8n self-hosted for increased control and custom integrations.
—
## Summary
By building a custom conversion rate tracker in n8n, you remove dependency on HubSpot’s paid analytics feature while gaining full control over how your form-to-lead data is collected, processed, and reported. The workflow captures form submissions and lead creation events, stores counts in a simple database or sheet, calculates conversion rates, and notifies teams via their preferred channels.
This approach is not only cost-effective but customizable and scalable, empowering startup teams and automation experts to tailor lead analytics precisely to their business model.
## Bonus Tip
Consider enriching your data with UTM parameters captured at submission time to analyze conversion rates by marketing channel—an extension easily added by parsing additional webhook data fields in your n8n workflow.