Connect Bit Form to Google Sheets instantly
Bit Form delivers lightweight, jQuery-free forms with 200+ integrations. Add LeadToSheet for zero-config Google Sheets sync that preserves your site's frontend performance.
CMS: WordPress
Overview
Bit Form prioritises frontend performance: no jQuery dependency, minimal CSS, and modern JavaScript. LeadToSheet matches this philosophy with an async, lightweight SDK that adds negligible overhead. Together, they give you a fast form experience with real-time data flowing to Google Sheets without the complexity of configuring one of Bit Form's 200+ native integrations.
Implementation checklist
- 1
Embed the LeadToSheet SDK
Add the script to your site footer. Because Bit Form renders clean, dependency-free markup, the SDK attaches to standard form events without conflicts.
LeadToSheet SDK 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
Confirm field name mapping
Bit Form uses auto-generated field identifiers like `bf_field_1`. Rename them in Bit Form's field settings to descriptive names (e.g. `email`, `company`) so your sheet columns are immediately readable.
Tip: Bit Form lets you set custom field keys in the field settings panel under 'Admin Label'.
- 3
Run a conditional logic test
Submit entries that trigger different conditional branches to confirm all field combinations create the correct sheet columns.
Customization ideas
Skip the native Google Sheets integration
Bit Form offers its own Sheets connector, but it requires manual mapping for each form. LeadToSheet captures all forms globally with a single script, removing per-form configuration overhead.
Style forms with custom CSS, sync with zero changes
Bit Form's custom CSS capabilities let you create branded forms. LeadToSheet ignores styling and captures only the data layer, so design changes never break your sheet sync.
Multi-step progress tracking
For Bit Form multi-step forms, add visible read-only fields to track which step a user reached. Hidden fields (input[type='hidden']) are excluded from capture. If they complete the form, all step data plus the progress marker land in Sheets together.
Troubleshooting
Field names appearing as cryptic IDs
Bit Form's default field identifiers are machine-generated. Open each form in the Bit Form editor and set a descriptive 'Admin Label' or 'Field Key' for every field to get clean column headers.
Conditional fields not syncing
Bit Form removes hidden conditional fields from the DOM entirely. Fields that never become visible during a session will not be submitted. Ensure test submissions trigger every conditional path.
Conflict with Bit Form's native integrations
If you have Bit Form's built-in Google Sheets integration active alongside LeadToSheet, you may see duplicate rows. Disable the native integration if you want LeadToSheet to handle all sheet syncing.
Resources
Frequently asked questions
- Does Bit Form's lightweight output affect LeadToSheet compatibility?
- Not at all. Bit Form renders standard HTML form elements. LeadToSheet hooks into native submit events, so the absence of jQuery or heavy frameworks is actually beneficial for performance.
- Can I use both Bit Form's native integrations and LeadToSheet?
- You can, but we recommend choosing one path for Google Sheets to avoid duplicates. LeadToSheet handles attribution and UTM tracking automatically, which Bit Form's native connector does not.
- How does LeadToSheet handle Bit Form's multi-step forms?
- LeadToSheet captures the complete submission only after the final step. All field data from every step is combined into a single sheet row.