Hello, 

I have a workflow for a recruiting agency that I want to automate.

When the agency gets a new customer, the customer has either one position to recruit or multiple positions.

Based on the position, the recruiting agency will create a folder structure in Google Drive like the following:

Lead name

    Position 1

    Position 2 (if it is more than one position)

    etc.

The Google Sheets columns look like this:

Lead No. | Lead Name | Position 1 | Position 2 | Position 3 | ……….

How can I create one workflow that checks all of the columns position and then creates the specific folder structure based on the input (so if only one position is filled in, it should create one folder with the position name, etc. and if there are more than 1 positions, it should create folders based on the input. So Pos 1 - Pos 5 is filled in, it should create 5 folders with the name of the column with subfolders).

I already created one workflow if a new row is added in Google Sheets, it should create everything in Google Drive.

The only problem I have is with multiple positions.

Is there a smart way to solve this within one workflow or do I need to create one workflow for each position?

Many thanks in advance, have a nice Sunday! :)

Maurizio