Connect Gradeazy and Google Sheets

Gradeazy runs online tests and grading for teachers, tutors and training providers. Google Sheets is the gradebook many of them already share with colleagues and parents. FlowMattic adds each Gradeazy student response and each new learner account to a sheet from your own WordPress site, so scores are in the gradebook as soon as a test is submitted.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in Gradeazy2 triggers

Do this in Google Sheets19 actions

1. TriggerNew Student Response

2. ActionAdd New Row

When Gradeazy fires New Student 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

Gradeazy 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

Record every Gradeazy test response in a gradebook

Each submitted test adds a row with the student, the test and the score, so the teacher's gradebook fills itself during an exam window.

New Student ResponseAdd New Row

View the template

Keep a class roster of new learner accounts

When a student signs up or an account is created, their name and email go into a Roster tab, which shows who has joined before the first test.

New User CreatedAdd New Row

Put each test's results on its own tab

A Router reads the test name and files the response under Unit 1, Unit 2 or Final, so each tab can be averaged or shared on its own.

New Student ResponseRouterAdd New Row

Write each student's latest score on the roster

The student's roster row is looked up by email and its Last score and Last test columns are overwritten, giving a one-line view of each learner.

New Student ResponseLookup Row DataUpdate Row

Alert the tutor about low scores

A Filter passes responses under your pass mark. They go onto a Support tab and Email (SMTP) tells the tutor, who can book extra help while the topic is fresh.

New Student ResponseFilterAdd New RowEmail (SMTP)

Round scores before they reach the gradebook

Number Formatter rounds the score to whole marks or one decimal place, so averages and report cards in the sheet look the same for every student.

New Student ResponseNumber FormatterAdd New Row

Set up: a test-response gradebook

At the end, each test a student submits in Gradeazy appears as a row in your gradebook sheet.

Prepare the gradebook
Create headers such as Student, Email, Test, Score, Submitted and Teacher notes.
Connect Gradeazy and Google
Under Connects, add your Gradeazy account and a Google account that can edit the gradebook.
Use New Student Response
Create a workflow with the Gradeazy New Student Response trigger and submit a practice test as a student to capture the fields.
Map the scores
Add Google Sheets Add New Row, map the student, test and score fields, test it and switch the workflow on.

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

From Gradeazy	To Google Sheets
Student name	Student
Student email	Email
Test name	Test
Score	Score
Submitted at	Submitted

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

A student who retakes a test produces a new response and a new row. Use the latest-score example if you only want one row per student.
The field names above are examples. A captured response shows exactly what Gradeazy sends.
Gradebooks hold student data. Share the sheet only with staff who need it, and avoid public link sharing.

Gradeazy

Integration page

Triggers (2)

New Student ResponseTriggers when a student submits their test
New User CreatedTriggered when a new user is created or signs up for your account

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

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

Gradebook ready after each test

Scores arrive in the sheet as students submit, so marking day starts with a full list instead of an export.

Exam weeks cost the same

Runs are unlimited, so a cohort of hundreds sitting several tests a week needs no bigger FlowMattic plan.

Student data through your server

Responses pass through your own WordPress site into your school's sheet, not through an outside automation account.

Common questions

Can Gradeazy scores go straight into a Google Sheets gradebook?

Yes. A workflow on New Student Response adds a row for each submitted test with the student, test name and score. Use a Router to give each test its own tab.

What happens when a student retakes a test?

Each attempt is a new response. Keep every attempt as its own row, or look up the student and update one row with the latest score.

Can I add new students to a roster automatically?

Yes. Start a second workflow on New User Created and add each account to a Roster tab with Add New Row.

Can a tutor be told about students who need help?

Yes. Add a Filter for scores below your pass mark and an Email (SMTP) step with the student's name, the test and the score.

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

Start automating Gradeazy 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. Gradeazy integration 1.0.0, Google Sheets integration 2.2.4.