Sync POWR Form Builder to Google Sheets
POWR Form Builder brings drag-and-drop forms, conditional logic, and PayPal integration to Shopify. Add LeadToSheet to stream every text-based submission into Google Sheets for reporting and automation.
CMS: Shopify
Overview
POWR Form Builder is a cross-platform app popular on Shopify for its drag-and-drop editor, auto-responders, and PayPal payment fields. While POWR offers its own Google Sheets connector on higher plans, LeadToSheet captures submissions at the browser level with zero plan restrictions, adding UTM attribution and device context that POWR does not include natively.
Implementation checklist
- 1
Install the LeadToSheet SDK in theme.liquid
Navigate to Online Store > Themes > Edit code. Open theme.liquid and paste the script tag before </body>. This ensures the SDK is present on every page where POWR forms appear, including product pages and landing pages.
theme.liquid snippet
<script async src="https://www.leadtosheet.com/api/sdk?k=YOUR_CLIENT_KEY"></script> - 2
Embed POWR forms using the app block or embed code
Add POWR forms via the Shopify theme customizer app block or paste the POWR embed code into a custom Liquid section. Both methods render forms inside the storefront DOM where the LeadToSheet SDK can detect them.
Tip: If you use the POWR embed code inside a custom HTML block, make sure the script runs after the page loads to allow POWR to render the form first.
- 3
Test conditional fields
Submit a test entry that triggers conditional logic branches. Verify that the Google Sheet captures all visible text-based field values and conditional answers.
Customization ideas
Track PayPal payment form submissions
When using POWR's PayPal integration for order forms or deposits, LeadToSheet records the form payload alongside the page URL so you can reconcile payment submissions in Google Sheets against your PayPal transaction log.
Segment by auto-responder status
LeadToSheet excludes hidden fields (input[type='hidden']), so a hidden flag for auto-responder status will not be captured. Instead, use POWR's built-in submission export to track auto-responder status, or add a visible read-only field to the form. In Google Sheets, filter by this column to identify leads that received an immediate follow-up versus those requiring manual outreach.
Route multi-purpose forms to separate tabs
If you reuse one POWR form across contact, feedback, and wholesale inquiry pages, configure tab routing in the LeadToSheet dashboard so submissions land in the correct Google Sheet tab based on the detected form.
Troubleshooting
POWR form renders inside an iframe
Some POWR embed methods render the form in an iframe hosted on powr.io. If submissions are not captured, switch to the Shopify app block embed method, which injects the form directly into your storefront DOM where the SDK can detect it.
Conditional logic fields missing from the sheet
Fields hidden by POWR's conditional logic are not included in the submission payload. Submit a test entry that triggers every branch so all possible column headers are created in the sheet during initial setup.
Auto-responder conflicts with LeadToSheet
POWR's auto-responder and LeadToSheet operate independently. If you see submission timing differences, it is because POWR sends the auto-reply server-side while LeadToSheet captures the browser event. Both work without conflict.
Frequently asked questions
- POWR already has a Google Sheets integration. Why use LeadToSheet?
- POWR's native Sheets connector requires a paid plan and does not capture UTM parameters, referrer data, or device context. LeadToSheet works on any POWR plan and includes full attribution metadata.
- Will POWR's file uploads appear in Google Sheets?
- No. The LeadToSheet SDK only captures text-based form fields and silently drops File objects. File uploads are not synced to your spreadsheet. All other text-based field values, along with UTM parameters and device context, are recorded. Use POWR's built-in submission management to access uploaded files.
- Can I use LeadToSheet alongside POWR's Zapier integration?
- Yes. LeadToSheet writes to Google Sheets independently of any Zapier workflows you have connected to POWR. There is no overlap or conflict between the two data paths.