Capture HappyForms entries in Google Sheets
The simplest way to get your HappyForms contact submissions into a live Google Sheet - no page builder, no complex setup, just paste one snippet and start collecting leads.
CMS: WordPress
Overview
HappyForms lives inside the WordPress Customizer, offering a real-time preview as you build simple contact forms, feedback widgets, and email signup boxes. Its minimalist philosophy means there is no built-in spreadsheet export. LeadToSheet handles that by capturing every submission in Google Sheets the moment it happens, adding page URL, timestamp, and referral data automatically.
Implementation checklist
- 1
Paste the LeadToSheet script into your site
Since HappyForms does not have a custom code injection area, use a plugin like WPCode or Insert Headers and Footers to add the snippet to your site footer globally.
LeadToSheet 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
Build your form in the Customizer and publish
Open Appearance > Customize > HappyForms, create or edit your form, and publish. HappyForms uses standard HTML form elements, which LeadToSheet detects automatically without any extra configuration.
Tip: Label your fields clearly in the Customizer - HappyForms uses the field label as the input name, so your Google Sheet columns will mirror your field labels exactly.
- 3
Submit a test entry from the live site
Visit the page with your HappyForms form, fill it in, and submit. Check your Google Sheet to confirm the row appeared with the correct columns. HappyForms' real-time Customizer preview does not trigger submissions, so always test on the published site.
Customization ideas
Collect submissions from multiple simple forms
HappyForms encourages small, focused forms on different pages. LeadToSheet records the page URL with every submission so you can filter your Google Sheet by form location without any extra tagging.
Add UTM tracking to landing pages
Append UTM parameters to the URLs of pages containing HappyForms. LeadToSheet automatically captures UTM parameters (utm_source, utm_medium, utm_campaign, utm_term, utm_content) and ad platform click IDs (gclid, fbclid, msclkid, etc.) from the page URL, turning your basic form into a campaign attribution tool.
Set up email alerts from Google Sheets
HappyForms sends email notifications, but they go to the admin. Use Apps Script on your Google Sheet to send customised notifications to sales reps, team leads, or Slack channels based on form data.
Troubleshooting
Form appears in Customizer preview but submissions do not sync
The WordPress Customizer preview runs in an iframe with a different URL structure. LeadToSheet only captures submissions from your published site. Save and publish the form, then test on the actual page.
Field labels containing special characters create odd column names
HappyForms passes the field label directly as the input name. If your label includes colons, parentheses, or other special characters, the column header may look messy. Use simple, plain-text labels for the cleanest Google Sheet experience.
HappyForms AJAX submission not detected
Some HappyForms configurations submit via AJAX without a full page reload. LeadToSheet captures form data at the browser submit event. For AJAX submissions, this happens before the server processes the request. If you still see issues, ensure you are running the latest version of both HappyForms and the LeadToSheet SDK.
Resources
Frequently asked questions
- Is HappyForms too simple for LeadToSheet to be useful?
- Not at all. HappyForms excels at simple forms, but it lacks any built-in export or spreadsheet feature. LeadToSheet gives you a live, always-updated record of every submission - something HappyForms does not provide on its own.
- Does LeadToSheet work with the free version of HappyForms?
- Yes. LeadToSheet captures at the browser level, so it works identically with HappyForms free and HappyForms Starter/Professional. No premium add-on is required.
- Can I use LeadToSheet if I have no other WordPress plugins installed?
- You just need a way to add the script tag to your site footer. A minimal code injection plugin or direct theme editing is sufficient. No other plugins are required.