Send MyAppGurus forms to Google Sheets
MyAppGurus Form Builder offers drag-and-drop forms, popups, and Mailchimp integration for Shopify. LeadToSheet adds a real-time Google Sheets layer for lead tracking and automation beyond what Mailchimp alone provides.
CMS: Shopify
Overview
MyAppGurus Form Builder gives Shopify merchants drag-and-drop form creation with popup forms, conditional logic, and native Mailchimp integration. LeadToSheet captures every text field submission in Google Sheets, creating a parallel data record alongside Mailchimp that includes page context and UTM parameters your Mailchimp list cannot store.
Implementation checklist
- 1
Install the LeadToSheet SDK in theme.liquid
Open Online Store > Themes > Edit code. Paste the SDK snippet into theme.liquid before </body>. This ensures the SDK loads on every page, including those with popup forms that trigger on scroll or exit intent.
LeadToSheet SDK 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
Submit test entries through inline and popup forms
Test both an inline MyAppGurus form and a popup form on your storefront. Verify that submissions from both form types appear in your Google Sheet with the correct field names as column headers.
Tip: Trigger popup forms by meeting their display conditions (scroll depth, time delay, exit intent) to ensure the SDK captures them in real conditions.
- 3
Check Mailchimp sync alongside sheet capture
If you have Mailchimp integration enabled in MyAppGurus, verify that test submissions appear in both your Mailchimp list and your Google Sheet. Both integrations should work simultaneously without conflict.
Customization ideas
Track popup vs inline form performance
LeadToSheet records the page URL and form context with each submission. Use this data in your Google Sheet to compare conversion rates between popup and inline MyAppGurus forms without logging into the Shopify app dashboard.
Compare popup vs inline form conversion in Sheets
LeadToSheet records the page URL and form context with each submission. Use this data to build a pivot table comparing submission volume and quality between popup and inline MyAppGurus forms.
Supplement Mailchimp with attribution data
Mailchimp receives subscriber data from MyAppGurus but lacks page context and UTM parameters. Your Google Sheet fills this gap, letting you attribute each Mailchimp subscriber to the specific campaign or product page that converted them.
Troubleshooting
Popup form submissions not captured
MyAppGurus popup forms inject into the DOM dynamically. The LeadToSheet SDK detects dynamically added forms, but confirm the SDK loads in theme.liquid (site-wide) and not in a page-specific section that might not be present when the popup triggers.
Conflict with MyAppGurus Mailchimp integration
LeadToSheet and MyAppGurus' Mailchimp integration operate independently. If you see issues, ensure no other form-to-sheet app is also active. Running three-way sync (MyAppGurus + Mailchimp + another Sheets app) can cause conflicts. Use Google Sheets conditional formatting to flag duplicate emails for review.
Conditional logic fields not in the sheet
Fields hidden by conditional logic are not submitted by the browser. Submit test entries that trigger each conditional branch to create all possible column headers in your Google Sheet.
Frequently asked questions
- Does LeadToSheet work alongside MyAppGurus' Mailchimp integration?
- Yes. LeadToSheet captures form submissions at the browser level independently. Your MyAppGurus-to-Mailchimp sync continues to function, and LeadToSheet writes a parallel record to Google Sheets with additional context data.
- Does LeadToSheet capture file uploads from MyAppGurus forms?
- No. LeadToSheet captures text field values from form submissions but does not capture file uploads. Files are handled by MyAppGurus' own storage. Access uploaded files through the MyAppGurus dashboard.
- Will exit-intent and scroll-triggered popups be captured?
- Yes. LeadToSheet captures the form submission regardless of the trigger mechanism. Exit-intent, scroll-triggered, timed, and click-triggered popup forms are all captured when the visitor submits.