Export all organization units in google workspace (apps script)
Play Video about Export all organization units in google workspace (apps script)

Reference Script below to copy & paste

				
					function exportOrgUnits() {

    // get google sheet as we'll write data to it later, change sheet name to match yours
    const sheet = SpreadsheetApp.getActive().getSheetByName("Sheet1")


    // you can add more fields based on your requirements
    const fileArray = [
        ["Org Unit Name", "Org Unit ID", "Parent OrgUnit Path", "Parent OrgUnit Id"]
    ]
    const orgUnits = AdminDirectory.Orgunits.list("my_customer", {
        type: "ALL"
    }).organizationUnits.forEach(orgUnit => {
        fileArray.push([orgUnit.name, orgUnit.orgUnitId.slice(3), orgUnit.parentOrgUnitPath, orgUnit.parentOrgUnitId.slice(3)]) // you can add more fields based on your requirements


    })

    // write data back to our sheets
    sheet.getRange(1, 1, fileArray.length, fileArray[0].length).setValues(fileArray)

}
				
			
Scroll to Top