Here's a link to a video I made for the Inquiry teachers on how to set up a Google Sheet to mark a Google Classroom assignment with Goobric. 2 prerequisites:
1) Install the Doctopus add on in Google Sheets
2) Install the Goobric extension to Chrome
Troubleshooting: