Stream JetFormBuilder entries to Google Sheets
Capture Gutenberg-native form submissions from JetFormBuilder - including JetEngine custom post type data - directly into Google Sheets for centralised reporting.
CMS: WordPress
Overview
JetFormBuilder is built natively for the WordPress block editor (Gutenberg), letting you construct forms using blocks instead of a separate drag-and-drop interface. It integrates tightly with JetEngine for custom post types, custom queries, and dynamic content. While JetFormBuilder stores entries in the WordPress database and can trigger post-submission actions, exporting that data to external spreadsheets requires custom development. LeadToSheet handles this automatically, capturing every block-based form submission and syncing it to Google Sheets.
Implementation checklist
- 1
Add the LeadToSheet snippet to your block theme
Since JetFormBuilder is Gutenberg-native, your theme is likely a block theme. Add the snippet via a custom HTML block in your site footer template, or use a code injection plugin for broader compatibility.
LeadToSheet snippet
<script>(function(w,d,s,u,k,e){if(w.__formsync){return}w.__formsync={q:[],k:k,endpoint:e};var js=d.createElement(s);js.src=u;js.async=1;js.onload=function(){w.__formsync.init&&w.__formsync.init({ clientKey:k })};d.head.appendChild(js);})(window,document,'script','https://www.leadtosheet.com/sdk.min.js','YOUR_CLIENT_KEY','https://www.leadtosheet.com/api/ingest');</script> - 2
Map JetFormBuilder field names to sheet columns
In the block editor, select each JetFormBuilder field block and check the "Field Name" setting in the block sidebar. These names become your Google Sheet headers. Use descriptive, lowercase names for consistency.
Tip: JetFormBuilder fields default to names like "text_field" - rename them to meaningful identifiers like "project_budget" or "preferred_date" before your first real submission.
- 3
Test a form linked to JetEngine custom post types
If your form creates or updates JetEngine custom post types on submission, send a test entry and verify both the CPT creation and the Google Sheet row. LeadToSheet captures the form data independently of the JetEngine post action.
Customization ideas
Mirror JetEngine CPT data in Sheets
When JetFormBuilder creates custom post type entries via JetEngine, use LeadToSheet to maintain a parallel record in Google Sheets. This gives non-technical team members access to submission data without navigating custom admin panels.
Route different block forms to separate sheets
The SDK auto-identifies each JetFormBuilder form via fingerprinting. Map registration forms, booking forms, and contact forms to distinct Google Sheets in the LeadToSheet dashboard - no custom attributes needed.
Combine with JetEngine queries for enriched reporting
Pull additional data from JetEngine dynamic queries into visible read-only text fields. Hidden fields (input[type='hidden']) are excluded from capture, so use visible fields to ensure the enriched values appear in your sheet, giving your Google Sheet context from your custom database alongside the form submission.
Troubleshooting
Block editor form preview submissions not syncing
The Gutenberg block editor preview renders inside the WordPress admin and does not load front-end scripts. Always test by viewing the published page in a normal browser tab, not from the editor preview.
JetEngine Insert/Update Post action fields missing from Sheets
JetFormBuilder's post actions run server-side and may map fields differently than the front-end form. LeadToSheet captures the client-side form values, not the server-side action output. Ensure your form fields contain the data you want - do not rely on server-side field transformations for sheet content.
Repeater block entries creating unpredictable columns
JetFormBuilder's repeater block submits arrays of field groups. LeadToSheet flattens these into indexed columns (e.g., "item_1_name", "item_2_name"). To keep columns consistent, set a maximum repeater count in the block settings so the column structure is predictable.
Resources
Frequently asked questions
- Does LeadToSheet work with JetFormBuilder's AJAX form submission?
- Yes. JetFormBuilder uses AJAX by default, and LeadToSheet captures form data at the browser submit event, before the AJAX response returns. No additional configuration is needed.
- Can I capture forms built with JetFormBuilder inside JetEngine listings?
- Yes. When a JetFormBuilder form is embedded inside a JetEngine listing template, it renders as standard HTML on the page. LeadToSheet detects and captures it like any other form.
- What if I switch from JetFormBuilder to another form plugin later?
- LeadToSheet is plugin-agnostic. If you switch form builders, your existing Google Sheet data remains intact. You just need to ensure the new plugin's field names align with your existing column headers for continuity.