Google Sheet Iteration not working

[GerhardV]

Your Task History ID

IjU3NjYwNTY4MDYzNzA0MzM1MjY0NTUzNzUxMzYi_pc

Hi - we have an iteration extracting the number of sheets in a google sheet, we do this because each google sheet contains a number of sheets, each sheet with a number of rows in column A (which will be used to create items in monday.com) and then extract the rows in column B to create subitems. So, the problem is that the workflow only creates the first row found in column A, with it's subitems in column B. But it does not go to the remaining sheets.

 

[ArshilAhmad]

Hi @GerhardV,

Task History ID - IjU3NjUwNTZlMDYzZjA0MzE1MjY5NTUzNDUxM2E1MTZhNTQzODBmMzIi_pc

Based on your latest Task History ID, we can see that the sheets are being updated during the automation, and the items and subitems are being added to Monday.com.

google_screen_recording_2025-04-22T17-59_16.638Z.webm

drive.google.com

 

[GerhardV]

Hi @ArshilAhmad

We can't get this to work... https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTY4MDYzNzA0MzM1MjY0NTUzNzUxMzYi_pc

 

[Resham]

Hello,

It appears that you've made some corrections to the workflow—some steps seem to have been deleted. Since this morning, it looks like everything has been functioning correctly.

If you continue to face any issues, please feel free to share a screen recording to help us better understand the problem, and we’ll be happy to assist further.

 

[GerhardV]

@Resham - here is a video recording

Inligting oor Sub-items en Webhooks

In hierdie video verduidelik ek hoe om sub-items by te voeg en hoe die status van 'n spesifieke tipe diens verander. Ek bespreek die gebruik van Google Sheets vir elke diens en hoe die webboek geaktiveer word. Dit is belangrik dat jy die proses verstaan, aangesien dit 'n direkte impak op ons...

www.loom.com

 

[Resham]

Hey,
Thanks for the clarification — we've identified the issue. It seems to be caused by a nested iterator within the router.
Could you please try removing the router and executing the same steps outside of it? That should help isolate and resolve the issue.
Let us know how it goes!

 

[GerhardV]

Hi - so we cloned the workflow and removed the router.

Here is the workflow > https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTY4MDYzNTA0MzI1MjY4NTUzNzUxMzYi_pc
And the history > https://connect.pabbly.com/task/his...d=IjU3NjYwNTY4MDYzNTA0MzI1MjY4NTUzNzUxMzYi_pc

 

[Preeti Paryani]

Hello @GerhardV,

Thanks for sharing the details. Please allow us some time to review it.

 

[GerhardV]

@Preeti Paryani - any feedback for us?

 

[Preeti Paryani]

Hello @GerhardV,

We have escalated this concern to our technical team for review. Please allow us some time and we will get back to you with the updates as we have some.

 

[Preeti Paryani]

Hello @GerhardV,

Upon reviewing your workflow, we noticed that in all of the actions, the rows are being retrieved from the same spreadsheet ID; however, the spreadsheet ID has been mapped from a single step across all actions.

We recommend either directly selecting the spreadsheet from the dropdown menu (as it appears to be the same spreadsheet named "Leadership") or entering the spreadsheet ID as a static (raw) value instead of mapping it dynamically.

Once you've made this adjustment, please test the workflow and let us know if it helps resolve the issue.

 

[GerhardV]

Hello @Preeti Paryani

I made the changes, and still only get the workflow to run for the first sheet. What we should have seen is multiple main items with subitems, but we only see one main item with its subitems. So the flow works fine, but only for the first sheet.

I also notice the workflow failed with this error:

 

[Preeti Paryani]

Hello @GerhardV,

Could you please share the workflow URL along with the Task History ID where you are encountering this issue? This will allow us to better assist you.

 

[GerhardV]

URL > https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTY4MDYzNTA0MzI1MjY4NTUzNzUxMzYi_pc
Task History ID - IjU3NjUwNTY5MDYzNzA0MzY1MjZmNTUzNDUxMzU1MTYyNTQzMzBmMzAi_pc

So the task history ID says successful, but it is not true! If you look at the workflow, you will see create item in monday.com, but the history does not even have any items created, yet is says successful.

 

[Preeti Paryani]

Hello @GerhardV,

It appears that some changes in the workflow might not have been saved properly, which could have caused this malfunction. We recommend setting up a new workflow to resolve the issue.

If the problem still persists after setting up the new workflow, we’ll be happy to assist you further over a Google Meet. Kindly try creating the new workflow and let us know how it goes.

 

[GerhardV]

Hi @Preeti Paryani

Here is the new workflow URL (still getting the same issue) https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTY4MDYzNDA0M2M1MjY1NTUzMTUxMzAi_pc

Here is the task history > Task History ID - IjU3NjUwNTY5MDYzNzA0MzY1MjY5NTUzNjUxMzE1MTY3NTQzNTBmMzki_pc

 

[Preeti Paryani]

Hello @GerhardV,

Upon discussing your use case with our team, we would like to inform you that using a nested iterator (an iterator placed after another iterator) may cause the workflow to malfunction.

However, after reviewing the recently shared workflow, we noticed that you had made changes to a previous workflow, which would not impact the process as expected. We kindly request that you set up a new workflow from scratch by clicking the "Create New Workflow" button and monitor its functioning carefully.

Please let us know if you face any difficulties further. We are here to assist you.

 

[Preeti Paryani]

Hello @GerhardV,

Could you please disable the Auto Re-Execution settings for your workflow so we can better investigate the issue.