Google Classroom integration in Aeries depends on multiple configuration layers working together, including server configuration, Google integration settings, user identity mapping, and data setup. When Google Classroom features, such as linking courses, importing assignments, or syncing grades, are not appearing or functioning as expected, it is recommended to first review the Troubleshooting Google Classroom Connections checklist to confirm that the overall setup is correct. Once configuration has been verified, this article provides FAQ‑style troubleshooting for specific, commonly reported issues, such as the Google Classroom link not displaying for teachers or students not appearing in linked classrooms.

----------------------------------------------------------------------------------------------------------------

FAQ #1 - If the Google Classroom Link is not showing up or not working for your Teachers

Please review the following items after confirming Google Classroom setup and connections. 

If you have not already done so, review the Troubleshooting Google Classroom Connections checklist before continuing.

1. Account is any Teacher type account. 

A Teacher Account is a Teacher or Substitute Teacher account and includes Active Directory Teacher accounts. 

UGN.UTY = ('teacher','adteacher','teachersub','adteachersub') 

2. The email they have in SSO.GEM is an active account in GSuite in their Teacher Domain. If the email is not present in SSO.GEM, then their UGN.EM must be an active account in GSuite their Teacher Domain.

3. Google Teachers must be cached.  GoogleTeachers_DB in the DistrictCache table.

4. The account in SSO.GEM or UGN.EM must be in the GoogleTeachers_DB cache.

5. The school they are currently logged into is selected in the Google Classroom configuration.

6. Teachers must be in the "classroom_teachers" group in the configured Teacher Domain on the Google Integration Configuration page in the Google Admin Console. See GAFE Configuration Pt 2.

7. If they're using the Staff Integration also make sure the STF.EM is populated for the account to get properly linked from the STF table.

8. Ensure that the .p12 or .json file is the current and correct credential file for the service account that's being used, and that it's accessible by the Aeries Reporting service and all web servers which may need access.  

See the Google Integration setup to ensure this file is in the correct location. 

9. If a teacher disables "Manage invite codes" for Google Classroom, Aeries will not be able to link to it.

---------------------------------------------------------------------------------------------------------------

FAQ #2 - If Teachers are having problems with Students showing up in their Classroom, check to see if Multiple Gradebooks are associated to a Classroom ID.

This issue typically indicates a data‑level condition rather than a Google Classroom setup problem.

• Elementary without a Master Schedule

SELECT DISTINCT ID as GBK FROM GBO WHERE OV IN (SELECT G1.OV FROM GBO G1 INNER JOIN GBO G2 ON G1.OV = G2.OV
WHERE G1.DEL = 0 AND G2.DEL = 0 AND G1.OPN = 'Website_ExternalID' AND G2.OPN = 'Website_ExternalID' AND G1.ID <> G2.ID)

• Schools with a Master Schedule

SELECT DISTINCT SC,SE FROM MSS WHERE SV IN (SELECT M1.SV FROM MSS M1 INNER JOIN MSS M2 ON M1.SC = M2.SC AND M1.SV = M2.SV 
WHERE M1.DEL = 0 AND M2.DEL = 0 AND M1.NM = 'Website_ExternalID' AND M2.NM = 'Website_ExternalID' AND M1.SE <> M2.SE)
ORDER BY SC