Skip to main content

I would like to create an automation that pulls info from a google doc and adds a new subitem if it’s ID does not match an existing subitem.  

For example below, I want to run a check against these IDs and if the new item’s ID doesn’t match them it creates a new subitem.  I’ve been trying to play around with Looper but can’t seem to figure out how to implement this since each sub-item comes in as a line item with a different name. 

 

Please let me know if you have any suggestions, 

Thanks!

Hi @igriboff,

Good question.

Try this Zap action: Looping - Create Loop from Text

You can map each of the variables and separate with a comma.

 


@Troy Tessalone Could you send a screenshot with how to fill this out? If I don’t know in advance how many sub-items there will be, what should I be putting in each field?


@igriboff 

To help us have more context, please post screenshots with how your Zap steps are currently configured.


@Troy Tessalone 

Here’s the workflow:

What I want to do is take the info from the google sheet which has a list of items and only create a subitem if the new subitem item doesn’t match an existing subitem’s ID. 


@igriboff 

If Step 3 is returning each Subitem as a separate field, then that likely won’t be usable.

To get the Item Subitems, instead you may have to explore using the Monday API: https://developer.monday.com/apps/docs/mondayapi

App APIs can be used in Zaps via these apps: