Sheet2Classroom

About

Paste grades from Google Sheets into Google Classroom. Works on assignments the teacher created in the Classroom UI.

Teachers who grade in Google Sheets face a split path in Classroom:

If the assignment was created via Sheet2Classroom's webapp (using the Classroom API), grade pushes just work.
If the assignment was created directly in the Classroom UI, Google's API refuses to write grades on it. Teachers have been stuck copy-pasting grades one student at a time.
This extension fixes that second case. It reads the student roster from the Classroom page you're already looking at, matches every row in your pasted grade range against the roster, and pushes each grade to Classroom — using the same save path Classroom's own UI uses, not a third-party server.

What it does

Paste any range from Google Sheets (tab-, comma-, or semicolon-separated).
Auto-detects identifier column (email, roll number, or name) and grade column.
Previews every match against the live roster before anything is written.
Shows a resolver for unmatched rows: a dropdown of unmatched roster students per unmatched key, so you can fix mismatches without leaving the popup.
Writes each grade via Classroom's own save API, then refreshes the tab's state in place so the new grade shows up without a page reload.
What it does NOT do

No remote servers. No analytics. No background requests.
Does not read any tab other than the Classroom tab you're actively viewing.
Does not create, delete, or modify assignments — only grade writes on existing ones.
Does not request access to Gmail, Drive, Calendar, or any Google scopes. It doesn't use OAuth at all — it uses your already-authenticated browser session with classroom.google.com.
Who this is for

Teachers at schools where assignments are created directly in Classroom (very common) and grading lives in Sheets. If you use the full Sheet2Classroom workflow at sheet2classroom.app, this extension handles the one case the webapp can't cover by itself.

How to use

Open any Classroom assignment you teach → Student work (the view with the student sidebar).
Copy the grade range from Google Sheets (include the header row).
Click the Sheet2Classroom icon in your Chrome toolbar.
Paste. Verify the auto-detected columns. Preview the match. Resolve any unmatched rows.
Click Apply grades to Classroom.
Leave the Classroom tab open while it runs — don't click around in it.

Privacy

Full policy: https://www.sheet2classroom.app/privacy

Summary: nothing leaves your browser. The extension talks only to classroom.google.com, on the tab you're actively viewing. Your pasted grade range is stored in your browser's local storage (so you don't re-paste on popup reopen) and nowhere else.

Support

[email protected] · https://www.sheet2classroom.app