The New Contacts module in Google can only pull one primary email address when composing an email. This means that a student's parents emails will need to be uploaded into separate contact cards for each parent (not both under the student name as we used to do).
This video below will walk you step-by-step through the process:
Summary:
- Download parent email addresses from Powerschool.
- Prepare your spreadsheet and download as a .csv (one parent category/type at a time)
- Upload to Google Contacts (located in your Apps menu (waffle)
- The import button is located in the left side menu under More.
Your spreadsheet, when ready to download as a .csv, should look similar to this.
- You must upload each parent/guardian category (mom/dad) separately (as shown in the image above). The New Contacts only use the primary email so each contact should only have one email associated with it.
- All columns must be labeled in the header row (row 1) and at least two of the labels must be "name" and "email".
- There can be additional columns (like student name). Additional information will import into the "add a note" box in the parent contact.
If you would like to add the student name to the Parent Contact card in the notes section, this video will explain how:
=CONCATENATE(A1," ",B1)