Send Shopify Forms submissions to Google Sheets
Shopify Forms is the free, built-in form app for email capture and simple contact forms. Add LeadToSheet to push every submission into Google Sheets so your team can act on leads without leaving the Shopify admin.
CMS: Shopify
Overview
Shopify Forms provides zero-cost email capture and contact forms that live natively inside the Shopify admin. While the app handles basic notification emails, it lacks built-in spreadsheet export. LeadToSheet connects the two by capturing every storefront submission and writing it to Google Sheets in real time, giving merchants a live reporting layer without upgrading to a paid form app.
Implementation checklist
- 1
Add the LeadToSheet SDK to theme.liquid
Open Online Store > Themes > Edit code, then paste the snippet into theme.liquid just before the closing </body> tag. This ensures the SDK loads on every storefront page where Shopify Forms renders.
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
Place a Shopify Forms block on a page
In the theme customizer, add the Shopify Forms app block to your homepage, landing page, or footer section. The SDK detects the rendered form automatically once the page loads.
Tip: If your theme does not support app blocks (pre-Online Store 2.0), embed the form via liquid include instead.
- 3
Submit a test entry and verify the sheet
Fill out the Shopify Forms email capture or contact form with test data, then check your connected Google Sheet. Confirm the email address, timestamp, and page URL appear as expected.
Customization ideas
Separate newsletter signups from contact messages
The SDK auto-identifies each form via fingerprinting and you can configure tab routing in the LeadToSheet dashboard. Route email capture entries to a Newsletter tab and contact form entries to a Leads tab within the same spreadsheet.
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 built-in customer export or a webhook to enrich submission rows with customer segment data.
Trigger post-signup automations in Apps Script
Because Shopify Forms lacks auto-responder functionality, use Google Apps Script on the connected sheet to send a branded welcome email or Slack alert whenever a new signup row appears.
Troubleshooting
Shopify Forms app block not rendering on storefront
Confirm your theme supports Online Store 2.0 app blocks. If it does not, switch to a supported theme or embed the form using a custom Liquid snippet instead of the drag-and-drop block.
SDK not loading on specific pages
Verify the script tag is in theme.liquid and not inside a section or template file that only renders on certain routes. Theme.liquid is the global layout and guarantees the SDK loads everywhere.
Duplicate entries from Shopify admin notifications
LeadToSheet captures the browser-side submission event, while Shopify sends its own admin email. These are not duplicates in your sheet. If you see true duplicate rows, check that the SDK snippet is not included twice in your theme code.
Frequently asked questions
- Shopify Forms is free. Why do I need LeadToSheet on top of it?
- Shopify Forms stores submissions in the Shopify admin but offers no spreadsheet export, no UTM tracking, and no automation triggers. LeadToSheet adds all three, turning a basic capture tool into a full lead pipeline.
- Does LeadToSheet work with Shopify Forms on password-protected stores?
- Yes. The SDK runs on any storefront page that includes the script tag, regardless of storefront password protection or draft status.
- Can I switch from Shopify Forms to another app later without losing data?
- Absolutely. Your Google Sheet retains all historical submissions. When you switch form apps, just keep the LeadToSheet SDK in theme.liquid and it will capture the new app's submissions automatically.