Connect Smart Quiz Builder and Google Sheets

Smart Quiz Builder runs quizzes and assessments on your WordPress site. FlowMattic sends each completed quiz to Google Sheets with the score and outcome, so you can see which results are most common, follow up with leads by segment, and keep a copy of every response, all from the same site the quiz runs on.

Try FlowMattic free See example workflows

7 triggers 19 actions 6 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Smart Quiz Builder1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Quiz Response

2. ActionAdd New Row

When Smart Quiz Builder fires New Quiz Response, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Smart Quiz Builder and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Ready-made template

Log every Smart Quiz Builder response in a sheet

Each completed quiz becomes a row with name, email, score and outcome, giving marketers a list of leads and their results.

New Quiz ResponseAdd New Row

View the template

Write each quiz outcome to its own tab

A Router reads the result and writes the response to the matching tab, so sales can call the leads whose outcome fits your offer.

New Quiz ResponseRouterAdd New Row

Label score bands before they reach the sheet

Lookup Table turns a raw score range into a label such as Beginner or Advanced, so the sheet groups people without a formula.

New Quiz ResponseLookup TableAdd New Row

Update the row when someone retakes the quiz

Look the email up first. A Router updates the existing row with the new score, so you track improvement instead of collecting duplicates.

New Quiz ResponseLookup Row DataRouterUpdate Row

Log the response and email the person their result

After the row is written, Email (SMTP) sends the quiz taker their outcome and a next step, from your own site's mail settings.

New Quiz ResponseAdd New RowEmail (SMTP)

Show top scores on your site as well as in the sheet

The response is written to the sheet and to WP Tables, so a leaderboard on your WordPress page updates from the same workflow.

New Quiz ResponseAdd New RowWP Tables

Set up: each quiz response as a row

When you finish, every completed quiz adds a row to your results sheet.

Prepare the results tab
Add headers such as Name, Email, Quiz, Score, Outcome and Taken at.
Connect Google Sheets
Under Connects, add a Google account with edit access to the sheet.
Choose New Quiz Response
Create a workflow with the Smart Quiz Builder New Quiz Response trigger and complete the setup the trigger step shows.
Take the quiz yourself
Complete the quiz on your site so FlowMattic captures a full response.
Map and switch on
Add Google Sheets Add New Row, map the response fields, test the step and turn the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From Smart Quiz Builder	To Google Sheets
Name	Name
Email	Email
Quiz title	Quiz
Score	Score
Result	Outcome

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

New Quiz Response fires only when a quiz is filled in completely, so people who stop halfway do not reach the sheet.
The fields depend on the questions and lead form in your quiz, so the mapping is an example.
Create the outcome tabs before switching on the Router workflow, so every path has a tab to write to.

Smart Quiz Builder

Integration page

Triggers (1)

New Quiz ResponseTriggers when a new quiz form is filled completely.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Smart Quiz Builder and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Quiz answers on your own site

Smart Quiz Builder and FlowMattic both run in your WordPress, so responses go straight from your site to your sheet.

Popular quizzes cost the same

Runs are unlimited, so a quiz shared widely needs no bigger plan than one taken by a handful of people.

Segments sales can use

Outcome tabs give your team a call list per result instead of one long export.

Common questions

How do I send Smart Quiz Builder results to Google Sheets?

Create a workflow with the Smart Quiz Builder New Quiz Response trigger, take the quiz once, then add Google Sheets Add New Row and map name, email, score and outcome to columns.

Can I sort quiz takers by result?

Yes. Add a Router on the outcome with one path per result, each writing to its own tab, or label score ranges with Lookup Table.

Do partial quiz attempts reach the sheet?

No. The trigger fires when the quiz is filled in completely, so only finished responses are logged.

Can I email people their result too?

Yes. Add an Email (SMTP) step after Add New Row and include the score or outcome from the trigger data in the message.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Smart Quiz Builder and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Smart Quiz Builder integration 1.0.0, Google Sheets integration 2.2.4.