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 src="https://cdn.leadtosheet.com/sdk.min.js" data-client="YOUR_CLIENT_KEY"></script> - 2
Review the field meta for complex field types
WS Form's 120+ field types include signatures, colour pickers, and legal checkboxes. 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.
Tip: Signature fields submit as base64 data URIs. Consider using a WS Form action to save signatures as files and pass the file URL to a hidden field for a cleaner sheet experience.
- 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, you can use WS Form's custom attributes to add `data-leadtosheet-tab` 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), and signature fields submit base64 strings. Both are valid data but may not be useful as-is. Use WS Form actions to convert complex data to human-readable formats before submission, or use Apps Script post-processing in Sheets.
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.