How to get 3 lists into 3 separate columns using Google Sheets writer?

I have 3 separate lists of information. I want to have each list be in its own column in a google sheet.

I am having trouble understanding how to configure this with the Google Sheets writer. The Columns input does not allow me to configure which list I need in which column.

Please advise. Thank you!

See if this one will solve the issue https://www.gumloop.com/pipeline?workbook_id=3wukBFyMASMAaaniDJuoJy ? Also not sure if there are better ways of doing it. @Luis we need a model to generate number or inputs.

1 Like

Hey @jts_14 - Just want to confirm are you unblocked here? If not can you share your workbook link please and set the share access to ‘anyone with the link can view’?

You can add headers in your first row of the Google Sheet and they’ll appear as column inputs which you can map to the lists that you have.

Hey @Wasay-Gumloop yeah this seems to be fixed now. Before the columns weren’t appearing as inputs for me. Thanks!

No problem! Yeah the Sheet must have column headers in the first row in order for the node to detect them and display them as inputs.

1 Like

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