Send MyAppGurus forms to Google Sheets
MyAppGurus Form Builder offers drag-and-drop forms, popups, file uploads, 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, file uploads, conditional logic, and native Mailchimp integration. LeadToSheet captures every submission in Google Sheets, creating a parallel data record alongside Mailchimp that includes page context, UTM parameters, and file upload references 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 src="https://cdn.leadtosheet.com/sdk.min.js" data-client="YOUR_CLIENT_KEY"></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
Capture file upload references in Sheets
MyAppGurus supports file uploads. LeadToSheet records the file URL in your Google Sheet so your team can access attachments directly from the spreadsheet 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. LeadToSheet handles deduplication, but three-way sync (MyAppGurus + Mailchimp + another Sheets app) can cause conflicts.
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.
- Can I capture MyAppGurus file uploads in Google Sheets?
- LeadToSheet records the file URL or reference from the form submission payload. The actual file remains on MyAppGurus' storage. Your sheet gets a clickable link to access each uploaded file.
- 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.