Sync Customer Accounts Pro fields to Sheets
Capture every custom registration field, profile update, and wishlist action from Customer Accounts Pro in a Google Sheet so your team can segment buyers and personalize outreach without digging through Shopify admin.
CMS: Shopify
Overview
Customer Accounts Pro extends Shopify's default customer account pages with custom registration fields, wishlists, and profile editing forms. LeadToSheet captures every field submission from these enhanced account pages and writes it to Google Sheets, giving your CRM and marketing teams a real-time view of customer data without requiring Shopify admin access.
Implementation checklist
- 1
Install the LeadToSheet SDK in theme.liquid
Open Online Store > Themes > Edit code and paste the SDK snippet into theme.liquid just before the closing </body> tag. This ensures the script loads on every page, including account and registration pages.
LeadToSheet SDK snippet
<script async src="https://www.leadtosheet.com/api/sdk?k=YOUR_CLIENT_KEY"></script> - 2
Register a test customer with all custom fields filled
Create a test account through your storefront registration page, filling in every custom field Customer Accounts Pro adds. Verify the row appears in your Google Sheet with all field names as column headers. Note: the SDK skips forms containing password fields (input[type='password']). If the registration page includes a password field, configure the webhook integration for reliable capture.
Tip: Use a disposable email so you can delete the test customer later without affecting analytics.
- 3
Test profile edit and wishlist submissions
Log into the test account, update profile fields, and add a product to the wishlist. Note: wishlist actions may use AJAX calls rather than form submissions. If wishlist data does not appear, it requires a webhook integration for capture.
Customization ideas
Separate registration from profile updates
The SDK auto-identifies forms via fingerprinting. Use the LeadToSheet dashboard to configure routing rules that send new signups and profile changes to different Google Sheet tabs for cleaner segmentation.
Track wishlist activity per customer
LeadToSheet records the page URL alongside every submission. Use this to identify which products customers add to wishlists and build targeted re-engagement campaigns from your sheet data.
Enrich with Shopify customer tags
LeadToSheet excludes hidden fields (input[type='hidden']), so Liquid variables like {{ customer.tags }} must be placed in visible read-only text fields for the SDK to capture them. Alternatively, use Shopify's customer export or a webhook to enrich submission rows with customer tag data.
Troubleshooting
Registration fields not appearing in the sheet
Customer Accounts Pro injects its custom fields dynamically. Confirm the LeadToSheet SDK loads in theme.liquid on the account registration page. If the app uses an app block or app embed, verify the SDK script tag appears in the rendered page source after the app's scripts.
Profile edit submissions captured twice
Some Customer Accounts Pro configurations fire both an AJAX save and a page reload. If you see duplicate rows, ensure you are not also running another form-to-sheet app on account pages. Use Google Sheets conditional formatting to flag duplicate emails for review.
SDK not loading on /account pages
Shopify's account pages use a separate layout in some themes. Check that your theme.liquid (not just a section file) contains the SDK snippet, or add it to customers/account.liquid and customers/register.liquid directly.
Frequently asked questions
- Does LeadToSheet capture the custom fields that Customer Accounts Pro adds to registration?
- Yes. LeadToSheet captures all named form fields at submission time, including any custom fields injected by Customer Accounts Pro such as date of birth, company name, or custom dropdowns.
- Will order management and reorder actions inside Customer Accounts Pro be tracked?
- LeadToSheet captures HTML form submissions. If the reorder action triggers a standard form post with field data, it will be recorded. API-only actions that bypass the DOM are not captured.
- Can I use the sheet data to trigger welcome email sequences?
- Absolutely. Use Google Apps Script or a Zapier integration on your sheet to detect new registration rows and trigger a welcome email sequence in your ESP or CRM.