Connect Masteriyo and Google Sheets

Masteriyo runs your courses inside WordPress, and FlowMattic runs on the same kind of site. Together they write student activity into Google Sheets: enrollments, completed courses, quiz results, reviews and questions. Course creators, schools and training teams get a sheet they can share with instructors, managers or clients who never log in to WordPress.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in Masteriyo12 triggers

Do this in Google Sheets19 actions

1. TriggerCourse Completed

2. ActionAdd New Row

When Masteriyo fires Course Completed, 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

Masteriyo 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 Masteriyo course completion

Each student who finishes a course gets a row with their name, email and the course, which is the list you need for certificates, follow-up offers and client reports.

Course CompletedAdd New Row

View the template

Give each course its own enrollment tab

A Router reads the course on each enrollment and writes the student to that course's tab, so every instructor sees a class list for their own course.

Student EnrolledRouterAdd New Row

Record quiz results for a gradebook

Each completed quiz is added with the student, quiz and result, giving teachers a gradebook they can sort, chart and share with parents or managers.

Quiz CompletedAdd New Row

Collect course reviews in one place

Reviews are written to a Reviews tab with rating and text, so you can read feedback across every course and pick quotes for sales pages.

Course Review CreatedAdd New Row

Track student questions until they are answered

New questions are added as rows. When an instructor replies, a second workflow finds the question and marks it answered, so nothing waits for weeks.

Course Question Reply CreatedLookup Row DataUpdate Row

Show progress on the student's row as lessons finish

Look up the student by email each time they complete a lesson and write the lesson name and date, so a coach can see who has stalled.

Lesson CompletedLookup Row DataUpdate Cell Data

Keep a list of new instructor sign-ups

Each instructor who registers is added to an Instructors tab, giving whoever approves teachers a review list with contact details.

Instructor RegistrationAdd New Row

Set up: course completions as rows

At the end, every Masteriyo course a student completes is written to your Google Sheet as one row.

Prepare the sheet
Add a header row such as Student, Email, Course, Completed and Certificate sent.
Connect Google Sheets
In FlowMattic, open Connects and add a Google Sheets connection with an account that can edit the spreadsheet.
Start with Course Completed
Create a workflow with the Masteriyo Course Completed trigger, then complete a test course with a student account so FlowMattic captures the data.
Add New Row
Add Google Sheets Add New Row, map the student and course fields to the columns, test the step and switch the workflow on.

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

From Masteriyo	To Google Sheets
Student name	Student
Student email	Email
Course title	Course
Completed date	Completed

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

Masteriyo events come from your own WordPress site, so test with a real student account and a real course rather than an admin preview.
Use the student's email as the key in every tab. Lesson and question workflows use it with Lookup Row Data to find the right row.
Student Enrolled fires once per course, so a student who joins three courses appears three times on an enrollment log. That is usually what a class list needs.

Masteriyo

Integration page

Triggers (12)

Student RegistrationTriggers when a new student registers.
Student EnrolledTriggers when a student is enrolled in any course.
Instructor RegistrationTriggers when a new instructor registers.
Course PublishedTriggers when a new course is published.
Course CompletedTriggers when a course is completed by a student.
Course Review CreatedTriggers when a student adds a review to a course.
Lesson PublishedTriggers when a new student registers.
Lesson CompletedTriggers when a lesson is completed by a student.
Quiz PublishedTriggers when an instructor publishes a new quiz.
Quiz CompletedTriggers when a student completes a quiz.
Course Question CreatedTriggers when a question is created within a course.
Course Question Reply CreatedTriggers when a reply is added to a question within a course.

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

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

Student data stays on your site

Names, emails and grades go from Masteriyo to the sheet through your own WordPress install, with no outside automation account holding them.

Large cohorts cost the same

Runs are unlimited, so a course launch with hundreds of enrollments and thousands of finished lessons needs no bigger plan.

Reports for people outside WordPress

Clients, managers and parents read a shared sheet of progress and results without needing a WordPress login.

Common questions

Can I export Masteriyo students to Google Sheets automatically?

Yes. Use Student Registration or Student Enrolled as the trigger and Add New Row as the action. Each new student or enrollment is written to the sheet as it happens.

Can I build a gradebook from Masteriyo quizzes?

Yes. Start a workflow with Quiz Completed and write the student, quiz and result to a Grades tab. Sort or pivot the sheet to see results per student.

Can each instructor get their own class list?

Yes. Add a Router after Student Enrolled with one path per course, each writing to a tab or spreadsheet you share with that course's instructor.

Do I need anything besides Masteriyo and FlowMattic?

Only a Google account that can edit the spreadsheet. Masteriyo and FlowMattic both run inside WordPress, so the student events are picked up on your own site.

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

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