Capture Omnisend signup forms in Google Sheets
Stream every Omnisend popup, wheel of fortune entry, and landing page signup into Google Sheets so your team can analyze lead generation without switching between dashboards.
CMS: Shopify
Overview
Omnisend provides e-commerce marketing automation with signup forms, gamification elements, and landing pages. LeadToSheet captures Omnisend form submissions at the browser level, including wheel of fortune results and SMS opt-ins, creating a Google Sheets record alongside Omnisend's built-in contact management and automation workflows.
Implementation checklist
- 1
Add the SDK to your Shopify theme
In your Shopify admin, open Online Store > Themes > Edit Code. Paste the SDK 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
Test each Omnisend form type
Trigger the standard popup, wheel of fortune, and any embedded signup forms. Submit test data so LeadToSheet creates the correct column headers for each form variation.
Tip: Omnisend lets you preview forms from the campaign editor. Use this to trigger each type without waiting for display rules.
- 3
Verify SMS and email fields in your sheet
Omnisend often collects both email and phone number. Confirm both fields appear as separate columns in your connected Google Sheet.
Customization ideas
Track wheel of fortune outcomes
Omnisend's gamification wheel assigns different prizes per spin. LeadToSheet captures the winning segment value alongside the email, letting you build prize redemption reports in Sheets.
Route landing page signups separately
Omnisend landing pages live on a subdomain. Add the SDK to the landing page template and use LeadToSheet's URL-based routing to send landing page leads to a dedicated tab.
Build SMS vs email opt-in reports
Use Sheets pivot tables to compare SMS-only, email-only, and dual opt-in rates across Omnisend campaigns using the captured channel preference data.
Troubleshooting
Wheel of fortune form not captured
Omnisend's wheel widget uses a multi-step interaction: spin, then form submit. LeadToSheet captures the form submission step. If data is missing, ensure the visitor completes the email entry after spinning rather than closing the popup before submitting.
Omnisend popup renders but SDK misses it
Omnisend loads its popups via an external script that may execute after the initial page load. Ensure the LeadToSheet SDK is placed before the Omnisend script in theme.liquid so the DOM observer is active before Omnisend injects its forms.
Landing page forms not syncing
Omnisend landing pages are hosted separately and may not include your theme.liquid code. You need to add the LeadToSheet SDK snippet directly to the Omnisend landing page's custom code section if available, or use LeadToSheet's webhook fallback.
Resources
Frequently asked questions
- Does LeadToSheet capture the discount code Omnisend assigns after signup?
- If Omnisend renders the discount code in the confirmation step's DOM or passes it as a hidden field, LeadToSheet will capture it. Otherwise, you can map Omnisend campaign IDs to discount codes using a reference table in Sheets.
- Can I capture pre-built automation trigger data?
- LeadToSheet captures the form submission payload only. Omnisend's server-side automation triggers (welcome series, browse abandonment) operate independently and are not affected.
- Will this work with Omnisend's Shopify app auto-installed forms?
- Yes. Omnisend's Shopify app injects forms into your store's DOM. LeadToSheet detects them regardless of whether they were added via the app or manually embedded.