How to insert a score into a Google Drive lesson plan

Many Creative Sequence users enjoy the online Google Drive lesson plan templates. Being able to access and share lesson plans anywhere, from any device, is certainly handy. However, there are some limitations to Google Spreadsheets. One major limitation is images. If you paste an image into the spreadsheet, it floats over top of the form, and does not stay where you want it.

To insert a score into the “repertoire” cell, use the following formula in that cell:


However, this assumes you have a url (web address) for your image. If you have the score image on your computer, how do you upload it to a url? Well, if you have a Google Drive account, then you also have a Google+ (plus) account (all Google offerings are now linked together in one account).

To find Google+, look for the square of nine little squares in the top right of your Drive window. Click on this, then choose the “g+”. If it’s your first time in Google+, you may have to answer some setup questions. Once through this process, look for the “Home” button on the top left. Click this to open a menu, then choose “Photos”. From here, there is an “Upload Photos” button, or you can drag and drop images from your computer.

Once you have a score saved on Google+, open the image, then right-click (ctrl-click on Mac) and choose “Copy image url”. Finally, go back into your Lesson Plan spreadsheet, and replace “” with the copied address. Once you hit “enter”, you will see your score in the cell! Resize to make it fit better, and you’re done.imageexample

So…one more question. How do we make those scores in the first place?

Leave a Reply

Your email address will not be published. Required fields are marked *