Capture GemPages form data in Google Sheets
Sync form submissions from GemPages landing pages, popup elements, and sales funnels into Google Sheets for real-time lead tracking and conversion analysis.
CMS: Shopify
Overview
GemPages is a Shopify page builder with conversion-optimized templates, a mobile editor, and built-in popup and countdown timer elements. LeadToSheet captures form submissions from GemPages-built pages, including popup forms and sales funnel steps, writing them to Google Sheets so you can track leads from every page and funnel stage without manual data exports.
Implementation checklist
- 1
Install the SDK in theme.liquid
In your Shopify admin, go to Online Store > Themes > Edit Code and paste the LeadToSheet snippet into theme.liquid before the closing </head> tag.
theme.liquid snippet
<script src="https://cdn.leadtosheet.com/sdk.min.js" data-client="YOUR_CLIENT_KEY"></script> - 2
Publish and submit test forms
GemPages forms only function on published pages. Publish your page, navigate to the live URL, and submit test data through each form element, including any popup or countdown-gated forms.
Tip: Use GemPages' mobile preview to verify form elements render correctly on mobile before testing with LeadToSheet.
- 3
Review funnel step data in Sheets
If you use GemPages sales funnels, verify that submissions from each funnel step appear as distinct rows with the step's page URL for attribution.
Customization ideas
Track sales funnel progression
GemPages supports multi-page sales funnels. LeadToSheet captures the page URL for each form submission, letting you build a funnel progression report in Sheets that shows where leads drop off or convert.
Capture popup form leads separately
GemPages includes a popup builder within its page editor. Use LeadToSheet's routing rules to send popup form submissions to a different tab than inline form submissions from the same page.
Monitor countdown timer campaigns
GemPages countdown timers create urgency. LeadToSheet records the submission timestamp so you can analyze whether leads who submit during the countdown window have higher conversion rates.
Troubleshooting
GemPages editor preview does not capture forms
GemPages' drag-and-drop editor renders pages in an iframe that does not load theme.liquid scripts. This is expected. Always test captures on the live published URL.
Popup forms within GemPages pages not detected
GemPages popup elements inject into the page DOM when triggered. LeadToSheet's observer detects these injections, but if the popup uses a custom rendering method, ensure it produces a standard HTML form element.
Mobile-optimized forms submit differently
GemPages' mobile editor can produce different form layouts for mobile devices. LeadToSheet captures submissions from both desktop and mobile layouts, but verify that the mobile form element retains the same field names as the desktop version.
Resources
Frequently asked questions
- Does LeadToSheet capture forms from GemPages' pre-built templates?
- Yes. Regardless of whether you start from a GemPages template or build from scratch, the published form renders as standard HTML that LeadToSheet can capture.
- Can I track which funnel step generated a lead?
- LeadToSheet records the page URL for each submission. In a multi-step GemPages funnel, each step has a unique URL, so you can identify which step captured the lead.
- What if I use GemPages on multiple Shopify stores?
- Install the LeadToSheet SDK on each store's theme.liquid with a unique client key. You can route all stores to the same Google Sheet with store-specific tabs, or use separate sheets per store.