Email Forminator quiz results to entrants and log the scores in Google Sheets
When someone completes a Forminator quiz, this workflow emails them their score and recommended match, then adds a row to Google Sheets so you keep a record of every entrant’s result.
Forminator
Google Sheets3 steps Setup ~5 min Used on 2.6k sites Lead Capture Free to import

What this workflow does
A quiz on your site does more when the entrant takes their result away with them and you keep a record of who took it. Forminator shows the result on screen, but once the tab is closed it is gone for the entrant. This workflow emails the result to them and logs each attempt in a spreadsheet.
The Forminator trigger runs on each new quiz submission. FlowMattic's Email step writes to the email address from the entry, with the subject Your result followed by the result. The body greets the entrant by name, gives their score on the named quiz and states their recommended match.
Finally, FlowMattic writes the attempt to Google Sheets as a new row. That step ships without mapping, so after import you choose which columns hold the name, email, score and result. The template expects the quiz to collect a name and an email address; without them the email has no recipient. Result emails go out through whichever SMTP provider you connect to the Email step.
Product finder quiz for a shop
Shoppers answer a few questions and get an email naming the product that suits them, while the sheet shows which recommendations come up most.
Training or course knowledge check
Learners receive their score by email after each attempt, and the trainer reviews all scores in one Google Sheet.
Lead quiz for a coaching business
A which-programme-fits-you quiz emails each entrant their match and builds a sheet of names and emails you can follow up with.
How this workflow runs
What happens at each step once the workflow is on, and what you need before you import it.
Forminator New Quiz SubmissionStarts the workflow each time an entrant finishes your Forminator quiz. Their name and email, the quiz title, the score and the result are passed to the next two steps.
- Email Send Email
Emails the entrant with Your result and the result in the subject. The body names them, gives their score on the quiz and their recommended match. Set up your SMTP connection on import.
Google Sheets Add New RowWrites one row per quiz attempt to your Google Sheets spreadsheet. No columns are mapped yet, so after a test submission map the name, email, score and result to your sheet.
What you need
- FlowMatticCore
- Forminator PluginPlugin
- Google Sheets AccountAccount
After importing, map your own data. To keep the template universal, not every step is pre-filled. Open each step in the builder and connect your accounts and fields (channels, lists, sheets, recipients) before you switch the workflow on.
Make it yours
Changes worth making after you import it.
- Take the quiz once yourself after import and check Task History to see whether your quiz type sends a score, a result or both, then edit the email wording to match.
- Add a Filter before the Email step that continues only when the email field is not empty, if your quiz lets people finish without giving an address.
- Add a column for the date in your sheet and map a date value from the run, so you can see when each attempt was made.
Questions about this workflow
Does the Forminator quiz need to ask for an email address?
Yes. The Email step sends to the email field from the quiz entry, and the greeting uses the name field. Without them the result email cannot be addressed.
Is anything written to Google Sheets before I map it?
The Add New Row step ships with no columns mapped. Map the quiz fields to your sheet's columns after a test submission so each row holds the data you want.
Will Forminator still show the result on screen?
Yes. The workflow runs after the submission and does not change how Forminator displays results to the entrant.
What if the same person takes the quiz twice?
Each submission is a separate run, so they get a second email and the sheet gets a second row.
More Forms to Sheets & CRM workflows
Other ready-to-import templates from the same category.
Import this workflow into your WordPress site
Download the JSON, import it from the Workflows screen and connect your accounts. Every run stays on your server, with no per-task fees.
30-day money-back guarantee Unlimited workflows and runs Self-hosted





