Sync Jotform submissions to Google Sheets instantly
Jotform powers over 10,000 form templates with payments, HIPAA compliance, and approval workflows. Add LeadToSheet alongside your Jotform embed to capture every submission with full UTM attribution and device context in Google Sheets.
CMS: Embed
Overview
Jotform is the most popular free form builder, offering thousands of templates, conditional logic, payment collection, and PDF generation. While Jotform has a native Google Sheets integration, it lacks UTM capture, referrer tracking, and consistent column formatting across forms. LeadToSheet handles this by capturing submissions at the browser level, giving you marketing attribution data and a unified sheet schema regardless of which Jotform template you use.
Implementation checklist
- 1
Add the LeadToSheet SDK to your page
Paste the script tag into the page that hosts your Jotform embed. If you use Jotform's JS embed method, the form renders in the DOM and LeadToSheet captures it natively. For iframe embeds, use the webhook fallback described below.
LeadToSheet snippet
<script src="https://cdn.leadtosheet.com/sdk.min.js" data-client="YOUR_CLIENT_KEY"></script> - 2
Choose your embed method wisely
Jotform offers iframe embed and JS embed options. The JS embed (also called 'source code' embed) renders the form directly in your page DOM, allowing LeadToSheet to capture fields natively. If you must use the iframe embed, configure Jotform's webhook integration to send submissions to your LeadToSheet webhook endpoint as a fallback.
Tip: Select 'Source Code' embed in Jotform's Publish tab for the best LeadToSheet compatibility.
- 3
Submit a test entry and verify columns
Fill out every field in your form including conditional branches, then check your Google Sheet. Confirm that field names, payment details, and UTM parameters all appear as expected.
Customization ideas
Capture payment transaction data
Jotform supports PayPal, Stripe, Square, and more. When using the JS embed, LeadToSheet captures transaction confirmation fields alongside form data, giving you a single sheet row with both lead info and payment status.
Route approval workflows to separate tabs
Use data-leadtosheet-tab attributes to send different Jotform templates to distinct sheet tabs, keeping approval-required submissions separate from instant-capture forms.
Leverage Jotform PDF generation with sheet links
After Jotform generates a PDF for a submission, use Apps Script on your Google Sheet to append the PDF download URL to the corresponding row for a complete lead record.
Troubleshooting
Iframe embed not capturing submissions
Jotform iframe embeds enforce cross-origin restrictions that prevent direct DOM access. Switch to the JS/source-code embed method, or add your LeadToSheet webhook URL in Jotform Settings > Integrations > Webhooks as a server-side fallback.
Conditional logic fields missing from sheet
Fields hidden by conditional logic may not appear if the test submission did not trigger them. Submit test entries that activate every conditional branch so all column headers are created during initial setup.
Duplicate rows from native Jotform Sheets integration
If you run both Jotform's built-in Google Sheets connector and LeadToSheet, you may see duplicate rows. Disable the native connector in Jotform's integration settings and let LeadToSheet handle the sync exclusively.
Frequently asked questions
- Does LeadToSheet work with Jotform's HIPAA-compliant forms?
- LeadToSheet captures the browser-side submission payload. For HIPAA workflows, ensure your Google Sheet access controls and sharing settings also meet compliance requirements. The SDK does not store data on its own servers beyond the sync to Sheets.
- Can I capture Jotform file uploads in Google Sheets?
- File uploads are hosted on Jotform's servers. LeadToSheet records the file URL in your Google Sheet so you can access uploads directly from the spreadsheet row.
- Why use LeadToSheet instead of Jotform's native Sheets integration?
- Jotform's native connector does not capture UTM parameters, referrer data, or device context. LeadToSheet adds marketing attribution columns automatically and gives you a consistent schema across all your forms, including those outside Jotform.