Pipe Form Maker 10Web data to Sheets
Capture Form Maker by 10Web submissions in Google Sheets, including text fields, dropdowns, and multi-page data, in a Google Sheet updated in real time.
CMS: WordPress
Overview
Form Maker by 10Web packs over 40 field types, built-in analytics, multi-page layouts, and payment processing into a single plugin. LeadToSheet gives you a parallel data stream into Google Sheets so your marketing and operations teams can analyse submissions without navigating the WordPress admin. Built-in analytics stay intact while Sheets becomes your external reporting hub.
Implementation checklist
- 1
Install the LeadToSheet SDK globally
Place the script in your WordPress theme footer so it activates on every page containing a Form Maker form.
LeadToSheet SDK snippet
<script async src="https://www.leadtosheet.com/api/sdk?k=YOUR_CLIENT_KEY"></script> - 2
Walk through a multi-page form
Form Maker supports multi-page layouts with page break fields. Complete a full test submission across all pages to ensure every field creates a corresponding column in your sheet.
Tip: Form Maker numbers pages internally. The page number is not sent as data unless you add it as a visible read-only field. Hidden fields (input[type='hidden']) are excluded from capture.
- 3
Test payment and specialty fields
Submit entries using payment fields, date pickers, and star rating fields to verify they render correctly as text values in your Google Sheet.
Customization ideas
Mirror built-in analytics in Sheets
Form Maker includes its own analytics dashboard. Replicate key metrics in Sheets by using COUNTIF and date-based filters on your synced submission data for cross-platform comparison.
Route frontend submissions separately
Form Maker can display submitted entries on the frontend. Add a visible read-only field marking frontend-originated submissions. Hidden fields (input[type='hidden']) are excluded from capture. This lets you route them to a dedicated sheet tab.
Aggregate payment data
Payment field values sync as numeric data. Use Sheets' SUM and QUERY functions to build real-time revenue tracking across all your Form Maker payment forms.
Troubleshooting
Star rating and slider fields showing unexpected values
These interactive fields submit numeric values (e.g. 4 out of 5). If you see HTML fragments instead, ensure your Form Maker version is up to date, as older versions sometimes included markup in the submission payload.
Multi-page form capturing only the last page
Form Maker collects data from all pages before the final submit. If only last-page fields appear, check that your page break fields are correctly configured and no JavaScript error interrupts the multi-page flow.
Built-in analytics counts differ from sheet rows
Form Maker analytics count all submissions including spam-flagged ones. LeadToSheet captures at the browser submit event. HTML5 required-field validation prevents the submit event from firing, but server-side spam filtering runs after capture. Some spam entries may appear in your sheet.
Frequently asked questions
- Does Form Maker's built-in analytics conflict with LeadToSheet?
- No. They operate independently. Form Maker tracks submissions server-side, while LeadToSheet captures the client-side event. Both receive the same data without interference.
- Can I capture frontend submission display entries?
- If your form allows frontend submissions (e.g. user-generated content), LeadToSheet captures those just like admin-created forms as long as the SDK is loaded on the frontend page.
- How are date picker and time fields formatted?
- Date and time fields arrive in the format configured in Form Maker's field settings. Sheets will recognise most standard date formats and allow sorting and filtering by date.