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, file uploads, and email routing with built-in form analytics. LeadToSheet extends EVM Forms by syncing every 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 src="https://cdn.leadtosheet.com/sdk.min.js" data-client="YOUR_CLIENT_KEY"></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 references missing
EVM Forms processes uploads server-side. LeadToSheet captures the file field value at submission time. If the field value is empty at that moment because the upload is asynchronous, enable the deferred capture option in your LeadToSheet dashboard.
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?
- LeadToSheet records the file URL or reference from the form submission. The actual file remains stored in EVM Forms' infrastructure. Your sheet gets a clickable link to access the file.
- 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.