Save User MFA Information to a Google Sheets Spreadsheet in Okta Workflows

In this guide:

  1. Okta Workflows guides
  2. Saving MFA information to Google Sheets
  3. Related Okta Workflows guides
  4. Okta Workflows resources

Okta Workflows guides

Okta Workflows guides are questions and answers from the community office hours, the #okta-workflows channel on MacAdmins Slack, and other places. Read all the other guides.

How to save user MFA (Multi-factor authentication) information to a Google Sheets spreadsheet?

This guide will teach you how to save user MFA into a Google Sheets spreadsheet.

Saving MFA information to Google Sheets

You have a list of users and need to save their MFA (Multi-factor authentication) 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 active users flow.

List User MFA flow (helper flow)

This is the List User MFA helper flow:

List user MFA 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 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:

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 using with the following information:
    • User ID.
    • User Login.
    • MFA Type.

The Google Sheets spreadsheet with user MFA information:

Spreadsheet with user MFA information.

Okta Workflows resources

🍫 Get help from Workflows specialists during weekly community office hours.

📺 Learn from Workflows videos.

🛟 Get help from support: discuss a Workflows topic or ask a question.

🙋🏻‍♀️ Get help from the community: join the #okta-workflows channelon MacAdmins Slack.

Leave a comment