Mirror Klaviyo signup forms in Google Sheets
Stream every Klaviyo embedded form, popup, and flyout submission into Google Sheets for cross-team visibility without granting everyone Klaviyo dashboard access.
CMS: Shopify
Overview
Klaviyo's deep Shopify integration means it already captures rich customer data, but exporting that data for non-marketing teams is cumbersome. LeadToSheet captures Klaviyo form submissions at the browser level and writes them to Google Sheets in real time, giving sales, ops, and support teams instant access to new signups without needing Klaviyo seats.
Implementation checklist
- 1
Install the LeadToSheet SDK in theme.liquid
Open your Shopify admin, navigate to Online Store > Themes > Edit Code, and paste the SDK snippet before the closing </head> tag in theme.liquid.
theme.liquid snippet
<script async src="https://www.leadtosheet.com/api/sdk?k=YOUR_CLIENT_KEY"></script> - 2
Submit test entries for each form type
Trigger Klaviyo's embedded form, popup form, and flyout form. Use different test emails for each so you can verify all three appear as separate rows in your sheet.
Tip: Klaviyo forms respect list suppression. Use emails not already in your Klaviyo lists to avoid silent rejections during testing.
- 3
Confirm field mapping in your sheet
Review the auto-generated column headers. Klaviyo form fields use internal identifiers as HTML name attributes. These appear as-is in your sheet columns. Rename columns in Google Sheets after the first submission to create readable headers.
Customization ideas
Segment by Klaviyo list
Different Klaviyo forms feed different lists. Use LeadToSheet's form routing to send each list's signups to a dedicated sheet tab, mirroring your Klaviyo segmentation in Sheets.
Capture back-in-stock alert signups
Klaviyo's back-in-stock forms collect product interest data. LeadToSheet captures the product ID and variant alongside the email, letting you build demand forecasting models in Sheets.
Enrich with Shopify customer data
Use Apps Script to query the Shopify Admin API and append order history, lifetime value, or customer tags to each new Klaviyo signup row in your sheet.
Troubleshooting
Klaviyo popups not captured on first page load
Klaviyo delays popup rendering based on targeting rules (time on site, scroll depth). LeadToSheet's MutationObserver detects forms whenever they appear, but ensure the SDK loads before Klaviyo's snippet in theme.liquid so the observer is active first.
Embedded forms on product pages missing
Klaviyo embedded forms render inside a specific div target. If your product page template uses a different layout file than theme.liquid, add the SDK snippet to that layout file as well.
Flyout form captures email but not phone
Klaviyo multi-step flyouts collect email on step one and SMS consent on step two. LeadToSheet captures the final submission. If only email appears, confirm that the SMS step is completing before the flyout closes.
Resources
Frequently asked questions
- Does this replace Klaviyo's Shopify integration?
- No. Klaviyo's native Shopify integration handles email marketing, flows, and customer sync. LeadToSheet simply mirrors form submission data into Google Sheets for teams that need access outside Klaviyo.
- Can I capture Klaviyo's back-in-stock form data?
- Yes. Back-in-stock alert forms submit an email and product identifier. LeadToSheet captures both fields so you can track demand signals in your sheet.
- Will suppressed or already-subscribed emails still be captured?
- LeadToSheet captures the browser submission event regardless of Klaviyo's server-side suppression logic. Every form submit is recorded in Sheets, even if Klaviyo silently ignores the profile.