Keep a record of our shared students by course.Add files and folders that we want to share with our selected courses.Creating your Google Sheet Managerįirst, we need to create a Google sheet manager to make it easy for us to: Once they reply we need to automatically share them with their new email. We will also need to create a way to send a message to any student who has not registered to our Teachable school with a Gmail or Google Workspace domain email and ask them to provide a Google-friendly email. One for our list of shared files and folders by course and one with our list of registered students. We will need to set up a Google Sheet that contains two Sheet Tabs. We will be making use of Teachable’s handy webhooks to receive instances when a student enrols on one of our chosen courses. Instantly share ONLY Teach:able Students to selected Google Drive Files and Folders.Find the corresponding row to the token.Connect the form to your Google Sheet Manager.Attempting to give permission to the user.Adding users to the Drive files and folders.Store Enrolled students details and Tokens.Get the course ID for your Teachable Course.
Instantly share ONLY Teach:able Students to selected Google Drive Files and Folders If you want to understand how it all works and build your own, read on, you can always throw a couple of coins at me and enrol to run the workflow just for fun. Prevent sharing by any documents you have provided ‘edit’ permission to.A choice to bulk set your files and folders to:.
Connect google drive google sheets webhook full#
Connect google drive google sheets webhook how to#
If you want a copy of the Google Sheet with the Apps Script attached, without coding it all yourself, plus written-visual tutorials on how to quickly set up your sheet head over to my teachable page now and purchase the sheet and instructions for just $2.95. If a student enrolled with a non-Gmail or non-Google Workspace domain email account, they will be sent an email with an attached form to add a Google-friendly email. In this tutorial, I will guide you through creating a Google Apps Script web app that receives a webhook notification when a student enrols onto one of my Teachable courses. I needed to find a way to share my Google Drive course content with only those students who signed up for my course. I reluctantly chose option one for my first Google Sheets Essentials Teachable Course and it really bothered me. Which is time-consuming for the course creator and annoying for the student who needs to wait to be shared before they can get their hands on your awesome course content. Manually share each student as they enrol.And hope other freeloading students don’t find and share their course material. Set sharing to Anyone with Link can view.The problem that course creators have is that they are generally stuck with two options when sharing their Google Drive files and folders: So much so that many course creators share their documents with their students all the time.
Not only are Google Workspaces, Google Sheets, Docs, Forms and Slide great to work in and look awesome, but the convenience of collaborating and sharing your Google Drive Files and Folders is also super useful.
0 kommentar(er)
