Google

Get student grades from Google Classroom

Alex Black

Colin Dellow

In this tutorial, we'll walk through how to export student grades using the free Google Classroom API. This tutorial focuses on the steps that need to be done in order to get the final set of information. You don't need our Google Sheets add-on to do this tutorial. At the end, you can choose to export the data to a live spreadsheet that you can always keep updated. Let's get started!

Step 1: Get course ID

The first step is to get your Google Classroom course ID. We'll use the List courses endpoint. You can use the form below to authorize SyncWith to talk to Google Classroom on your behalf and get a list of all of your courses.

List courses

Please fill in any necessary fields and click Run.

GET

Preview

View the API data, get a live Google Sheet dashboard

id
name
section
descriptionHeading
room
ownerId
creationTime
updateTime
enrollmentCode
courseState
alternateLink
teacherGroupEmail
courseGroupEmail
teacherFolder
guardiansEnabled
calendarId
                
                
                

Get a live Google Sheet

Export your data to a google sheet, with the SyncWith Addon, or download to CSV

Automatically updated

Add data sources

Build reports & dashboards

Step 2: Get course work ID

Next we need to get a specific assignment, like a test or essay. We can use the List coursework endpoint for this.
You'll have to put in the course ID from step 1. It should be a big number, like 226905377805.

List course work

Please fill in any necessary fields and click Run.

GET

Preview

View the API data, get a live Google Sheet dashboard

courseId
id
title
description
state
alternateLink
creationTime
updateTime
dueDate
dueTime
maxPoints
workType
submissionModificationMode
assigneeMode
creatorUserId
topicId
materials
assignment
                  
                  
                  

Get a live Google Sheet

Export your data to a google sheet, with the SyncWith Addon, or download to CSV

Automatically updated

Add data sources

Build reports & dashboards

Step 3: Get student grades

We're almost done! Now we'll use the student submissions endpoint to get the grades for all the students for a given piece of course work.
You'll have to put in a single course work ID from step 2. Like the course ID, it'll be a big number. (Want to get all the grades for all course work? We'll show how to do that later. Keep reading!)

Get student grades

Please fill in any necessary fields and click Run.

GET

Preview

View the API data, get a live Google Sheet dashboard

courseId
courseWorkId
id
userId
creationTime
updateTime
state
draftGrade
assignedGrade
alternateLink
courseWorkType
shortAnswerSubmission
submissionHistory
             
             
             

Get a live Google Sheet

Export your data to a google sheet, with the SyncWith Addon, or download to CSV

Automatically updated

Add data sources

Build reports & dashboards

Next steps

If you want to build an automatic spreadsheet that retrieves student grades for all course work, you can do this with our cell references feature. Cell references are like templated requests — so you could automatically run step 3 for each of the course work IDs that you found in step 2. You can read more about cell references in our cell references tutorial.