Sync ClickFunnels leads to Google Sheets
Capture form submissions from every funnel step - opt-in pages, order forms, upsells, and membership registrations - in a single Google Sheet with full UTM attribution for funnel-wide ad performance reporting.
CMS: Landing page
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 async src="https://www.leadtosheet.com/api/sdk?k=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
Each ClickFunnels step has a distinct page URL. LeadToSheet captures the page URL with each submission, so you can identify the step name (e.g., 'optin', 'order', 'upsell_1', 'downsell_1') from the URL and 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 visible read-only 'offer_type' field (hidden fields are excluded from capture), 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, UTM parameters are captured automatically by the SDK from the page URL. There is no need to add hidden fields for UTM data.
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 visible read-only 'funnel_step' field to distinguish opt-in, order, upsell, and downsell entries. Hidden fields (input[type='hidden']) are excluded from capture.
- 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.