Log Formidable quiz scores in Google Sheets
Formidable Forms' quiz and survey module scores answers, randomizes questions, and generates certificates. LeadToSheet captures scores, answers, and timing data in Google Sheets for deeper analysis.
CMS: WordPress
Overview
The Formidable Forms quiz and survey add-on turns WordPress into a testing platform with automatic scoring, timed quizzes, correct/incorrect feedback, and certificate generation. LeadToSheet adds a Google Sheets layer so educators, HR teams, and marketers can analyze scores across respondents without exporting from the WordPress admin.
Implementation checklist
- 1
Install the LeadToSheet script on quiz pages
Add the snippet to your theme footer so it loads on every page containing a Formidable quiz or survey form.
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
Include score fields in your form output
Formidable calculates scores server-side. Add a visible read-only text field that outputs the total score so LeadToSheet captures it alongside individual answers.
Tip: Use Formidable's [frm-field-value] shortcode in a visible read-only text field to expose the calculated score. Hidden fields (input[type='hidden']) are excluded from capture.
- 3
Run a complete scored test submission
Answer every question (including intentionally wrong answers) to verify that scores, correct/incorrect flags, and timing data all appear in your Google Sheet.
Customization ideas
Build a leaderboard from quiz scores
Use Google Sheets SORT and FILTER functions on the score column to create an auto-updating leaderboard. Share the tab with stakeholders for live visibility.
Analyze question difficulty
With individual answers captured per row, use COUNTIF formulas to calculate the percentage of correct responses per question and identify which questions need revision.
Trigger certificate delivery via Apps Script
When a passing score lands in your Sheet, use Apps Script to send a personalized certificate email using the respondent's name and score from the row data.
Troubleshooting
Scores not appearing in the Sheet
Formidable calculates scores server-side after submission. Add the score as a visible read-only text field in your form so it is included in the client-side submission payload.
Randomized questions create inconsistent columns
Randomized question order does not change field names. LeadToSheet maps by field name, not display order, so columns remain consistent across submissions.
Timed quiz submissions cut off mid-entry
If the timer expires and Formidable auto-submits, LeadToSheet captures whatever fields were completed. Partial rows are expected for timed-out quizzes.
Resources
Frequently asked questions
- Can I see which answers were correct vs incorrect?
- If your Formidable form includes correct/incorrect feedback fields or a scoring breakdown, those values are captured as separate columns in your Sheet.
- Does randomized question order affect the Sheet layout?
- No. LeadToSheet uses Formidable's internal field names for column headers, so the column order stays fixed regardless of how questions are shuffled for each respondent.
- Can I track quiz completion time?
- LeadToSheet excludes hidden fields (input[type='hidden']), so elapsed time stored in a hidden field will not be captured. LeadToSheet records its own submission timestamp, which you can use alongside Formidable's built-in timer reporting.