We were recently tasked with identifying all community group owners who do not have a school Google account, so they can be notified about the new MFA requirements for login (mostly Parents). We could list Community Group Owners with their emails based on role, but could not output Community Group Titles (advanced list). We could list Community Group Members with their Community Group Titles and Email, but could not identify which ones were leaders - all members were included (advanced list). We could run a basic report of Community Group Owners with their Community Group Titles, but could not export the report to excel to vlookup emails. A roadblock at every turn...