Push FormCraft data to Google Sheets live
Pair LeadToSheet with FormCraft to stream popup, cover page, and inline form submissions into Google Sheets. Math field outputs and custom CSS forms are captured accurately.
CMS: WordPress
Overview
FormCraft is known for its popup forms, full-page cover forms, and per-form custom CSS styling. LeadToSheet adds a real-time data layer on top, capturing every submission variant (inline embed, triggered popup, or dedicated cover page) in a single, unified Google Sheet.
Implementation checklist
- 1
Add the SDK to your site footer
Place the LeadToSheet script tag in your theme's footer or use a header/footer injection plugin so it loads on every page where FormCraft forms appear.
LeadToSheet SDK snippet
<script async src="https://www.leadtosheet.com/api/sdk?k=YOUR_CLIENT_KEY"></script> - 2
Test each form display mode
FormCraft supports inline, popup, and cover page modes. Submit a test entry from each mode to verify that LeadToSheet captures all three correctly and creates the right columns.
Tip: Cover page forms use a full-page overlay. The SDK handles these identically to inline forms since the DOM structure is the same.
- 3
Verify math field output
If you use FormCraft's math fields for calculations like pricing or scoring, confirm the computed result appears in your sheet as a numeric value.
Customization ideas
Segment popup vs inline submissions
Add a visible read-only text field in each FormCraft form that identifies its display mode (popup, inline, cover). Use this value to filter or route entries. Note: hidden fields (input[type='hidden']) are excluded from capture.
Preserve custom CSS context
FormCraft lets you write custom CSS per form. While CSS does not affect data, you can add a visible read-only identifier field so sheet rows tie back to the specific styled variant. Hidden fields are excluded from capture.
Build price-quote dashboards
FormCraft math fields often power price calculators. With computed values landing in Sheets automatically, build dashboards that track average quote values and conversion rates.
Troubleshooting
Popup form not triggering capture
If your FormCraft popup is loaded lazily after page load, the SDK may need to re-scan the DOM. Ensure you are using the latest LeadToSheet SDK version, which includes a MutationObserver for dynamically injected forms.
Math fields returning empty values
FormCraft calculates math fields on the client before submission. If the value is blank in your sheet, the user likely skipped the input fields that feed the formula. Add validation rules to required fields.
Cover page forms 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 no other form-to-sheet plugin is active.
Resources
Frequently asked questions
- Does LeadToSheet work with FormCraft's conditional logic?
- Yes. Conditional fields are only included in the submission payload when they are visible, so your sheet only receives the data that the user actually provided.
- Can I capture submissions from FormCraft's shortcode embeds?
- FormCraft shortcodes render standard HTML forms. As long as the LeadToSheet SDK is on the page, shortcode-rendered forms are captured automatically.
- What happens when a user abandons a cover page form?
- No data is sent. LeadToSheet only captures completed submissions that pass FormCraft's validation. Partial entries from abandoned cover pages are not recorded.