Push Super Forms data into Google Sheets
Capture calculator outputs, popup entries, and WooCommerce order form data from Super Forms in a live Google Sheet. No Zapier, no manual exports, no missed leads.
CMS: WordPress
Overview
Super Forms packs calculator fields, conditional logic, multi-part layouts, popup triggers, WooCommerce product integration, and frontend listing capabilities into a single plugin. LeadToSheet captures this rich data set in Google Sheets, making it straightforward for teams to analyse calculated quotes, track WooCommerce-linked submissions, and monitor popup form performance from a familiar spreadsheet interface.
Implementation checklist
- 1
Install the LeadToSheet SDK
Add the script to your WordPress footer. Super Forms renders forms with standard HTML markup, and the SDK attaches to submission events automatically.
LeadToSheet SDK snippet
<script async src="https://www.leadtosheet.com/api/sdk?k=YOUR_CLIENT_KEY"></script> - 2
Test a calculator form end-to-end
Super Forms' calculator fields compute values on the fly. Fill out a form that uses calculations, submit it, and confirm both the input values and the computed result appear in your sheet.
Tip: Calculator field results are submitted as numeric values. Google Sheets will recognise them for SUM, AVERAGE, and other numeric functions.
- 3
Trigger a popup form submission
If you use Super Forms' popup trigger, open the popup, complete the form, and verify the entry lands in your sheet. Popup forms behave identically to inline forms for data capture.
Customization ideas
WooCommerce order tracking in Sheets
Super Forms can create WooCommerce orders from form submissions. LeadToSheet captures the form data including product selections, giving you a sheet-based order tracker alongside WooCommerce's admin panel.
Calculator-powered quote pipeline
With calculator outputs syncing as numbers, build a Sheets dashboard that tracks quote volumes, average deal sizes, and conversion rates across all your Super Forms calculator forms.
Frontend listing audit trail
Super Forms supports frontend form listings. Use LeadToSheet to maintain a parallel audit trail in Sheets that is easier to search, filter, and share than the WordPress frontend display.
Troubleshooting
Calculator values not matching expected output
Super Forms calculates values client-side before submission. If the sheet value differs from what you expected, check the calculator field formula in the Super Forms editor. Rounding and order-of-operations issues are the most common causes.
Popup form creating duplicate entries
The SDK includes a 2-second de-duplication window that prevents identical submissions from being captured twice in rapid succession. If duplicate rows still appear, check that your popup trigger does not reload the form HTML or that no other form capture plugin is active.
WooCommerce fields not appearing in sheet
Super Forms sends WooCommerce product data in a structured format. If product fields show as empty, confirm the WooCommerce add-on is activated and the product field is configured correctly in the Super Forms editor.
Resources
Frequently asked questions
- Does LeadToSheet capture Super Forms' conditional logic paths?
- Yes. Only fields visible at submission time are included in the payload. Hidden conditional fields are excluded, keeping your sheet focused on data the user actually provided.
- Can I track which popup triggered the submission?
- Add a visible read-only field in each popup form that identifies the trigger (e.g., 'exit_intent', 'scroll_50'). Hidden fields (input[type='hidden']) are excluded from capture. This value syncs to Sheets and lets you measure popup performance by trigger type.
- How are multi-part form entries handled?
- Super Forms multi-part layouts collect data across sections but submit everything at once. LeadToSheet captures the complete payload as a single sheet row with all parts included.
