Overview

This article will teach you how to export Google Sheets data to a table using Okta Workflows.

Solution

Export Google Sheets Data to a Table

This is the Google Sheets spreadsheet:

Google Sheets spreadsheet.

Read All Rows

The Google Sheets Read Rows flow gets all the rows from the spreadsheet.

Read all Google Sheets rows.

How the flow works

1. The flow starts with the Tables-Clear Table function card, which clears the table's previous data.
2. The Google Sheets-Read All Rows action card reads all rows in the spreadsheet. It returns a list of rows.
3. The List-For Each function card sends the rows to a helper flow. The helper flow will save each row of data into a Workflows table.

Save Row into a Table

The Save to Table - Helper flow saves each row of data into a Workflows table.

Save each row of data into a Workflows table.

How the flow works

1. This Helper Flow card receives the Record field, which contains all the data from a single Google Sheets row.
2. The Object-Get Multiple function card extracts Job ID and First name from the Record JSON object.
3. The Tables-Create Row function card saves the Job ID and First Name into a table as a new row.

Google Sheets data inside a Workflows table after running the flow:

Google Sheets data inside a Workflows table.

Related References

• How to Save User MFA Information to a Google Sheets Spreadsheet in Workflows
• How to List Users Assigned to an Application and Save Users Into a Table
• How to Iterate Over Rows in a Table in Okta Workflows