Sync SureCust forms to Google Sheets
SureCust combines form building with content locking for registration, wholesale applications, and gated content on Shopify. LeadToSheet captures every form submission and writes it to Google Sheets for centralized lead management.
CMS: Shopify
Overview
SureCust Forms Builder & Locks is a Shopify app that combines form creation with content locking. Merchants use it for wholesale application forms, customer registration gates, and content access controls. LeadToSheet captures every form submission from SureCust's gated workflows and writes the data to Google Sheets, providing an audit trail and reporting layer for access requests that SureCust's admin does not export natively.
Implementation checklist
- 1
Add the LeadToSheet SDK to theme.liquid
Open Online Store > Themes > Edit code. Place the script in theme.liquid before </body>. SureCust renders its forms directly in the storefront DOM, including those used for content lock gates.
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
Configure a content lock with a registration form
Set up a SureCust content lock on a collection or product page and attach a registration form as the gate. Visitors must complete the form to access the locked content, and LeadToSheet captures that submission.
Tip: Use the page URL in your Google Sheet to identify which locked content page generated each registration, so you can measure demand per gated resource.
- 3
Test the full gated content workflow
Visit a locked page as a guest, fill out the SureCust form, and verify that the content unlocks and the submission appears in your Google Sheet. Check that the sheet row includes the locked page URL and all form fields.
Customization ideas
Build a wholesale application approval tracker
When wholesale buyers complete SureCust's application form, the submission lands in Google Sheets. Add approval status, reviewer name, and decision date columns. Use conditional formatting to highlight pending applications for fast review.
Measure gated content demand by page
LeadToSheet records the page URL for each form submission. For content-locked pages, analyze which products or collections generate the most access requests. Use this data to prioritize content creation or adjust pricing tiers.
Automate access grants with Apps Script
When a new SureCust registration row appears in Google Sheets, trigger an Apps Script function that uses the Shopify Admin API to tag the customer, granting them access to locked content programmatically.
Troubleshooting
Content lock form not detected by the SDK
SureCust renders gate forms inside the storefront page. If the SDK does not capture them, verify the script is in theme.liquid and that the form is not rendered inside a shadow DOM or external iframe. Standard SureCust installations use inline rendering.
Submissions captured but content not unlocking
Content unlocking is managed entirely by SureCust's server-side logic. LeadToSheet captures the browser event but has no role in the lock/unlock process. If content is not unlocking, check SureCust's lock configuration and conditions.
Wholesale application fields creating too many columns
If wholesale forms have many optional fields, the sheet may accumulate sparse columns. Use Google Sheets filters or configure a dedicated tab for wholesale applications via the LeadToSheet dashboard's tab routing to keep the view manageable.
Frequently asked questions
- Does LeadToSheet capture submissions from content lock forms?
- Yes. SureCust's content lock forms are standard HTML forms rendered in the storefront. The LeadToSheet SDK captures them like any other form, recording all field values and the gated page URL.
- Can I tell which locked page generated a form submission?
- Yes. LeadToSheet records the full page URL with every submission. For gated content, this URL identifies exactly which locked product page, collection, or content page prompted the registration.
- Does LeadToSheet interact with SureCust's lock/unlock mechanism?
- No. LeadToSheet only captures form submission data. The content locking and unlocking behavior is entirely controlled by SureCust. The two systems operate independently.