Push EVM Forms submissions to Google Sheets
EVM Forms brings custom fields, conditional logic, and email routing to Shopify. LeadToSheet adds a Google Sheets layer for analytics, lead scoring, and automation that EVM's built-in tools do not cover.
CMS: Shopify
Overview
EVM Forms is a Shopify form builder focused on custom fields, conditional logic, and email routing with built-in form analytics. LeadToSheet extends EVM Forms by syncing every text field submission to Google Sheets, where your team can build dashboards, apply lead scoring formulas, and trigger workflows that go beyond EVM's native analytics.
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>. This ensures capture on all pages where EVM Forms may be embedded.
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
Submit test entries that cover every conditional branch
EVM Forms conditional logic shows and hides fields dynamically. Submit multiple test entries with different selections to ensure all possible fields are registered as column headers in your Google Sheet.
Tip: Document which conditional paths exist so you can verify complete coverage in your sheet.
- 3
Check email routing alongside sheet capture
Verify that EVM Forms still routes emails to the correct department recipients while LeadToSheet simultaneously writes the submission to your Google Sheet. Both systems operate independently.
Customization ideas
Build conversion funnels from form analytics
Combine EVM Forms' built-in analytics with your Google Sheet data to track which conditional paths correlate with higher conversion rates, using the sheet for custom pivot tables and charting.
Score leads based on conditional field responses
Since LeadToSheet captures which conditional fields were completed, use Apps Script to assign lead scores based on the depth and quality of responses. Prospects who fill more fields get higher scores.
Route submissions by email department in Sheets
If EVM Forms routes emails to Sales vs Support, capture the routing field in your sheet and use it to create separate views or tabs for each team's leads.
Troubleshooting
Conditional fields not appearing in the sheet
Fields hidden by EVM Forms conditional logic are not submitted by the browser. Submit test entries that trigger each conditional branch to create all column headers. This is expected browser behavior, not a bug.
EVM Forms app block interfering with SDK
If EVM Forms uses a Shopify app block that manipulates the DOM after page load, the LeadToSheet SDK may need to detect the form dynamically. Place the SDK snippet at the bottom of theme.liquid and verify it initializes after the app block renders.
File upload fields not captured
LeadToSheet captures text field values from form submissions but does not capture file uploads. File upload data is handled server-side by EVM Forms. Access uploaded files through the EVM Forms dashboard instead.
Frequently asked questions
- How does LeadToSheet compare to EVM Forms' built-in analytics?
- EVM Forms analytics show aggregate form performance. LeadToSheet gives you row-level submission data in Google Sheets where you can apply custom formulas, pivot tables, and integrations that EVM's dashboard does not support.
- Can I use LeadToSheet to capture EVM Forms file uploads?
- No. LeadToSheet captures text field values from form submissions but does not capture file uploads. Files are handled by EVM Forms' own infrastructure. Access uploaded files through the EVM Forms dashboard.
- Does conditional logic affect what data reaches my Google Sheet?
- Yes. Only fields visible to the user at submission time are included in the form payload. Hidden conditional fields are not submitted by the browser, so they will not appear in that row.