How to merge Files from Split-in-Batches Node into One to send in a Mail?

[onurbolaca]

Hi,

I want to send e mail with attachments and before doing that, I need to gather all the attachments with the gDriveIds of attachments and then send them in one mail.

But I couldn’t achive it like this. I’m able to get the attachment but in every attachment I get, it sends a mail.

How can I collect all the attachments I download from drive and send them in one mail?

Information on your n8n setup

• n8n version:Version 0.219.0
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker):
• Operating system:Linux

[onurbolaca]

I found a couple of solutions,

But these are not for files, works well with data.

Get all results after batch split node?

Hi @MatthieuParis Welcome to the community! There should be some examples of this on the forum. Also a link to a template here: Merge data for multiple executions | n8n workflow template Also if you can use community nodes there is one that makes this easier for you.

Merging items after "split in batches"

As @jan said, it will iterate over the result set until it gets an exception and then just break the iteration and return the result. If you look at the code it becomes a bit easier to see: const allData = [] let counter = 0; do { try { const items = $items("Increment", 0, counter).map(item => item.json); allData.push.apply(allData, items); } catch (error) { return [{json: {allData}}]; } counter++; } while(true);

"Wait until finished" after "Split in Batches" and Merge the Batches (For Spotify Workflow)

Hey @ottic! Were you able to find a solution? If you need more help do let us know

[onurbolaca]

Hey @BramKn ,

This one didn’t solve my issue with files. It collects the data correct but not the binary files.

Merge data for multiple executions | n8n workflow template

Then I tried this algorithm to collect all files into one but this algorithm cannot see both files, can only see a file from one cycle;

let results = [];

for (const item of $input.all()) {
    for (key of Object.keys(item.binary)) {
        results.push({
            json: {
                fileName: item.binary[key].fileName
            },
            binary: {
                data: item.binary[key],
            }
        });
    }
}

return results;

[BramKn]

Hi @onurbolaca

try this

const allData = []

let counter = 0;
do {
  try {
    const items = $items("RSS Feed Read", 0, counter);
    allData.push.apply(allData, items);
  } catch (error) {
    return [{allData}];  
  }

  counter++;
} while(true);

[onurbolaca]

Hey @BramKn ,

Thank you for your answer,

I applied what you provide and the data looks like this now;

I need to put them into attachments fields of send mail node;

[BramKn]

Hi @onurbolaca
Try this

const allData = []

let counter = 0;
do {
  try {
    const items = $items("RSS Feed Read", 0, counter);
    allData.push.apply(allData, items);
  } catch (error) {
    return [allData];  
  }

  counter++;
} while(true);

[onurbolaca]

Hey @BramKn ,

Still the same;

Do you know any other way?

Thank you!

This was working well but couldnt combine with what I have;

let results = [];


for (const item of $input.all()) {
    for (key of Object.keys(item.binary)) {
        results.push({
            json: {
                fileName: item.binary[key].fileName
            },
            binary: {
                data: item.binary[key],
            }
        });
    }
}


return results;

[BramKn]

It is simply the return data being wrong, and me not looking properly
another one

const allData = []

let counter = 0;
do {
  try {
    const items = $items("RSS Feed Read", 0, counter);
    allData.push.apply(allData, items);
  } catch (error) {
    return allData;  
  }

  counter++;
} while(true);

[onurbolaca]

Thanks @BramKn ,

This one merge the files as one result.

I cannot send them in one mail though, it sends two mails for each file;

Do you have any idea about how to send them in one mail?

It comes like this;

Drive Node

Merge Data JS Node

[BramKn]

Ah didn’t see you wanted to have em on one item.
You need to add them together idd. I don’t have a quick example for you.

[onurbolaca]

Thanks @BramKn ,

Here is how it works;

const result = { binary: {} };
const resultArr = [];

let counter = 0;
do {
  try {
    const items = $items("Download Files", 0, counter);

    // Add each item to the binary object of the result object
    items.forEach((item, index) => {
      result.binary[`fileName${counter + index}`] = item.binary.data;
    });

  } catch (error) {
    resultArr.push(result);

     return resultArr;
     
  }

  counter += items.length;
 
} while (true);

[FelixL]

I haven’t tried it yet, but in a never n8n version the “split in batches” node has a “done” output which as far is i understood it, should output all items at once.

You can aggregate these items into one with the List node.

EDIT: I do not know if that works with binary data (files).

[onurbolaca]

@FelixL ,

Please see above. It is possible with js code to combine all files as different arrays and same array like in here: Merge Two Files in First Row for One Mail