Send EM Forms Builder data to Google Sheets
EM Forms Builder keeps things simple on your Shopify store. Add LeadToSheet to back up every submission in Google Sheets for reporting, follow-ups, and automation without adding complexity.
CMS: Shopify
Overview
EM Forms Builder is a lightweight Shopify form app that handles basic field types and email notifications. LeadToSheet adds a persistent, searchable record of every submission in Google Sheets, so your team can filter, sort, and export leads without logging into the Shopify admin panel.
Implementation checklist
- 1
Add the LeadToSheet SDK to theme.liquid
Navigate to Online Store > Themes > Edit code. Open theme.liquid and paste the SDK snippet before the closing </body> tag to capture forms on every page.
LeadToSheet SDK snippet
<script src="https://cdn.leadtosheet.com/sdk.min.js" data-client="YOUR_CLIENT_KEY"></script> - 2
Submit a test form through EM Forms Builder
Fill out your EM Forms Builder form on the storefront and check your Google Sheet for the new row. Verify all fields, including any dropdowns or checkboxes, appear as columns.
Tip: Fill every field to ensure all column headers are created on the first submission.
- 3
Confirm email notifications still fire
LeadToSheet operates alongside EM Forms Builder's email notifications. Verify that both the email and the sheet row are generated after your test submission.
Customization ideas
Create a simple lead pipeline in Sheets
Add a status column to your Google Sheet and use data validation dropdowns (New, Contacted, Converted) to build a lightweight CRM directly from EM Forms Builder submissions.
Capture page context for product-specific forms
LeadToSheet records the storefront page URL with each submission. If you place EM Forms on product pages, you can filter submissions by product to see which items generate the most enquiries.
Trigger Slack alerts on new leads
Use Google Apps Script to post a Slack message whenever a new row appears in your EM Forms sheet tab, ensuring your sales team responds within minutes.
Troubleshooting
SDK not detecting EM Forms Builder submissions
EM Forms Builder renders forms within the Shopify theme DOM. Ensure the SDK snippet is in theme.liquid and not inside a section file that only loads on specific pages. Check the browser console for the LeadToSheet initialization message.
Missing fields in the Google Sheet
If EM Forms Builder uses generic field names like field_1, field_2, rename them in the app settings to descriptive names like email and phone. LeadToSheet uses the field name attributes as column headers.
Form appears but submissions do not sync
Confirm your Shopify theme is published (not in preview mode). Draft themes do not serve the SDK to live visitors. Also check that no JavaScript errors from other apps are blocking execution.
Frequently asked questions
- Does LeadToSheet replace EM Forms Builder's email notifications?
- No. LeadToSheet runs alongside the app's built-in email notifications. You get both: an email to your inbox and a row in Google Sheets.
- Can I use LeadToSheet with EM Forms Builder on Shopify Basic?
- Yes. LeadToSheet works at the browser level and has no Shopify plan requirements. It functions on Basic, Shopify, Advanced, and Plus stores.
- How do I separate submissions from different EM Forms Builder forms?
- LeadToSheet records the page URL and form identifier with each submission. You can filter your sheet by these columns or use `data-leadtosheet-tab` attributes to route different forms to separate tabs.