Several Google Sheets to Google Slides

What are you trying to achieve?

Hi All,

I´m new in Make.com. I´m trying to add data from several Google Sheets into a Google Slides presentation.
In the Google Slides template I have the placeholders:
{{audience_size}} this is for size of first_sheet
{{p1}},{{s1}} these two correspond to ‘Roofing penetration’ and ’ Selectivity’ of first row of the second_sheet, it´s the row of 18-24 in Name column
{{p2}}{{s2}} these two correspond to ‘Roofing penetration’ and ’ Selectivity’ of second row of the second_sheet, it´s the row of 25-34 in Name column
{{p3}}{{s3}} these two correspond to ‘Roofing penetration’ and ’ Selectivity’ of second row of the second_sheet, it´s the row of 25-34 in Name column

I hope anyone can help me on this…Thanks so much in advance!!

Steps taken so far

I manage to insert data of one sheet but not of the second one. I added an Array Aggregator module with the first sheet info and it works, I can add data in Google Slides. When I connect the second sheet in the Array Aggregator I don´t see the data in Google Slides values. I also tried using an Iterator module, but this generates several Google Slides as output, each one with only the info of one row. I need all the info in the same Google Slides Doc.

Screenshots: scenario setup, module configuration, errors




You should only have 1 module for Google Slides, and it should only execute a single time. So you should try assigning each placeholder using the Set Multiple Values module, then place all variables into a single Create from Template Slides module. That should get your complete set of data into slides.

Thanks Anonymax for your answer!
At the end I managed to do it, adding on Array Aggregator per Google sheet, and then I connected them to the Google Slides (screenshot with workflow)

1 Like