Embedding Google Sheet into a Moodle activity

For choosing piano students on a piano pedagogical course from a list of Google Forms answer rows.

Moodle activity can be of any type including text editor.

Here are the steps: 

1. Build the Google Sheet as you like.

2. Publish the sheet to web. Main menu: File -> Share -> Publish to web -> Embed 

This view opens: 

3. Copy the text between <iframe ... </iframe>

4. Move on to edit the Moodle activity

1. Open extended menu

2. Change to HTML edit mode

3. Write <div> and </div> to the spot where you want to attach the Sheet

4. Paste the Google sheet <iframe> code between <div> and </div>

Above steps are enough to get the sheet visible. Below are some extra tips for the visuals.

1. Add width:"100%" and height="500". By changing the values you can enlarge/shrink the table.

2. Inside <iframe> link you can delete the part after question mark. Instead write ?rm=minimal&amp; to hide Google Sheets toolbar row.

Pietu Halonen, KPTK