Hello everyone,
I am new to Make.com and need some help creating a scenario. Here is what I would like to accomplish:
- Image Selection: I have a Google Sheets spreadsheet where I check boxes next to image names.
- Image Retrieval: The images are stored in a folder on Google Drive.
- PDF Creation: I want to create a PDF that includes only the images that are checked in the Google Sheets spreadsheet.
Scenario Details:
- Step 1: Use Google Sheets to identify the checked images.
- Step 2: Retrieve the corresponding images from Google Drive.
- Step 3: Use PDF.co (or another service) to convert the images into a PDF file.
- Step 4: Save the generated PDF in a specific folder on Google Drive.
Questions:
- Modules to Use: Which specific Make.com modules should I use for each step?
- Configuration: How do I configure each module to retrieve the images and convert them into a PDF?
- Workflow: Are there any examples or similar guides that I could follow?
Additionally, I would really appreciate it if you could provide detailed explanations and screenshots, as I am feeling quite a beginner with Make.com.
Thank you very much for your help!
2 Likes
Hi Leo,
I’ve particularly created your scenario to train my skills and to help you:)
Step 1: Use Google Sheets Search rows module and filter checkbox equal to TRUE.
Step 2: Use an Iterator to iterate all the receiving bundles.
Step 3: Add Google drive search for files module, paste value from the iterator in Query field.
Step 4: Download found files using the corresponding module
Step 5: Add and setup
Pdf.co module. I don’t have an account so I missed that step.
Step 6: Upload the output files to the new folder.
I hope this was helpful 
Please, contact me if you need some consultation!
This is how the whole scenario would look like:
@mania_braun that doesn’t look right, and you are likely missing some kind of aggregator module, because that outputs more than one PDF file.
Every result (item/record) from a iterator module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.
Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and has applies to many use-cases.
There are other types of aggregator modules, click the below links to find out more:
samliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!
2 Likes
Thank you, @samliew
I didn’t notice the condition that one combined pdf should be output.
In this case, @Amilhat_Leo you should add an Array Agregator between the Download file module and the PDF.co module. However, I’m not sure how setting up the PDF.co module would look like as I haven’t tried it before.
Thanks for the guideline, I’ll try to set up it and tell you @mania_braun maybe @samliew could help too if I didn’t try ! 
1 Like
I have few problems, maybe you could help, I am so sorry if it is a mess I am a beginner.
My google sheet
![Capture d’écran 2024-06-03 à 19.23.20|690x431]
(upload://pn9qZ8KFmPG7Ucq5qXJB4vtdeIv.jpeg)
I called row a checkbox, you can just choose row A:
Next in the search field paste value from iterator.
In Agregator select name and data fields to agregate.
In the PDFco module switch to map data and in the Data field paste output from Aggregator.
Let me know, what will you get:)
Ok for the google sheets. That looks good. Thanks for the 1rst step !
After I don’t know if the iterator is ok bc I don’t understand what you mean by past the value.
Is it that ?
For google drive I dont know if it is correct set up
Agregator I have only the name (don’t find the data fields)
I’m here on PDF.co
Thanks again for your help !!
I lost my Google Drive connection yesterday, so I couldn’t show all the steps, but now I’ve figured out how to restore the connection and now I can show everything:)
I’ve made some changes in the scenario because the aggregator didn’t work correctly.
First of all, you don’t need an Iterator module.
In Google Drive search module choose “Search within file/folder names”, then paste Row B in the Query field:
As I can see you forgot to add the Download file module, so do it in this step and paste the File ID from the last module:
Here is a not-so-obvious thing about aggregator: it must be connected with the search row module to get the number of elements in array as many as are found checked in the table.
Choose the Serch Rows as a source module and select aggregated fields Name and Data:
In Pdfco module try to paste Array(Data) or if doesn’t work try full Array:
The last step will be Google Drive Upload file module, choose new folder, then paste Name and Data from pdfco module:
1 Like
Hei, it is me again. Thanks for your help again.
I’m near to the final lap.
I have a problem with the last module the google upload file & the date. It seems there is no date when in the input of the module. I don’t understand why.
