So I’m trying to get gumloop to auto-populate a column on excel with either true or false by routing other columns through a run code node. The code works and is outputting the true or false values for each of the rows in the column. I’m using a create a list node to create a list of lists from the column I need updated and have the google sheets updater set to multiple rows but when I run the workflow it says it failed and only one row gets updated. I’ve tried asking gummie for help but it hasn’t come up with any solutions that have worked for me so far and im stumped.
Hey @Manta_695! If you’re reporting an issue with a flow or an error in a run, please include the run link and make sure it’s shareable so we can take a look.
Find your run link on the history page. Format: https://www.gumloop.com/pipeline?run_id={{your_run_id}}&workbook_id={{workbook_id}}
Make it shareable by clicking “Share” → ‘Anyone with the link can view’ in the top-left corner of the flow screen.
Provide details about the issue—more context helps us troubleshoot faster.
Hey @Manta_695 – The issue here is that the output of the Run Code node is of List type however after you’re passing the Emission Source search value through the Create List node it turns into List of List hence there is a type mismatch. Both inputs going into the node should be of List Type when Update Multiple Rows is enabled.
You can simply remove the Text Formatter and Create List node and connect the search value input directly with the Sheet Reader node. You’ll also need to disable loop mode (its not necessary here since you’ve Update Multiple Rows enabled).
