Sync Contact Form Master to Google Sheets
Contact Form Master handles custom fields and department routing on Shopify. LeadToSheet adds a persistent Google Sheets record of every text field submission so your team can track, filter, and automate follow-ups.
CMS: Shopify
Overview
Contact Form Master provides Shopify merchants with custom contact forms featuring department routing and auto-reply emails. LeadToSheet captures every text field submission in Google Sheets alongside the department selection and page context, creating a searchable archive that goes beyond the app's built-in submission dashboard.
Implementation checklist
- 1
Install the LeadToSheet SDK in theme.liquid
Open Online Store > Themes > Edit code. Add the SDK snippet to theme.liquid before the closing </body> tag. This covers all pages where Contact Form Master forms are placed.
LeadToSheet SDK snippet
<script async src="https://www.leadtosheet.com/api/sdk?k=YOUR_CLIENT_KEY"></script> - 2
Submit test entries for each department routing option
If Contact Form Master routes to different departments, submit a test for each department option. This creates column headers for all routing fields and verifies department data flows to your sheet.
Tip: Test each department routing option to confirm all routing fields appear as columns in your sheet.
- 3
Verify auto-reply emails still send
Contact Form Master's auto-reply feature works independently of LeadToSheet. Confirm that test submissions trigger both the auto-reply email and a new row in your Google Sheet.
Customization ideas
Route departments to separate sheet tabs
Use LeadToSheet dashboard routing rules to send Sales enquiries, Support tickets, and Partnership requests to separate Google Sheet tabs for team-specific views.
Build a response time tracker
Add a response_date column to your sheet and track time-to-first-response by comparing the LeadToSheet submission timestamp with your team's response timestamp.
Archive department routing data
LeadToSheet captures the department selection from Contact Form Master alongside all text fields. Use filtered views in your sheet for quick access to department-specific submissions without logging into Shopify admin.
Troubleshooting
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 Contact Form Master. Access uploaded files through the Contact Form Master dashboard instead.
Department routing field not captured
Ensure the department dropdown or radio field in Contact Form Master has a descriptive name attribute (like department) rather than a generic one. LeadToSheet uses field name attributes to create column headers.
SDK conflicts with Contact Form Master app embed
If Contact Form Master uses a Shopify app embed block, place the LeadToSheet SDK snippet after the app embed scripts in theme.liquid. This ensures the form is rendered before LeadToSheet attempts to listen for submissions.
Frequently asked questions
- Does LeadToSheet replace Contact Form Master's submission dashboard?
- No. Think of it as a complementary layer. Contact Form Master's dashboard handles in-app viewing, while your Google Sheet provides filtering, exports, formulas, and automation triggers that the dashboard cannot.
- Can I capture Contact Form Master submissions from multiple Shopify stores in one sheet?
- Yes. Each store uses its own LeadToSheet client key, but you can configure multiple keys to write to the same Google Sheet with a store identifier column for filtering.
- Will the auto-reply emails from Contact Form Master be affected?
- Not at all. LeadToSheet captures the form submission at the browser level without modifying the data flow to Contact Form Master's server-side auto-reply system.