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. At this time the feature needs to be enabled manually by Clever, so please contact us if you'd like to be able to upload emails through a .CSV file.

 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.