Merge files in Google Drive into One PDF

[Tárcio Sales]

Hi everyone!

I would like some help in order to merge some files into One PDF file. These files are in a Google Drive folder and I use the ID file to create the Blob. This files can be pictures (JPG, BMP), PDF or DOC files.

I tried to create an array of Blob or Bytes of the file but it did not work when I try to create the PDF file.

var blob1 = Utilities.newBlob(DriveApp.getFileById("17s1_taMHlseF51_RULE9d2mDticWgW2l")).getBytes() 

var blob2 = Utilities.newBlob(DriveApp.getFileById("19s1_taMHlseF51_RULE9d2mDticWgWXX")).getBytes()

blobs.push(blob1)
blobs.push(blob2) 

var pdf = Utilities.newBlob(blobs,"application/pdf") 

DriveApp.getFoldersByName(FOLDER).next().createFile(pdf)

Could someone give some idea ? Thanks.

Tarcio 

[Kanshi Tanaike]

Unfortunately, a PDF data cannot be created by directly merging the blobs of PDF. So as a workaround, how about using the external API?

For example,  there is "Merge PDF API".

https://www.convertapi.com/pdf-to-merge

If this was not what you want, I apologize.

[Tárcio Sales]

Hi Kanshi Tanaike

Thanks for your reply. It's exactly what I was looking for. However Google Drive restricts the access to our files, it's not possible to grant access to everyone (anonymous mode) then. When I try to load the file using the URL file, it did not work. :/

I will check how I can make it work with no changes on the security policies.

If you have some ides I would appreciate them.. thanks a lot.

 Request response (HTTP status code 500)

{
    "Code": 5001,
    "Message": "Conversion failed."
}

[Tárcio Sales]

Hi Kanshi Tanaike

I would like to share that it works perfectly as I was looking for. Thank you so much for your help! 

I just sent a blob into the Array in accordance the format. It worked! thank you! 

formData['Files[' + i + ']'] = DriveApp.getFileById(id).getBlob();

Tarcio

[Haseeb Baba]

Hi Tracio can you send me the source code for that ?

[Lucas Bontempo]

Hi Tarcio, It would be great if you can share the source code for that. Thank you!

[Koltek]

Hi Tárcio... It will be grate if you share with us the code...

[Tanaike]

As another approach after the V8 runtime can be used, is this post useful?
https://tanaikech.github.io/2023/01/10/merging-multiple-pdf-files-as-a-single-pdf-file-using-google-apps-script/