Step 1: Get course ID
List courses
Please fill in any necessary fields and click Run.
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
List course work
Please fill in any necessary fields and click Run.
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
Get student grades
Please fill in any necessary fields and click Run.
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