Send eForm quiz and survey data to Google Sheets
Capture eForm submissions - quizzes, surveys, payment forms, and timed assessments - in Google Sheets for scoring analysis, response tracking, and automated follow-ups.
CMS: WordPress
Overview
eForm (WP Form Builder) is an advanced WordPress form plugin built for quizzes, surveys, and payment forms with features like conditional logic, math formulas, timer-based assessments, and a detailed analytics dashboard. LeadToSheet captures the text-based field values from the browser-level submission and writes them to Google Sheets so you can run your own analysis, share results with stakeholders, and trigger automations outside of eForm's built-in reporting. Note that server-side data such as payment transaction IDs and timer metadata are not included in the browser submission and will not appear in your sheet.
Implementation checklist
- 1
Add the LeadToSheet SDK to your WordPress site
Paste the script tag into your theme footer or use a header/footer plugin. eForm renders its forms via shortcodes and standalone pages, so the SDK needs to be present globally to capture submissions from any eForm location.
LeadToSheet snippet
<script async src="https://www.leadtosheet.com/api/sdk?k=YOUR_CLIENT_KEY"></script> - 2
Map eForm field names to readable sheet columns
In the eForm builder, assign clear names to each form element. eForm uses internal element IDs by default, and LeadToSheet will map whatever names appear in the submission payload to your Google Sheets headers.
Tip: For quizzes, name score-related fields explicitly (e.g. `quiz_score`, `pass_fail`) so your sheet columns are immediately useful for analysis.
- 3
Submit a complete test with all features active
Fill out a test quiz or survey with conditional branches active. Verify that text field values and any client-side formula outputs appear as separate columns in your Google Sheet. Note that payment transaction IDs and timer metadata are processed server-side by eForm and will not appear in the sheet.
Customization ideas
Export quiz scores and pass/fail status for external analysis
eForm calculates quiz scores and pass/fail designations internally. If these values are included as named form fields in the submission, LeadToSheet captures them as sheet columns. Server-computed values that are not present in the browser form data will not appear.
Review timed assessment workflows
eForm's timer feature controls how long respondents have to complete a form. Timer metadata is managed by eForm internally and is not included in the browser-level form submission, so it will not appear in your Google Sheet. Use eForm's built-in reporting for timing analytics.
Pair form submissions with payment records
eForm supports payment collection via PayPal and Stripe. Transaction references are processed server-side and are not included in the browser-level form data. Use your payment provider's dashboard or webhooks to reconcile transactions with the lead data in your sheet.
Troubleshooting
eForm standalone page submissions not captured
eForm can render forms on standalone pages outside your theme template. If the standalone page template does not include your theme footer, the LeadToSheet SDK will not load. Add the SDK script directly to eForm's standalone page template or use eForm's custom CSS/JS injection setting.
Math formula fields show raw values instead of formatted results
eForm calculates formula results client-side before submission. LeadToSheet captures the raw numeric value, not the formatted display string. Use Google Sheets number formatting to apply currency symbols, percentages, or decimal precision after the data lands.
Timer-based form expires before submission reaches the sheet
If eForm's timer expires mid-submission, eForm may auto-submit with partial data or block the submission entirely depending on your settings. LeadToSheet captures whatever eForm ultimately submits. Configure eForm to auto-submit on timeout if you want to capture partial responses.
Frequently asked questions
- Does LeadToSheet replace eForm's built-in analytics dashboard?
- No. eForm's analytics dashboard provides detailed per-form reporting within WordPress. LeadToSheet adds a Google Sheets export layer so you can share data with external stakeholders, build custom reports, or trigger automations without WordPress admin access.
- Can I capture data from eForm's conditional logic branches?
- Yes. LeadToSheet records the fields that were visible and submitted based on the respondent's conditional path. Hidden branch fields are excluded, so your sheet only contains the data the respondent actually provided.
- Will eForm's email notifications and PDF reports still generate?
- Yes. LeadToSheet operates at the browser level and does not interfere with eForm's server-side post-submission actions. Email notifications, PDF certificate generation, and admin reports continue functioning as configured.