Help with creating a new sheet within a google workbook with only the header line

[apiparo]

I have a google sheet with a template tab that contains just 1 row of column headers. I want to be able to use google sheet writer to create another tab (call it Test 1). That seems to work by configuring the sheet name to Test 1. It creates the new tab, but it does not populate it with the column headers. Gummie has given me multiple approaches (creating inputs, duplicate nodes to try and write the headers into the sheet + another approach of reading a csv file first). None have worked. How do I get the column headers in the new Test 1 tab so I can actually write data to it?

[Gumloop_Bot]

Hey @apiparo! 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

[apiparo]

Gummie suggested approach to create inputs, duplicate and writer

https://www.gumloop.com/pipeline?run_id=mHBn4vD5RN9AMHZEKUD6hG&workbook_id=dtKuzfxRitevMdJUYFe92c

[Wasay-Gumloop]

Hey @apiparo – In the Google Sheet Writer node we have an option to Create a New Sheet but that creates a separate spreadsheet workbook, not a new tab on the same spreadsheet, is that something that could work here? If not, I can add this feature in our backlog.

Could you also share access to the run link with me so I can view the input/outputs more closely please?

[apiparo]

Hi Wasay,

Here is the link to the workbook - https://www.gumloop.com/pipeline?workbook_id=dtKuzfxRitevMdJUYFe92c&run_id=cKEBwgU3h7tfex2fL2Kzh8

As for the use case, I do not want to create a separate file each time. I do want to create a new sheet in the existing google sheet, which it does create the sheet that is totally empty, but then the workflow fails. I guess i could try putting an error shield around it to not stop the whole workflow. Then maybe I could try and write to that newly created sheet, but it doesn’t have column names so that fails.

For now, I have my end user clearing out the data rows prior to running the workflow and just writing to a template sheet. That’s not ideal to ask the user to consistently clear out the data sheet.

If the Writer does allow you to create a new sheet, it seems the functionality should be possible to write to that sheet in the same step. Alternatively, if there is a separate way to delete existing data in a google sheet and only maintain the header row, that would help solve my use case.

Let me know if you need additional information.

Thanks,
Angie

[Wasay-Gumloop]

Gotcha, thank you! At the moment, the node can only create a new spreadsheet file—it can’t create a tab within the same spreadsheet just yet. We’re adding this to our backlog; it should definitely be possible to support.