OVERVIEW

This article will teach you how to create groups in Okta from a CSV file using Okta Workflows.

SOLUTION

The following CSV file has groups you want to create in Okta:

Groups to create in Okta.

The solution has two flows:

1. List groups: a flow to download and load the groups into a Workflows table
2. Create group: a flow to create a group

List Groups Flow

This is the List groups flow:

List groups flow.

The flow has the following steps:

1. The flow starts with the Tables-Clear Table card to clear the table before each run.
2. The Google Drive-Download File downloads the file in a CSV format. The CSV file can be stored on any other storage service.
3. The Tables-Import From CSV card exports the CSV file to a Workflows table. The table has two columns:
   • Name (Text)
   • Description (Text)
4. The Tables-Search Rows card retrieves all the rows from the table.
5. The List-For Each card passes each record (name, description) to a helper flow to create a group.

Create Group Flow

This flow creates a group:

Create group flow.

The flow has the following steps:

1. The On Demand-Helper Flow passes the name and description for each group.
2. The Okta-Create Group card creates a group.

Running the Flow

Running the automation will create three groups:

New groups from a CSV file.

Create From a Table

You can also keep group names directly in a Workflow table without using an external storage service. If so, you will not need the first three cards in the List groups flow.

Okta Workflows and Okta API Limits

Consider Okta Workflows and Okta API limits when creating many Okta groups.

RELATED REFERENCES

• Save Deactivated Users, Export as CSV, and Email in Workflows
• How to Export Group Membership to a CSV File and Email the File in Workflows
• How to Write Output From the List Users Card to a CSV File
• How to Suspend Multiple Users from a CSV File in Workflows