[N8N Features] Generate a PJ file

[Micka_Rakotomalala]

Hello everyone,

I need help on N8N features please, I would like to generate a PJ file in an email sending from googlesheet link.

My problem is that I have three tabs on the googlesheet, if I create a file from a data list,
it only creates one tab per file, whereas I want all the tabs to be in the same file.

Can you please help me?

Thanks a lot!
Mickael

[MutedJam]

Hi @Micka_Rakotomalala, I am not quite sure what a PJ file is, but am I understanding you correctly that you simply want to create three tabs/sheets within a single spreadsheet file you’re creating through the spreadsheet file node?

This won’t be possible at the moment I am afraid, so creating three separate files would be the only option as of now. You might want to leave a vote on the respective feature request though:

Spreadsheet node to create a workbook with multiple sheets

Hi, Is it possible to use the core spreadsheet node to create a workbook with multiple worksheets in it? I can see how I would achieve this with the Google sheets node, but I need to avoid this if possible. I will be performing multiple extracts from a Postgres database and I want each of these extracts to be pushed into a worksheet of it’s own within the same workbook. I can see how to do this and output each of the data extracts to a spreadsheet of its own, but I can’t see how to do mul…