# Sending Testimonial Request to Honor Students
### *(Via Slack & Email)*

## What You'll Need:
* Gradebook Spreadsheet *(Gradebook Tab)*
* [Testimonial Request Sheet](https://docs.google.com/spreadsheets/d/12yit7DuS2q6_NWXzimfQXUPn9GzaB5JpLKBnyCUC2xk/edit#gid=715549157)

## Steps:
1. In the Gradebook Spreadsheet *(Gradebook tab)* filter all the **Honor students** only:
* ***Note: Double check the Withdraw Week column, it should be blank. Make sure to filter all honor students only.***

1. Copy all the Member ID and paste it as **values only** in the[Testimonial Request Sheet](https://docs.google.com/spreadsheets/d/12yit7DuS2q6_NWXzimfQXUPn9GzaB5JpLKBnyCUC2xk/edit#gid=715549157), under the Member ID column:
* ***Note: Make sure to copy+paste (values only) the correct Member ID of honor students beacuse once pasted, a slack message and an email will automatically be sent to the students.***
1. All the other columns are already formulated, wait for 2 minutes or so then check if Testimonial Request emails were already sent to the students.
* *Login to *[e-mail]* gmail -- credentials are in the Operations' 1password vault.*
* *Check in the sent folder if emails were already sent -- you can search for the students' email address*

1. After checking all emails were successfully sent, clear the Member ID data in the Testimonial Request sheet so it'll be ready for the next user.

[Check out this video for more reference.](https://www.loom.com/share/905c88d45ba3414e900be52f03427a9c)