How to get ‘Email Address’ field in Smartsheet service

When a new row is added to Smartsheet, I want to capture the value of the ‘Email Address’ field from Smartsheet and use it to create a membership on Cisco Webex Teams.

Here are the steps that you need to follow to do this:

  1. Set up the Smartsheet trigger: Sheet Operations > New Row Created.
    This will trigger the workflow whenever a new row is added to the specified sheet in Smartsheet.

  2. Next, add the Cisco Webex Teams connector to the canvas and select the Create Membership action. In this action, specify the ID of the space under which you wish to create a membership for the user.

  3. In the User Email ID field, you need to use the ‘displayValue’ string, which is part of the output of the trigger. To get this, expand the Trigger output given on the left and from the row details, select sheet_row > cells > and use the ‘displayValue’ string as an input.

  4. Once this is done, save the workflow. Now, whenever a new row is added to the sheet, it will fetch the value entered in the selected column and automatically create a membership in Cisco Webex Teams using the given value (email ID).