Google Sheets Updater not displaying columns correctly

Context: When first creating a Google Sheet Updater block, all columns appear correctly (if I add a column to the source Google Sheet and refresh the Updater, the new columns will not show, forcing me to recreate the block from scratch).

Problem: When I list the columns that I wish to add content for, the Updater block takes away all columns besides the first 3 columns and I cannot input the fields nor run the block without listing the columns.

The image below shows:

  • The Updater block on the left displays all of the columns correctly for input but does not have any columns listed in the Columns fields - this block cannot run without the Columns field populated.
  • The Updater block on the right has all of the columns listed in the Columns field but shows only 3 columns as available inputs. If I remove those specific 3 columns, they disappear from the inputs and the other listed Columns variables will not display as available inputs.
  • What is not shown is: even when I load up the Updater and it displays all the inputs, when I click refresh on the Columns field or type any columns in, all the inputs (beyond the 3 variables shown in the right Updater) disappear. For some reason, the inputs do not disappear when I update the Sheet Name field, just the Columns field.

This has effectively killed the Google Sheets Updater for me and I do not know how to fix it. I’ve also tried logging out and logging back in, rebuilding the blocks, etc.

Please help.

Hey @MiningTheSkies - Would it be possible to share your workbook link and Google Sheet (or a copy of the Google Sheet) with wasay@gumloop.com?

I’ll try and reproduce the issue on my end.

As for point #3 - That is known and expected, although we can definitely make the UX better here. Logged that as a ticket on our end.

Hi @Wasay-Gumloop, here’s the link to my workbook, and here’s the link to the sheet.

I’ve been playing with the workbook, trying to tackle things, so it’s not the same as shown above.

I work in enterprise AI/GenAI/Data strategy, product development, and consulting, so this is my happy place. Do you have a different way I can give feedback easier? I’d love to see GumLoop succeed. I’m really drawn in by the product but it still needs a lot of work.

Thank you @MiningTheSkies! I’ve requested access to view the flow. You can also enable ‘anyone with the link can view’ under the share button.

We setup Slack channels for users on the pro plan and above so they can provide feedback and get quicker support. What plan are you on? Would love to set one up for you.

PS. We also actively keep track of Feature Request (through a Gumloop flow of course :wink:) so you if you drop anything there we’ll review and add to our roadmap.

This topic was automatically closed 4 days after the last reply. New replies are no longer allowed.