Capture Jotform on Shopify in Google Sheets
Jotform's 10,000+ templates with payment forms, HIPAA compliance, and approval workflows embed on your Shopify store. Use the builder's native Google Sheets integration or an external automation flow to capture every submission and deliver it to Google Sheets.
CMS: Shopify
Overview
Jotform Embed brings enterprise-grade forms to Shopify storefronts with 10,000+ templates, payment collection, conditional logic, and optional HIPAA compliance. Because Jotform renders in an iframe from jotform.com, the SDK cannot capture submissions across the cross-origin boundary. An external automation fallback ensures every submission reaches your Google Sheet with full Shopify page context and attribution data.
Implementation checklist
- 1
Install the LeadToSheet SDK in theme.liquid
Open Online Store > Themes > Edit code. Add the SDK snippet to theme.liquid before </body>. The SDK loads on the parent Shopify page to capture UTM parameters and referrer data. For Jotform submission data, configure Jotform's webhook integration to send data to your external automation endpoint, since the SDK cannot access the cross-origin Jotform iframe.
LeadToSheet SDK snippet
<script async src="https://www.leadtosheet.com/api/sdk?k=YOUR_CLIENT_KEY"></script> - 2
Configure the Jotform external automation fallback
Since Jotform renders in a cross-origin iframe, the SDK cannot capture submissions directly. Add the external automation URL in Jotform's Settings > Integrations > Webhooks to guarantee capture regardless of browser cross-origin policies.
Tip: The webhook approach is the most reliable method for Jotform embeds and works regardless of browser security settings.
- 3
Test with a payment form and a standard form
Submit test entries through both a payment-enabled Jotform and a standard contact form on your Shopify store. Verify that payment fields and standard fields both appear in your Google Sheet.
Customization ideas
Track payment form submissions alongside Shopify orders
Jotform payment forms capture transaction details. Use your Google Sheet to cross-reference Jotform payment submissions with Shopify order data by matching customer email or order amount.
Build approval workflow dashboards in Sheets
If you use Jotform's approval workflows, LeadToSheet captures the initial submission. Pair it with Jotform webhook updates to track approval status changes in your Google Sheet for a complete workflow view.
Segment conditional logic responses
Jotform conditional logic determines which fields visitors see. LeadToSheet captures the submitted fields, letting you build segments in Sheets based on which questions were answered, indicating the path each visitor took.
Troubleshooting
Jotform iframe blocked by cross-origin policy
Jotform loads from jotform.com inside an iframe on your Shopify domain, so the SDK cannot capture submissions across the cross-origin boundary. Add the external automation URL in Jotform's webhook settings to reliably capture every submission.
HIPAA form data handling concerns
If you use Jotform's HIPAA compliance tier, review whether syncing submission data to Google Sheets meets your compliance requirements. LeadToSheet captures what the form submits. Ensure your Google Workspace meets HIPAA standards if applicable.
Payment form fields missing from the sheet
Jotform processes payments through a separate gateway integration. The payment status and amount fields are included in the form submission payload, but sensitive card details are not. If payment fields are missing, use the Jotform webhook to capture the full payload.
Frequently asked questions
- Does LeadToSheet capture Jotform submissions with HIPAA compliance?
- LeadToSheet captures the form data as submitted. If you require HIPAA compliance, ensure your Google Workspace account has a BAA (Business Associate Agreement) in place, as the data will reside in Google Sheets.
- Can I use Jotform's 10,000+ templates and still capture in Sheets?
- Yes. LeadToSheet is template-agnostic. Any Jotform template embedded on your Shopify store will have its submissions captured, regardless of field types, conditional logic, or payment integrations.
- How do Jotform approval workflows interact with LeadToSheet?
- LeadToSheet captures the initial form submission. Approval status changes happen inside Jotform. To track approvals, configure Jotform's webhook to also send status updates to your external automation endpoint.