SyncWith

Get student grades from Google Classroom

Colin Dellow

Oct 02, 2021

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.

Endpoint

GET

Authentication

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

Schedule your data to update hourly or daily

Add data sources

Import additional data from other apps

Build reports & dashboards

Easily build live reports within Google Sheets

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.

Endpoint

GET

Authentication

courseId

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

Schedule your data to update hourly or daily

Add data sources

Import additional data from other apps

Build reports & dashboards

Easily build live reports within Google Sheets

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.

Endpoint

GET

Authentication

courseId

courseWorkId

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

Schedule your data to update hourly or daily

Add data sources

Import additional data from other apps

Build reports & dashboards

Easily build live reports within Google Sheets

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.