Pipe WS Form submissions into Google Sheets
Capture data from WS Form's 120+ field types, calculated fields, and repeatable sections in Google Sheets - with the developer-grade control WS Form users expect.
CMS: WordPress
Overview
WS Form is a developer-oriented form framework with 120+ field types, conditional logic, calculated fields, repeatable sections, and native support for Bootstrap and Foundation CSS frameworks. It gives developers granular control over form behaviour, but exporting data to Google Sheets typically requires custom API work. LeadToSheet provides that bridge automatically, capturing every field type - including repeatable sections and calculated values - without writing a line of server-side code.
Implementation checklist
- 1
Add the LeadToSheet SDK to your WordPress installation
WS Form users often work directly with theme code. Add the script tag to your theme's footer.php or use WS Form's custom JavaScript action to inject it. The SDK is framework-agnostic and will not conflict with Bootstrap or Foundation classes.
LeadToSheet snippet
<script async src="https://www.leadtosheet.com/api/sdk?k=YOUR_CLIENT_KEY"></script> - 2
Review the field meta for complex field types
WS Form's 120+ field types include colour pickers, legal checkboxes, and more. Open the form builder, check the Field Name setting for each field, and ensure complex types submit a serialisable value that will make sense as a Google Sheet cell. Note that LeadToSheet only captures text-based form fields - file uploads and hidden fields are not captured.
Tip: Signature fields may submit as base64 data URIs, but this behaviour is fragile and varies by configuration. For reliable signature handling, use a WS Form action to save signatures as files and log them via a server-side webhook. Hidden fields are excluded by LeadToSheet.
- 3
Submit a form with repeatable sections filled
If your form uses WS Form's repeatable sections, add at least two repetitions in your test submission. LeadToSheet indexes each repetition (e.g., "line_item_1_product", "line_item_2_product") to create predictable column structures.
Customization ideas
Handle repeatable sections with structured columns
WS Form's repeatable sections are a power feature for order forms and multi-line entries. LeadToSheet creates indexed columns for each repetition, giving you a flat spreadsheet representation of nested data that is easy to filter and pivot.
Leverage Bootstrap/Foundation CSS class data
WS Form's framework-aware rendering means forms look native on your site. While CSS classes do not affect submitted data, the SDK auto-identifies each form via fingerprinting. Map each form to its own Google Sheet in the LeadToSheet dashboard for per-form routing without touching your theme code.
Sync calculated field results for quoting tools
WS Form's calculated fields power product configurators and quoting tools. LeadToSheet captures the final calculated values so your Google Sheet becomes a live record of every quote generated, ready for sales follow-up.
Troubleshooting
Complex field types producing unreadable data in Sheets
Fields like colour pickers submit hex values (#FF5733), which LeadToSheet captures as plain text. Signature fields may submit as base64 strings in some configurations, but this is fragile and should not be relied upon. For signatures, use WS Form actions to save them as files and log them via a server-side integration. For other complex data, use Apps Script post-processing in Sheets to convert values to human-readable formats.
Repeatable sections creating too many columns
If users can add unlimited repetitions, your sheet may grow very wide. Set a maximum repetition count in the WS Form builder to keep column structures manageable. Alternatively, configure LeadToSheet to concatenate repetitions into a single JSON cell via the dashboard settings.
WS Form debug console warnings about event listeners
WS Form's debug mode may log warnings about third-party event listeners. These are informational and do not affect functionality. LeadToSheet uses standard DOM event listeners that WS Form's architecture supports fully.
Resources
Frequently asked questions
- Does LeadToSheet support all 120+ WS Form field types?
- LeadToSheet captures any field that submits a value via standard HTML form submission or AJAX. This covers virtually all WS Form field types. Non-input decorative fields (like HTML blocks or dividers) are naturally excluded since they carry no data.
- Can I use WS Form's conditional logic with LeadToSheet?
- Yes. Conditional logic hides or shows fields in the browser. LeadToSheet captures whatever fields are present and populated at the moment of submission, so conditional branches are respected automatically.
- How does LeadToSheet handle WS Form's framework-specific rendering?
- LeadToSheet reads input values from the DOM regardless of CSS framework. Whether your form uses Bootstrap 5, Foundation 6, or no framework at all, the captured data is identical.