Google Sheet Writer Not Detected Columns

[Rich]

Hi All,
Adding a Google Sheets Writer node in connection with UI Form to populate a Googe Sheet when a person fills in the form.

The google Sheet Writer node either only detects 5 or 6 of the 10 columns from the Google Sheet. I can not find a way to make these other columns accessable to connect the input fields into their corresponding location in the node. I have clicked the refresh for the sheet & for the columns within the Google Sheet Node. Looking for guidance on what to try.

Here is the viewer link:
https://www.gumloop.com/pipeline?workbook_id=9RsdPorChFojGNprpBWFwy

[Gumloop_Bot]

Hey @Rich! 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.

1. Find your run link on the history page. Format: https://www.gumloop.com/pipeline?run_id={{your_run_id}}&workbook_id={{workbook_id}}

2. Make it shareable by clicking “Share” → ‘Anyone with the link can view’ in the top-left corner of the flow screen.
   

3. Provide details about the issue—more context helps us troubleshoot faster.

You can find your run history here: https://www.gumloop.com/history

[Rich]

Adding the Run link:
https://www.gumloop.com/pipeline?run_id=6eZVGYshxDe8pfBA9ViLsC&workbook_id=9RsdPorChFojGNprpBWFwy

[Shrikar]

One thing that works is hit refresh or delete some of the existing columns and trying refresh again.

[Rich]

Delete the columns from the Google Sheet itself or from within the Google Sheet Writer node?

[Wasay-Gumloop]

@Rich – Could you refresh the column names or remove all column selection using the X icon, that would show you all the column names. Can you also delete and add back the node if that doesn’t work?

[Rich]

@Wasay-Gumloop - I tried both methods (you mentioned previously) for removing and deleting the columns and it did not expand the number of columns past a max of 6 to add the input. I ended up deleting the flow and did a ‘create list’ to ‘extract to table’ using the AI node (cost 21/credits per run) but it filling in directly based on the Google Sheet schema.

Here is the replacement link - https://www.gumloop.com/pipeline?workbook_id=9RsdPorChFojGNprpBWFwy

[Wasay-Gumloop]

Gotcha. Would you be able to share the spreadsheet access with wasay@gumloop.com please? Also, have you already tried deleting and adding back the Google Sheet Writer node?