Take multiple rows from Google Sheets into a Google Doc

How To
,
1

Hi there, I am trying to take multiple rows from a google sheet via the watch column trigger and put multiple rows of data into a Google Doc Template.

This video explains more and I have attached the blueprint. Thanks in advance

https://www.loom.com/share/9d31ef713de243808e77401e74358654?sid=ec8a89de-cb98-4fb4-8224-79430a4d65ba

blueprint (1).json (11.1 KB)

2

Welcome to the Make community!

Every result (item/record) from a search/match module will output a bundle. To “combine” them into a single flow, 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.

samliew – request private consultation

Join the unofficial Make Discord server to chat with us!

2 Likes
3

Hi Thanks for coming back so quickly.

I have since done an array aggregator this is what the scenario looks like (attached blueprint)
blueprint (2).json (54.9 KB)

But now I am having this error for the image:

[
{
“from”: “drive”,
“name”: “Example Posts”,
“image”: {
“kix.2ogwqjnif973”: “https://i.ibb.co/64Bz0h6/Artboard-2.png”,
“kix.giyw7fz3uyw9”: “https://i.ibb.co/St0WjQT/Artboard-4.png”,
“kix.lqet326yxysq”: “https://i.ibb.co/F4TZs19/Artboard-3.png”
},
“select”: “dropdown”,
“document”: “/1qU_qVk8fDUI87iQskqHdh-zEDanfnebf/1GdZljjr91R5ABuc7eSdTskGAFpg3G1v_/1Ct9LQsLjOg9bDKuFXcq7AbBTLD3vgo6_/1s67LnEyXHmAm_32fyD6Eh0xReiDh1zVg0zzdh7Wuz3c”,
“folderId”: “/1qU_qVk8fDUI87iQskqHdh-zEDanfnebf/1GdZljjr91R5ABuc7eSdTskGAFpg3G1v_/1Ct9LQsLjOg9bDKuFXcq7AbBTLD3vgo6_”,
“requests”: {
“DateTime”: “05/29/2024 6:10PM GMT”,
“DateTime2”: “06/01/2024 13:10PM GMT”,
“DateTime3”: “06/03/2024 6:10PM GMT”
},
“destination”: “drive”
}
]

4

Don’t worry I found a solution. For anyone that wants to know how to do it this is the blueprint I have used to take info from multiple rows and import it into a Google Doc
blueprint (3).json (40.2 KB)

2 Likes
5

Hello there @christargett :wave:

Just wanted to step in and pat you on the back for the great solution you figured out!

Thank you very much for sharing it with us. This way we keep our community organized and neat. :broom: