Sync WPForms submissions to Google Sheets
Capture every WPForms entry - including conditional fields and conversational form responses - in a live Google Sheet your team can act on immediately.
CMS: WordPress
Overview
WPForms is the most popular drag-and-drop form builder for WordPress, used on over six million sites. Its template library and smart conditional logic make form creation fast, but built-in entry management only lives inside the WordPress admin. LeadToSheet connects the two by streaming every submission into Google Sheets so marketing, sales, and ops can work from one shared, always-current spreadsheet without needing WordPress access.
Implementation checklist
- 1
Install the LeadToSheet SDK
Add the script tag to your WordPress footer using a header/footer plugin like WPCode, or paste it into your theme's footer.php. The SDK is async and will not affect your page speed scores.
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
Verify field name mapping in the WPForms builder
Open your form in the WPForms drag-and-drop editor, click each field, and check the Advanced tab for the field name. LeadToSheet uses these names as Google Sheet column headers, so keep them descriptive and consistent.
Tip: Rename the default "wpforms[fields][3]" names to readable labels like "company_name" under Advanced > Field CSS Class or use the WPForms field label directly.
- 3
Submit a test entry through a conversational or standard form
Fill out every field - including any conditional logic branches - so that all column headers are created in your Google Sheet on the first sync. Check that Stripe or PayPal payment fields pass through as text values.
Customization ideas
Route payment forms to a dedicated sheet
If you use WPForms' Stripe or PayPal add-ons, configure a separate Google Sheet connection in the LeadToSheet dashboard for your payment form. The SDK auto-identifies each form via fingerprinting, so payment entries land in their own sheet, separate from general enquiries.
Leverage WPForms smart tags for attribution
WPForms smart tags can inject user IP, page URL, or user ID into form fields. Note that LeadToSheet excludes hidden fields (input[type='hidden']), so use visible text fields or WPForms' built-in entry export to capture smart tag values in your Google Sheet.
Build a lead-score column from template form data
Use WPForms template forms (like the Suggestion Form or Job Application template) and add a Google Apps Script formula that scores rows based on specific field values as they arrive.
Troubleshooting
Conversational form entries not syncing
WPForms conversational forms render on a dedicated permalink page that may not include your theme footer. Ensure the LeadToSheet snippet is injected via a site-wide plugin like WPCode rather than theme files, so it loads on conversational form pages too.
Stripe payment field values showing as empty
Payment tokens are not exposed to the browser for security reasons. LeadToSheet captures visible form field values at submit time. Payment tokens processed via Stripe or PayPal iframes are not exposed to the browser and are excluded from capture. Make sure AJAX submission is enabled in Form Settings > General.
WPForms entry management shows entries but Sheets does not
WPForms saves entries server-side independently of the browser event. If your caching plugin serves a static page without the LeadToSheet script, client-side capture fails. Add www.leadtosheet.com to your cache exclusion list or use WPCode to force-load the snippet.
Frequently asked questions
- Does LeadToSheet work with WPForms Lite or only the Pro version?
- Both. LeadToSheet captures submissions at the browser level, so it works with WPForms Lite, Plus, Pro, and Elite editions. The only difference is which fields are available in the builder.
- Can I keep using the WPForms entries database alongside Sheets?
- Absolutely. LeadToSheet runs in parallel. Your WPForms entry management, email notifications, and conditional confirmations continue to work exactly as configured.
- How are multi-page WPForms with page breaks handled?
- LeadToSheet captures form data when the final page's submit event fires. Partial page-break navigation does not trigger a sync, so you only see fully completed entries in your sheet.