This knowledge base article will demonstrate how to save users' Multi-Factor Authentication (MFA) into a Google Sheets spreadsheet.

• Okta Workflows

This example demonstrates how to take a list of users and save their Multi-Factor Authentication (MFA) information into a spreadsheet.

The solution has three flows:

1. List users
2. List MFA information for a user (helper flow)
3. Save MFA information to a spreadsheet (helper flow)

List users flow

The List Users flow lists all active users using the List Users with Search card. It uses the streaming option.

 

List User MFA flow (helper flow)

This is the List User MFA helper flow:

The flow has the following steps:

1. The Helper Flow has a Record input. This is the user information. The Record object extracts the ID and Login from the user information. This is instead of using the Get Multiple card in the flow.
2. The Compose card creates an endpoint string to get MFA factors in the next card.
3. The Custom API Action card makes an API call to Okta to get MFA factors for a user. It returns MFA factors list.
4. The For Each card uses the list from the previous card to call a helper flow to save the user’s MFA information. The card passes the following information to the helper:
   • User ID.
   • User Login.
   • MFA Type – lists one MFA factor for a user.

Save MFA information to a spreadsheet flow

This is the Save MFA to Spreadsheet flow:
 

The flow has the following steps:

1. The flow has three inputs:
   • User ID
   • User Login
   • MFA Type
2. The Object – Get card retrieves the MFA factor name.
3. The Google Sheets – Create Row card creates a new row with the following information:
   • User ID
   • User Login
   • MFA Type

The Google Sheets spreadsheet with user MFA information:
 

Related References

• Okta Workflows How-To: Save User MFA Information to a Workflows Table
• How to Call an API when It is Not Available from an Existing Card (Connection)