Zap to create multiple Google Tasks

Hi @Davyn 

Good question.

Try using the Looping app to handle X number of line items: https://zapier.com/apps/looping/integrations#triggers-and-actions

Thanks Troy!

Maybe this will do it but having a challenge. I created a zap for it using Looping and not sure how to get it to go to the next result in the Smartsheet cell to create that as a new task. 

Zap created  a bunch of Google Tasks with only “Complete Enrollment” and missed the other 2 that were in the Smartsheet cell.

See zap screenshots

@Davyn 

Try these Zap Steps:

1. Trigger: Smartsheets
2. Action: Looping
3. Action: GTasks - Create Task

HI Troy,

That is what I created. Do you mean get rid of the text formatter?

K got it! Will show screen shots below

Here are screen shots of zap and result.

The only limitation here (unless there is a workaround), is that I have to set up the Smartsheet cell with the max amount of items (tasks) that will ever be in that cell. Then I need to edit the zap looping with all the values to loop from that Smartsheet cell. Then it will loop until all are complete.

But what if I add more tasks to that Smartsheet cell in the future? Then I will have to go back and edit the Zap again to add the extra values. Is there a way to have the zap automatically loop until all values in the Smartsheet cell are created into Google Tasks without me having to go back to the Zap to add more?

@Troy Tessalone just bringing you back into this thread! Looks like @Davyn has some followup questions for you. 🙂

@Davyn 

Is there a way to have the zap automatically loop until all values in the Smartsheet cell are created into Google Tasks without me having to go back to the Zap to add more?

Yes, the Looping app can handle up to 500 loops.

Let us know how you make out here @Davyn, I just wanted to summarize this thread in the meantime! So it looks like Troy’s recommendation to use Looping was correct, following these steps: 

1. Trigger: Smartsheets
2. Action: Looping
3. Action: GTasks - Create Task 

And if in the future you need to add more tasks, the above steps should account for that and allow up to 500 Loops! 🙂

No this doesn't address the issue.

If you look at the screenshot text formatting by zapier you will see the output has 3 results. 

On the input i had to select each of the 3 values.

When the zap runs, it only creates 3 google tasks and doesn't find any ones in excess of 3. 

The loop needs to continue finding all values beyond the 3 i used in the zap set up and then create google tasks for each one. I currently have 24 values that could be created into 24 google tasks. So the question is do i have to set up my zap with 24 values in case all 24 are needed, instead of the 3? Or am i setting this up incorrectly?