@melodyc_lam - Thank you!
I have no familiarity with Google App Scripts. I just started looking into this and successfully created an app that accesses the relevant Canvas API. I stored the API Key as Script Property so that I don't explicitly use the API Key in the script itself. Do you think this is secure enough? Any advice on this?
My worry with this overall approach, however, is that I still need a secure way of accessing my Google App Script - presumably through another API Key? If so, why not simply do an API call to custom_data using my Canvas API Key?
@dtod users have access to their own custom_data. Outside of this I think only admins have access to that data. Would be nice in certain cases if teachers could have access student custom_data - that's the problem I'm encountering now.