When setting up Clever Instant Login with Google, you will need to have Google emails populated in the email field within Clever. If your district does not store Google emails in your SIS, you can upload an additional CSV of emails for your users and the data will be merged within Clever.
How to enable email uploads
If the district uses Google as a login method for Clever, the district can enable email uploads by following these steps:
- Navigate to Portal > SSO Settings
- In the configuration for Google Authentication, click on Edit Settings
- On the pop-up screen, select "Google email addresses are NOT stored in my district's SIS."
- Click Next
- On the next screen, check the box next to "I'll manually upload emails"
- Click Save
- Upload your files on the Sync > Upload page in Clever.
If your district does not use Google as a login method for Clever but would like to be able to upload emails through a .CSV file, please contact our team and we will enable this feature for your district.
How to format your email files
In order to use this tool you will need to create a CSV file that contains two columns: student_id/teacher_id & email
File Name: student_emails.csv
|
Column Header |
Required |
Format |
Notes |
|
student_id |
Yes |
String |
Unique and constant id for student. |
|
|
Yes |
|
Student’s email address. |
File Name: teacher_emails.csv
|
Column Header |
Required |
Format |
Notes |
|
teacher_id |
Yes |
String |
Unique and constant id for teacher. |
|
|
Yes |
|
Teacher’s email address. |
This file will need to contain a list of the email and the corresponding sis_ids for users. For Google districts, this file will be created using a combination of information from your SIS and your Google admin console.
Teachers and students emails require separate uploads. As such, if you wish to upload both student and teacher emails, you will upload two files:
- student_emails.csv
- teacher_emails.csv
How to upload your email files
To upload user emails, navigate to your Sync: Upload page in the Clever Dashboard. Find the "Emails" section and select “UPLOAD STUDENT_EMAILS CSV” or “UPLOAD TEACHER_EMAILS CSV” as appropriate.
Once you have selected the CSV file(s) from your local directory and the cloud status turns green, select “Upload” to upload user emails to Clever. 
How to update emails
In order to update information after the initial upload you’ll be able re-upload the email files(s) with additional information, or you’ll be able to include emails in the SIS data feed for new users who are not listed in the additional file.
How to view email upload errors
To view errors for your email uploads, navigate to your Sync: Upload page and select “student_emails_error.csv” or “teacher_emails_errors.csv” on the right hand side.