Connect Pify Form Builder to Google Sheets
Pify Form Builder offers popup and embedded forms with Mailchimp and Klaviyo integrations, conditional logic, and custom thank-you pages for Shopify. LeadToSheet adds instant Google Sheets sync for every submission.
CMS: Shopify
Overview
Pify Form Builder is a Shopify form app that supports both popup and embedded forms, conditional logic, and direct integrations with Mailchimp and Klaviyo. LeadToSheet captures every text-based browser-side submission and writes it to Google Sheets, adding UTM attribution and device metadata that Pify's email integrations do not provide. Note that file upload fields are not captured by the SDK.
Implementation checklist
- 1
Add the LeadToSheet SDK to theme.liquid
Go to Online Store > Themes > Edit code. Insert the script in theme.liquid before the closing </body> tag. This ensures the SDK loads everywhere Pify forms render, including popup triggers.
theme.liquid 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
Test popup and embedded form variations
Submit test entries through both a Pify popup form and an embedded form. Verify that both appear in your Google Sheet with the correct page URL and that conditional logic fields are captured.
Tip: Use Pify's custom thank-you page redirect to send users to a conversion-tracked page while LeadToSheet syncs in the background.
- 3
Validate Mailchimp or Klaviyo sync alongside sheet capture
If you use Pify's Mailchimp or Klaviyo integration, submit a test entry and confirm the subscriber appears in both your email platform and your Google Sheet. Both systems should receive the data independently.
Customization ideas
Use custom thank-you pages for conversion attribution
Pify lets you redirect users to custom thank-you pages after submission. Configure different thank-you pages per campaign. In Google Sheets, use the referring page URL to match submissions to specific landing page funnels.
Enrich Mailchimp or Klaviyo segments with sheet data
Pify sends basic subscriber info to Mailchimp or Klaviyo, but LeadToSheet captures richer context like UTM source, device type, and referrer. Export this enriched data from Sheets to update email segments with attribution details.
A/B test popup timing and placement
Deploy different Pify popup configurations on different pages. LeadToSheet records the page URL for each submission, letting you compare conversion rates per popup placement directly in Google Sheets.
Troubleshooting
Popup form submissions not appearing in the sheet
Pify popups render in the storefront DOM. If submissions are missing, ensure the LeadToSheet SDK is loaded in theme.liquid and that no ad blocker or privacy browser extension is blocking the script.
Custom thank-you page redirect interrupting sync
LeadToSheet uses sendBeacon to capture the submission event, which completes even during page navigation. If submissions are still missing, ensure the SDK script loads before the form renders and is not being deferred by a theme optimisation tool.
Klaviyo integration not receiving subscriber data
Pify's Klaviyo integration is independent of LeadToSheet. If subscribers are not appearing in Klaviyo, check the API key configuration in Pify's app settings. LeadToSheet will continue to capture sheet data regardless.
Frequently asked questions
- Does LeadToSheet work with Pify's custom thank-you page feature?
- Yes. LeadToSheet uses sendBeacon to fire the submission data before the browser navigates to the thank-you page. Even if the user is immediately redirected, the data is sent before page unload and will appear in your Google Sheet.
- Can I use Pify's Klaviyo integration and LeadToSheet together?
- Yes. Pify sends subscriber data to Klaviyo server-side while LeadToSheet captures the browser event for Google Sheets. There is no overlap or conflict.
- Are popup and embedded form submissions distinguishable in the sheet?
- LeadToSheet records the page URL and form context. Popup submissions will show the URL of the page where the popup was triggered, while embedded forms show the page where the form is placed.