In my flow I want to add the ability to update a variety of different sheets within my overall google sheet. Therefore I decided to use the sheet name input. I want to update multiple rows in each sheet but this is not possible. If I set to update multiple rows the node requires a list as an input for the sheet name. I used the duplicate node to achieve a list of the sheet names (identical), but when run this causes the node to not work. I asked Gummie to explain the error log and it said it’s because the node is expecting only one value for the sheet name, but this is not possible…
Hey @jxhnnyp! 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.
I am also getting a similar issue with the notion database name input on notion reader and writer nodes. I want to dynamically change the notion database I will be extracting data from and writing in, however, when I use a variable for the notion database name it does not work. I have tried the actual notion database name as well as its ID.
Hey @jxhnnyp — Do the different sheets within your spreadsheet have the same schema? If not, this setup likely won’t work as expected since the Google Sheet nodes rely on headers in the first row to identify columns. If those headers differ across sheets, the node won’t know how to handle them because it hasn’t “read” that schema yet.
That said, this is a common use case and something we’re aiming to support better in the future.
Could you also share the run link so I can take a closer look at the inputs, outputs, and the error? You can find it on the Gumloop history page or in the Previous Runs tab on the canvas.
That makes a lot of sense, one of the sheets had a different schema to the rest. I will fix that now and hopefully that resolves the issue. I believe the run link is in the original post.
