Sync Acerill Form Builder to Google Sheets
Acerill Form Builder provides drag-and-drop forms with popup support and custom styling for Shopify. LeadToSheet captures every text-based submission and writes it to Google Sheets with full page context.
CMS: Shopify
Overview
Acerill Form Builder is a straightforward Shopify form app offering drag-and-drop building, email notifications, and the option to display forms as popups. LeadToSheet extends Acerill by streaming text-based submissions to Google Sheets so merchants can analyze leads, build reports, and trigger follow-up workflows outside the Shopify admin. Note that file upload fields are not captured by the SDK.
Implementation checklist
- 1
Install the LeadToSheet SDK in theme.liquid
Open Online Store > Themes > Edit code. Add the script to theme.liquid before the closing </body> tag. This covers both embedded forms and popup forms rendered by Acerill.
theme.liquid snippet
<script async src="https://www.leadtosheet.com/api/sdk?k=YOUR_CLIENT_KEY"></script> - 2
Test both embedded and popup form submissions
If you use Acerill's popup form option, trigger the popup and submit a test entry. Verify that both embedded and popup form submissions appear in your Google Sheet with distinct page URLs.
Tip: Popup forms render inside the storefront DOM, so the SDK captures them the same way as embedded forms.
- 3
Verify email notifications alongside sheet sync
After submitting a test entry, confirm you receive Acerill's email notification and see the corresponding row in Google Sheets. Both systems operate independently and should fire simultaneously.
Customization ideas
Style popup triggers with custom CSS for tracking
Use Acerill's custom styling options to assign distinct CSS classes to popup triggers on different pages. In Google Sheets, the page URL column lets you correlate which popup placement generates the most leads.
Route popup and embedded forms to separate tabs
The SDK auto-identifies Acerill's popup and embedded forms via fingerprinting. Configure tab routing in the LeadToSheet dashboard to send popup leads to one tab and page-embedded leads to another within the same spreadsheet.
Build a submission audit trail with Apps Script
Use Apps Script on the connected sheet to timestamp new rows, flag entries missing key fields, and send Slack alerts for high-priority submissions. This creates an audit trail for follow-up without leaving Google Sheets.
Troubleshooting
Popup form submissions not captured
Acerill's popup forms must render inside the main storefront DOM, not in a separate iframe. If the SDK is not detecting popup submissions, check the browser console for the LeadToSheet initialization log to confirm the SDK loaded on the page.
Custom styling overriding field name attributes
When applying custom CSS through Acerill, avoid overwriting form HTML directly. LeadToSheet relies on field name attributes for column mapping. Only modify classes and styles, not input element names.
Email notifications arriving but sheet rows missing
Acerill's email is sent server-side while LeadToSheet captures the browser event. If the visitor's browser blocks third-party scripts, the sheet sync may fail. Check that no ad blocker or privacy extension is stripping the SDK.
Frequently asked questions
- Does LeadToSheet capture popup form submissions?
- Yes. Acerill's popup forms render inside the storefront page DOM. The LeadToSheet SDK detects and captures them just like embedded forms, including all field values and the triggering page URL.
- Will Acerill's email notifications still work with LeadToSheet installed?
- Absolutely. Email notifications are handled server-side by Acerill's app. LeadToSheet operates in the browser and never interferes with the app's notification system.
- Can I track which page a popup form was triggered from?
- Yes. LeadToSheet records the full page URL with every submission. For popups, this is the page the visitor was viewing when the popup appeared, giving you precise page-level attribution.