Export ECF Contact Form data to Google Sheets
ECF: Contact Form Builder handles multiple form types, conditional fields, and autoresponders on Shopify. Add LeadToSheet to export every text-based submission to Google Sheets with campaign attribution.
CMS: Shopify
Overview
ECF (Easy Contact Form) is a Shopify form builder that supports multiple form types, conditional field logic, autoresponders, and CSV submission export. LeadToSheet replaces the manual CSV export with an automatic, real-time Google Sheets pipeline that includes UTM tracking and referrer data for every text-based entry. Note that file upload fields are not captured by the SDK.
Implementation checklist
- 1
Add the LeadToSheet SDK to theme.liquid
Navigate to Online Store > Themes > Edit code. Paste the snippet in theme.liquid before </body>. The SDK picks up ECF forms rendered on any storefront page.
theme.liquid 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
Create forms for each contact scenario
ECF supports multiple form types (contact, support, returns). Build each form type in the ECF admin and place them on the appropriate storefront pages. LeadToSheet captures all of them.
Tip: Use ECF's conditional fields to show different questions based on the selected form type, reducing the number of separate forms you need to manage.
- 3
Replace manual CSV exports with live sync
After verifying that LeadToSheet captures test submissions in Google Sheets, you can stop using ECF's built-in CSV export. The sheet updates automatically with every new submission.
Customization ideas
Retire CSV exports for real-time reporting
ECF's submission export feature requires manual downloads. LeadToSheet writes to Google Sheets in real time, so your team always has the latest data without logging into the Shopify admin or downloading files.
Pair autoresponders with sheet-based follow-up sequences
ECF's autoresponder sends an immediate reply. Use Apps Script on the Google Sheet to trigger a second follow-up email 24 hours later, creating a lightweight nurture sequence without additional email tools.
Consolidate multiple form types into a single dashboard
Route each ECF form type to a different Google Sheet tab using the LeadToSheet dashboard's tab routing settings. Then create a summary tab with IMPORTRANGE formulas that aggregates key metrics across all form types.
Troubleshooting
ECF forms not rendering on Online Store 2.0 themes
Some ECF embed methods require a specific Liquid snippet rather than an app block. Check ECF's documentation for the correct embed code for your theme version and paste it into the appropriate section template.
Conditional fields creating sparse columns in the sheet
When different visitors see different conditional fields, some columns will be empty for certain rows. This is expected behavior. Use Google Sheets filters to view only relevant columns per form scenario.
Autoresponder not triggering for test entries
ECF's autoresponder is independent of LeadToSheet. If autoresponder emails are not sending, check the ECF app settings for SMTP configuration and ensure the respondent email field is correctly mapped.
Frequently asked questions
- Can LeadToSheet replace ECF's built-in submission export?
- Yes. LeadToSheet provides automatic, real-time export to Google Sheets. You no longer need to log in and download CSV files from the ECF admin panel.
- Do I get more data in Google Sheets than in the ECF admin?
- Yes. LeadToSheet adds page URL, referrer, UTM parameters, device type, and browser information to every row. The ECF admin only shows the form field values.
- How do multiple form types appear in the sheet?
- Each submission includes the form identifier and page URL. You can filter by these columns or configure tab routing in the LeadToSheet dashboard to send different form types to separate tabs.