Sync OptiMonk popup leads to Google Sheets
Back up every OptiMonk smart popup, spin-to-win entry, and exit-intent submission to Google Sheets so you have a single source of truth for conversion optimization.
CMS: Shopify
Overview
OptiMonk uses AI-powered targeting and gamification elements like spin-to-win wheels that inject complex DOM structures after page load. LeadToSheet monitors for these dynamically rendered forms and captures every field value, coupon code assignment, and email opt-in into Google Sheets, giving you a permanent record outside of OptiMonk's dashboard.
Implementation checklist
- 1
Install the SDK in your Shopify theme
In your Shopify admin, go to Online Store > Themes > Edit Code and add the SDK snippet to 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
Activate each OptiMonk campaign
Open your store in a fresh browser session and trigger each campaign type: exit-intent, spin-to-win, product recommendation popup, and embedded nanobar. Submit test data for each.
Tip: Use OptiMonk's preview mode to force-trigger campaigns without waiting for exit-intent or scroll thresholds.
- 3
Confirm the data in Sheets
Check your connected Google Sheet to verify that each campaign's submissions appear with distinct columns for email, coupon code, and campaign identifier.
Customization ideas
Segment spin-to-win results
OptiMonk's gamification assigns different coupon values per spin outcome. LeadToSheet captures the awarded value so you can analyze redemption rates by discount tier in Sheets.
Compare AI-personalized variants
OptiMonk's AI engine serves different popup creatives to different segments. LeadToSheet records the variant shown alongside the submission, enabling you to build pivot tables by audience segment.
Track product recommendation clicks
When OptiMonk shows dynamic product recommendations with an email capture, LeadToSheet logs the recommended product IDs so you can correlate signups with product interest.
Troubleshooting
Spin-to-win submissions not appearing
OptiMonk's gamification widget renders inside a deeply nested DOM structure. If submissions are missing, verify that no Shopify app or theme script is removing or modifying the OptiMonk container element before the form submit event fires.
Duplicate entries from A/B tests
OptiMonk A/B tests serve multiple campaign variants. If you see duplicate rows, check that the same visitor is not submitting both the control and variant. LeadToSheet deduplicates by submission fingerprint, but force-refreshing during testing can bypass this.
Nanobar forms captured without context
OptiMonk nanobars are persistent across page navigations. LeadToSheet records the page URL at submission time, but if the nanobar persists across SPAs, the URL reflects the page where the user finally submitted rather than where they first saw it.
Resources
Frequently asked questions
- Does LeadToSheet capture the coupon code OptiMonk assigns?
- Yes. The coupon code is typically rendered in a hidden or visible field within the popup DOM. LeadToSheet captures all form field values, including dynamically injected coupon codes.
- Can I still use OptiMonk's Klaviyo or Mailchimp integration?
- Absolutely. LeadToSheet operates independently at the browser level and does not interfere with OptiMonk's server-side integrations or webhook connections.
- How does LeadToSheet handle OptiMonk's multi-step popups?
- LeadToSheet captures the final submission of each multi-step popup. If OptiMonk collects an email on step one and a phone number on step two, the full dataset is captured when the final step submits.