With Sheetgo you can automate your spreadsheet-related processes in a variety of ways, including the generation of a single PDF document that contains the data from multiple spreadsheets.

To achieve this goal you need to turn on the Group PDF files button on the Advance setting of the Generate PDF step.

Here's an example of a workflow that uses this feature.

You need to start creating an automation that will pull the data from the multiple sources you have. To do this choose the Multiple files option

Choose all the files that have the data you want to turn into a PDF. Before going to the next step be sure that you've selected the right tabs you want to use from each file. When you are certain about your source selection click on Next step.

Since we are just turning multiple spreadsheet data into a single PDF, we won't need to use any of the data processors to manipulate the information that is being transferred, so we'll Skip this step.

For the destination you can choose first to send the data into another spreadsheet, since we are not using the Merge data processor the data from each spreadsheet will be transferred into a unique tab on the destination file. But you can also generate the PDF directly, and whiteout the spreadsheet step. To do this just select Generate PDF.

Now select the folder where the PDF files will be saved. You can choose to save them in a new folder or an existing one.

After selecting the folder go to advanced settings and turn on the GROUP PDF FILES button. When choosing this feature, instead of generating one new PDF file for each spreadsheet it will create a single PDF where the data from each spreadsheet will be on a different page. So instead of having three new PDFs, we'll have just one file, with three pages.

If you want you can keep editing this automation to add a new step to send this PDF via email. So that every time the workflow runs it will automatically generate a new PDF file and send it via email.