Sync Formful contact forms to Google Sheets
Formful offers clean form designs, multiple form styles, file uploads, and built-in spam protection for Shopify. Add LeadToSheet to capture every submission in Google Sheets with zero manual export.
CMS: Shopify
Overview
Formful is a Shopify-focused contact form app that prioritizes clean design, easy setup, and reliable spam protection. While Formful handles the storefront experience well, it does not include native spreadsheet export. LeadToSheet handles that by syncing every submission to Google Sheets automatically, adding UTM tracking and referral context that help merchants understand where their leads originate.
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. Formful renders forms directly in the storefront, so the SDK detects them immediately.
theme.liquid snippet
<script src="https://cdn.leadtosheet.com/sdk.min.js" data-client="YOUR_CLIENT_KEY"></script> - 2
Choose a Formful form style and embed it
Select one of Formful's form styles in the app settings and add the form to your desired page via the theme customizer or Liquid embed code. Submit a test entry and confirm it appears in your Google Sheet.
Tip: Try different form styles on different pages and compare submission rates in Google Sheets to find the best-performing design.
- 3
Verify spam protection is working upstream
Formful includes built-in spam protection. LeadToSheet only captures submissions that pass Formful's spam filters, so test by submitting a legitimate entry and confirming it reaches the sheet while spam does not.
Customization ideas
A/B test form styles using Google Sheets data
Deploy different Formful form styles on different landing pages. LeadToSheet records the page URL for every submission, letting you compare conversion rates per style in a Google Sheets pivot table.
Build a lightweight CRM from sheet data
Since Formful does not include CRM features, use the Google Sheet as a simple lead database. Add Apps Script automations to assign follow-up owners, track response status, and calculate days since submission.
Create weekly lead summary reports
Use Google Sheets formulas to generate weekly submission summaries grouped by page URL, referrer, and device type. Share the sheet with your team for a live dashboard without any BI tool.
Troubleshooting
Formful form not appearing on the storefront
Verify the form is enabled in Formful's app settings and that your theme supports the embed method you chose. For Online Store 2.0 themes, use the app block. For older themes, use the Liquid embed snippet provided by Formful.
Spam submissions reaching Google Sheets
LeadToSheet captures any submission that the form itself accepts. If spam is getting through, strengthen Formful's built-in spam protection settings. The SDK does not add its own spam filtering.
File upload field showing empty in the sheet
Ensure Formful's file upload field generates a URL reference in the submission data. If the field has no name attribute, LeadToSheet cannot map it to a column. Check the form builder settings for the field's internal name.
Frequently asked questions
- Does Formful have its own Google Sheets export?
- No. Formful focuses on form presentation and spam protection. LeadToSheet provides the spreadsheet sync layer, including UTM tracking and device context that Formful does not capture.
- Will LeadToSheet interfere with Formful's spam protection?
- No. Formful's spam protection runs before the submission event fires. LeadToSheet only captures entries that Formful has already validated and accepted.
- Can I use multiple Formful form styles and track them separately?
- Yes. Each submission includes the page URL where the form was displayed. You can also use data-leadtosheet-tab to route different form styles to separate Google Sheet tabs.