How do I upload emails that are not in my SIS?

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: 

1. Navigate to Portal > SSO Settings
2. In the configuration for Google Authentication, click on Edit Settings 
3. On the next screen, select "Google email addresses are not stored in my district's SIS and I will upload them manually from the Sync Upload page"


4. Select Save
5. Once saved, you will see the option to 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

File Name: teacher_emails.csv

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.

 This additional file upload will overwrite all existing emails in Clever that have come in through your SIS data feed. As such, it is important to include all email addresses in this upload, not just those being updated.

 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.