Bridge: Improving Workflow to get Group members into a sheet

Neil Egsgard

Hello,

Ravali Yelmelwar and I created this Bridge Workflow to transfer Smartsheet Groups and their members from the Smartsheet Admin Group page to a sheet. For our organization, the Workflow takes about 25 minutes to run for 59 groups. Does anyone have suggestions for reducing the run time?

Screenshot of the Smartsheet Groups and members in a sheet

Starting Workflow

This Workflow:

1. Gets a list of all rows from the Smartsheet Groups sheet
2. Deletes all rows from the sheet
3. Gets a list of all Groups in an array.
4. Runs the child workflow for each group

API call is:

Get Smartsheet group data

This workflow:

1. For each group
   1. Adds a row to the sheet with the Group ID and Name
   2. Gets the members for each Group
   3. Runs a child workflow for the members

API call is:

Add Group members to sheet

This workflow:

1. For each group of members
   1. Extracts the members emails
   2. Extracts the number of emails in the group
   3. Splits the emails into contact columns with a limit of 20 contacts per contact column
   4. The structure below repeats for every 20 memberd

Thanks, everyone!

Neil Egsgard
Business Solutions Architect
Southern Alberta Institute of Technology

Lee Joramo

I have not done that much with Bridge, but I have done lots with the Public API, which is largely what Bridge uses behind the scenes. If I understand you correctly, I think this process should take a less than a few minutes (maybe seconds) to complete if done via the API.

Yesterday (2024-10-28), I had experienced slowness with some of my API updates that are triggered via WebHooks. Smartsheets's Status page confirmed issues with "Automated Workflows Delayed". You might have run in to that problem. Is your Bridge workflow slow today?

If that is not the problem, can you tell what steps in Bridge are taking the time? Can you add some sort of logging into your Bridge workflow to get a feel for what is slowing things?