We occasionally have tutors and instructional aides that need Canvas accounts in our instance but they are not in our SIS so our normal account creation process does not work. And there is a high turnover in these positions so I need to use a spreadsheet to track things.
What, I'd like to do is generate an API access token in Canvas and use it in conjunction with a Google Spreadsheet AddOn/script that I could run and it would create the accounts from the sheet.
I think this is possible, I'm just not sure how to code the script yet.
If anyone has an example or would like to team up with me on this project, I'd appreciate it. In the spreadsheet I am using now, I also use the autocrat script to send the supervisors and new users an email with an Google Doc of their account information along with some help tips.
Looking forward to getting this going!