Overview
ClickFunnels is a multi-step sales funnel builder that guides visitors through opt-in forms, sales pages, order forms, upsells, and membership areas. While ClickFunnels includes a built-in CRM and email automation, getting raw submission data into a spreadsheet for cross-funnel analysis or ad spend reconciliation requires manual exports. LeadToSheet captures submissions at each funnel step and writes them to Google Sheets in real time, preserving UTM parameters from the original ad click through every step of the funnel.
Implementation checklist
- 1
Add the LeadToSheet SDK via ClickFunnels tracking code
In your ClickFunnels dashboard, open the funnel and navigate to Settings > Tracking Code > Body Tracking Code. Paste the SDK snippet there. This applies the script to every step in the funnel, so you do not need to add it per-page.
Tip: In ClickFunnels 2.0, you can also add the script at the workspace level under Site > Tracking to apply it across all funnels automatically.
ClickFunnels tracking code
<script src="https://cdn.leadtosheet.com/sdk.min.js" data-client="YOUR_CLIENT_KEY"></script> - 2
Map form fields across funnel steps
ClickFunnels uses different form elements at each funnel step - opt-in forms, order forms, and OTO (one-time offer) forms. Open each step in the editor and verify that input field names are descriptive. Use consistent naming like 'email', 'full_name', and 'phone' across steps so submissions merge cleanly into one Sheet.
- 3
Walk through the complete funnel as a test lead
Submit a test entry starting from the opt-in page through the order form, upsell, and downsell pages. Check your Google Sheet to confirm each step's submission appears as a separate row with the funnel step name and the original UTM parameters preserved.
Customization ideas
Track cross-step funnel progression in Sheets
Add a hidden field at each funnel step that identifies the step name (e.g., 'optin', 'order', 'upsell_1', 'downsell_1'). LeadToSheet captures this field with each submission, letting you build a funnel progression report in Google Sheets that shows where leads drop off.
Reconcile order form revenue against ad spend
ClickFunnels order forms capture product selection and pricing data. LeadToSheet syncs these values alongside UTM campaign parameters, so you can calculate return on ad spend per funnel and per traffic source directly in Google Sheets.
Segment upsell and downsell acceptance rates
By tagging each OTO page's form with a hidden 'offer_type' field, you can pivot on upsell vs. downsell acceptance in Sheets, broken down by the original ad campaign that brought the lead into the funnel.
Troubleshooting
Funnel step navigation loses UTM parameters
ClickFunnels passes leads between funnel steps via server-side redirects that may strip URL query parameters. To preserve UTMs, add hidden fields on the opt-in page populated with UTM values using ClickFunnels' URL parameter passthrough feature, or use LeadToSheet's automatic UTM persistence which stores parameters from the initial page load.
Order form submissions not captured
ClickFunnels order forms that process payments may submit directly to a payment processor (Stripe, PayPal) before firing a standard browser form event. If order form submissions are missing from Sheets, add a ClickFunnels webhook on the order confirmation step that posts to LeadToSheet's webhook endpoint as a secondary capture method.
ClickFunnels 2.0 vs Classic editor differences
ClickFunnels 2.0 uses a new page builder with different DOM structures than Classic. The LeadToSheet SDK supports both, but if you migrated a funnel from Classic to 2.0 and submissions stopped syncing, verify that the tracking code was re-added in the 2.0 settings panel, as migration does not carry over custom scripts.
Frequently asked questions
- Does LeadToSheet capture data from every step in a ClickFunnels funnel?
- Yes. Each funnel step that contains a form generates a separate submission row in Google Sheets. Add a hidden 'funnel_step' field to distinguish opt-in, order, upsell, and downsell entries.
- Can I use LeadToSheet alongside ClickFunnels' Actionetics CRM?
- Yes. LeadToSheet operates at the browser level and does not interfere with Actionetics, Follow-Up Funnels, or any server-side ClickFunnels automation. Both systems capture the same lead data independently.
- How are membership registration forms handled?
- Membership area registration forms in ClickFunnels work like any other form. LeadToSheet captures the registration fields (name, email, password placeholder) and syncs them to Sheets. Sensitive password fields are excluded from capture by default.