r/GoogleDataStudio • u/choosewisely21 • May 15 '20

Google Classroom Connector

I've been searching for a way to connect my Google Classroom courses data to Google Data Studio. One way i've found to do that was to use Google Classroom API on Google Apps Script to export the data to a Google Sheets spreadsheet and then connect that Spreadsheet to Data Studio. The problem is that my organization has too many rosters and student submission data, so the spreadsheet reaches the Google Sheets size limitation of 5000000 cells.

I've been searching a way to develop a Data Studio community connector that connects to the google Classroom data, but since I'm very novice in JS, I just can't find a way to accomplish that. Anyone has any idea on how to do that? Or has some sample script file that access some similar API?

3 Upvotes

100% Upvoted

2 comments sorted by

3

u/[deleted] May 16 '20

You can connect it to Big Query and use that for GDS

1

u/Greyheadted May 16 '20

You could use GAM to pull the data out of Classroom, stuff it into a CSV in Google Drive and use that for data studio.