Educators
Educators uses Sheet Director for managing the data between Google Sheets and their favorite applications for sending emails, check calendar events & much more. Here we can see how all ways educators can use Google Sheets.
List Appointments/ Meetings
Imagine that you are a teacher and that you are instructing your students online. There are about 20 pupils in your class. You've told the students that they can book a meeting with you on Google Calendar if they have any questions. The number of meetings scheduled for a certain day must now be verified. In this case, you may utilize Sheet Director to get the information about the meetings planned for the specified day in a Google Sheet.
How Sheet Director is used here:
You need to configure the Google Calendar with Sheet Director.
A Google Calendar "Get Event" service is created with the required details.
The start data & the end date should be mentioned.
An email template is configured with all the necessary details.
Once the Google Calendar service is executed all the scheduled meetings for the selected week will be listed in Google Sheet.
Apps used:
Send Emails to students
Take into account that you are a teacher who has assessed your students. A spreadsheet is updated with the pupils' grades. Your students must now receive an email from you that includes a personalized message and a summary of their grades. In the same spreadsheet, the personalized messages and marks are updated. Here, you can send emails to the students from the spreadsheet data using Sheet Director.
How Sheet Director is used here:
You need to configure the Email app with Sheet Director.
A Email "Mail merge" service is created with the required details.
Setup the required mapping details.
Once the Email service is executed the personalized email with the marks will be sent to the students via Email.
Apps used:
Get contents from Trello
Consider you are a teacher. You have assigned tasks to your students in Trello. Now you need to check the status of the student weather they have completed the task or not completed within the mentioned due date. In this case you can use Sheet Director to get data from Trello.
How Sheet Director is used here:
You need to configure the Trello app with Sheet Director.
A "Query" service is created with the required details.
An email template is configured with all the necessary details.
Select the required trello card
Once the trello service is executed you will get all the details of your students from your trello card.
Apps used:
List the Classwork's available
Imagine that you are the department head for a college. Your department's teachers have created class assignments for students on Google Classroom because they provide online classes. You must now keep track of the list of assignments made by your teachers in a Google Sheet. In this case you can use Sheet Director to get the details of the available Classwork's.
How Sheet Director is used here:
You need to configure the Google Classroom app with Sheet Director.
A "Query" service is created with the required details.
An email template is configured with all the necessary details.
Once the Google Classroom service is executed you will get all the available Classwork's in a Google Sheet.
Apps used:
