Sync Typeform on Shopify to Google Sheets
Typeform's one-question-at-a-time experience embedded on your Shopify store creates engaging surveys and quizzes. LeadToSheet captures every response with hidden Shopify customer data and delivers it to Google Sheets in real time.
CMS: Shopify
Overview
Typeform Embed renders conversational forms inside an iframe on your Shopify storefront. LeadToSheet listens for Typeform's completion event and captures responses, hidden fields pre-filled with Shopify customer data, and quiz scores. This replaces Typeform's limited native Sheets connector with a solution that includes storefront attribution and device context.
Implementation checklist
- 1
Add the LeadToSheet SDK to theme.liquid
Go to Online Store > Themes > Edit code. Paste the SDK snippet into theme.liquid before </body>. The SDK needs to load on the parent Shopify page to listen for Typeform's embed events.
LeadToSheet SDK snippet
<script src="https://cdn.leadtosheet.com/sdk.min.js" data-client="YOUR_CLIENT_KEY"></script> - 2
Configure hidden fields with Shopify customer data
In Typeform's form builder, add hidden fields for customer_id, customer_email, or product_handle. Populate them via the Typeform embed URL using Liquid variables from your Shopify theme to link responses to specific customers or products.
Tip: Example embed URL: https://yourform.typeform.com/to/abc123#customer_id={{customer.id}}&product={{product.handle}}
- 3
Submit a test response and verify the sheet
Complete the Typeform on your Shopify storefront and check that the response, hidden fields, and Shopify page URL all appear as columns in your Google Sheet.
Customization ideas
Score quiz responses for product recommendations
If you use Typeform quizzes to recommend products, LeadToSheet captures the calculated score and individual answers. Use Apps Script to match scores to product SKUs and generate personalized follow-up emails.
Segment survey responses by Shopify customer
Hidden fields populated with Shopify customer IDs let you join Typeform responses with your Shopify customer data in Google Sheets, enabling cohort analysis and customer satisfaction tracking.
Track which storefront pages drive completions
LeadToSheet records the Shopify page URL where the Typeform embed was completed. Build a pivot table to see which product pages, blog posts, or landing pages generate the most Typeform responses.
Troubleshooting
Typeform iframe cross-origin issues
Typeform embeds load from typeform.com inside an iframe. LeadToSheet listens for Typeform's JavaScript SDK events (onSubmit) on the parent page. Ensure you are using Typeform's standard embed code (not a raw iframe tag) so the SDK events fire correctly.
Hidden fields not appearing in the sheet
Hidden fields must be defined in Typeform's form builder AND passed via the embed URL. If the Liquid variables in your Shopify theme are not resolving, check that the embed is placed in a context where {{ customer.id }} is available (the customer must be logged in).
Partial completions not captured
Typeform's onSubmit event fires only on full completion. Partial responses are not sent to LeadToSheet. If you need partial data, configure Typeform's webhooks to send intermediate responses to the LeadToSheet webhook endpoint.
Frequently asked questions
- Does LeadToSheet replace Typeform's native Google Sheets integration?
- It can. LeadToSheet captures the same response data plus storefront context (page URL, referrer, UTM parameters, device info) that Typeform's native connector does not include. Most merchants disable the native connector to avoid duplicate rows.
- Can I pass Shopify product data into Typeform hidden fields?
- Yes. Use Liquid variables in your theme template to populate the Typeform embed URL with product handles, variant IDs, collection names, or customer tags. LeadToSheet captures these hidden fields as sheet columns.
- How are Typeform quiz scores handled in Google Sheets?
- Typeform calculated fields and score variables are captured as standard field values. They appear as columns in your Google Sheet where you can apply formulas, filters, or conditional formatting.