Last updated: 2021-03-03
Here’s a sample workflow to demonstrate the use of the Box and Google Sheet Orchestration app to automate employee referral use case in an organization.

1. Create an event when a Service request is raised.
2. Followed by the condition to ensure the Service request is Employee Referral.
3. You can then pull in the App Node which will have the following configurations:
App Name: Box - Orch
App Action: Upload Ticket Attachment To Box
Notes when Configuring Inputs:


4. To validate whether the file uploaded successfully or not a condition node is added with a check for status code as 200.
5. If the file is uploaded successfully you can then pull in the App Node which will have the following configurations:
App Name: Box - Orch
App Action: Create a shared link for the file
Notes when Configuring Inputs:
Value is one of open, company, collaborators

6. To validate whether the shared link for a file created or not a condition node is added with the status code as 200.
7. If the shared link is created pull in an App node that will have the following configuration
App Name: Google Sheets - Orch
App Action: Insert New Row
Notes when Configuring Inputs:


8. To validate whether the details are inserted in a sheet or not a condition node is added with the status code as 200.
9. If successful add an action node with ticket status as resolved and a note as success.
Let’s see the use case execution in action.
