Google spreadsheet that makes Canvas API calls

[kansalak]

I am the system admin for Shelby County Schools ,it has been a year since we switched to Canvas , I am curious to know how many Google spreadsheet that makes Canvas API calls are available. I used one to modify due date and exploring Course Analysis Tool. Any assistance is welcome.

Thanks.

[kona]

 @kansalak ​, I don't know of a comprehensive list of Google spreadsheets that make Canvas API calls, but  @James ​ is probably one of the most prolific in creating these types of resources. I know there are others, but don't know of them off the top of my head.

Here are some of the ones I'm aware of from James:

• How to Count Student Discussion Posts
• Change all assignment due dates on one page
• Bulk Publish / Delete Pages

Hope this helps!

[kona]

PS - I'm also sharing this with the Find Answers​ and Canvas Developers​ groups in the Community to see if they can help!

[kona]

And PPS - I'm also switching this to a discussion since there isn't a "right" answer and hopefully a number of people will be able to contribute resources!

[kansalak]

Thanks Kona !

[kansalak]

thanks for your quick and helpful links , any one can provide me how Course Analysis Tool google API works, I tried but it did not captured data.

[kona]

 @kansalak ​, is this what you are talking about - Course Analysis Tool? If so, then you would be better off contacting the presenter,  @jblumberg ​ on that specific forum (scroll down and you'll see the option to comment) or somewhere else where you saw someone specifically talking about this tool.

[kansalak]

Thanks Kona, I will contact him.

Ajay

[jblumberg]

 @kansalak ,

I saw you left a comment on youtube.  I was having trouble getting in touch with you that way.

Did you fill out the credentials and lists tab of the spreadsheet.  They need to be filled out first... particularly, it needs the URL of your Canvas instance (formatted with some extra info) as well as an API key.  If you have these then you can then analyze a course by entering the CourseID number (the pull down menus won't work without further customization).

If you are going to InstructureCon this year, I could show you in person.  Just show up to the hack night.

[kansalak]

Hello Josh,

Thanks for finding me Josh. I did fill out the credentials as per you tube instruction. I will try again and also see you at instructureCon.

Thanks again

[jlondon]

Not sure this is the best place to ask this question, but I just tried using the course analytics sheet. I got it to work, except for one thing. When populating the Modules tab, I got the following error and no data was returned:

Message details

TypeError: Cannot call method "split" of undefined

[jblumberg]

It has been a while since I have worked on the code... but it is used by our staff and it keeps chugging along.

Can you test it against a different course and let me know if you get the same error?

[lalevesque]

Hi  @kansalak ​,

I don't know what your exact needs are, but I stumbled on to this github project: GitHub - whitmer/gsheet_canvas_api: Canvas API access within Google Spreadsheets and have been able to successfully make api calls from within Google Sheets.

Hope that helps!

[stelpstra]

Hi  @kansalak ​, in case MS Excel would also be an option for you, have a look at Download data to Excel using VBA and the API (workbook with code attached) which someone with a bit of VBA knowledge would be able to make specific to your needs for reading from or writing data to Canvas. Automated progress report of students in modules is an extention to that. Perhaps this might be useful to you.

[Robbie_Grant]

 @kansalak ​,

Were you able to find an answer to your question? I am going to go ahead and mark this question as answered because there hasn't been any more activity in a while so I assume that you have the information that you need. If you still have a question about this or if you have information that you would like to share with the community, by all means, please do come back and leave a comment.

Robbie