Create Secret O365 Groups using CSV

create-secret-grp.ps1

# Create a Distribution List with Hidden Membership using a CSV of contacts
import-module AzureAd
Import-Module ExchangeOnlineManagement

Connect-AzureAD
Connect-ExchangeOnline

$csv = Import-Csv C:\Users\username\Documents\Investors.csv

foreach($investor in $csv)
{
    New-MailContact -Name $investor.Name -ExternalEmailAddress $investor.Email
    Add-DistributionGroupMember -Identity "Investors" -Member $investor.Email
}

New-DistributionGroup -Name Investors -HiddenGroupMembershipEnabled:$true

foreach($investor in $csv)
{
    Add-DistributionGroupMember -Identity "Investors" -Member $investor.Email
}