Sheets Updater Failed

[ksandersbbb]

The sheets Updater Failed and I do not know why. The Sheer does have 49 rows not including the header row.

It says to send you the link.

https://www.gumloop.com/pipeline?workbook_id=urNSsusSa212BS5zwy2E1f&run_id=MB4E4M28VQGjYAHax58GHi

https://www.gumloop.com/pipeline?workbook_id=urNSsusSa212BS5zwy2E1f&run_id=MB4E4M28VQGjYAHax58GHi

Thank you.

[Wasay-Gumloop]

Hey @ksandersbbb – When a node runs in loop mode or expects a list input, all lists going into it must have the same length.

In your case, the search value (URL) comes directly from the Google Sheet Reader node, while the other column inputs are from the Website Scraper + Extract Data node, which is wrapped in an Error Shield. Since the Error Shield skips failed inputs, this caused the output list from that part of the flow to be shorter than the list of URLs from the Google Sheet.

When lists have different sizes, the node doesn’t know how to pair them up, leading to an error. Essentially, one list is instructing the node to loop 45 times, while the other is asking it to loop 49 times.

To fix this, create a subflow for everything downstream of the Google Sheet Reader node and wrap that subflow in an Error Shield. This way, the subflow runs individually for each row in the sheet, and if anything fails, the entire subflow process is skipped for that specific input instead of causing a list mismatch issue.

Subflow Tutorial: https://vimeo.com/1052111235/cb7e3a446b
Subflow Docs: https://docs.gumloop.com/core-concepts/subflows

Let me know if this makes sense and works for you.