Google Sheets to Google Docs Transfer

[Charles_Henderson]

I’m new to Make. I’m trying to do a simple transfer of a Google Sheets document to a Google Docs document. I’ve tried to sample template in Make, but I can’t seem to get it to format properly.
I’m not sure if it’s a Google doc setup problem (right now it’s just a blank page) or Make scenario setup problem. Any advice is appreciated. Thanks

[ThakurHemansh]

To create a placeholder in Google Docs, follow these steps:

1. Use double curly braces to create a placeholder. For example, if you want to create a placeholder for a topic header, use {{header}}.
2. Create variables or placeholders for each field in the sheet.
   This is how the variables or placeholders look -

3. Use the Google Docs “create a document from template” module.

4. Search for the template document and select it.
   

   

5. Map the values from a row of the sheet to the fields in the document.

6. For every row, a new document will be created.

Hope this helps.

[Charles_Henderson]

Thanks. I have a spreadsheet with 12 rows. I set things up as you suggested. However, this creates 12 files with 1 row each. Something I’m missing?

[ThakurHemansh]

If you wish to create a doc with all rows in one
You can use a text aggregator
and then map that text aggregator field to variable
This will add all the rows to one text string
turn on advanced options so that you can choose the separator

[Charles_Henderson]

Does the Array Aggregator go director to the Google Doc? I don’t know how to map the fields in Google Doc. I only have 1 choice (Array) from the Aggregator. Sorry to be a pain.

[Charles_Henderson]

Saw my error. Should have used a Text Aggregator. Works now, but the formatting is off a little. Thanks for the help.

[ThakurHemansh]

No worries
you will take the google sheets search rows module or watch rows module
this is how your data will look

After that take a text aggregator turn on the advanced options
Select the search rows or watch rows module as your source
after that map the data how you want it to look for each row
Select row separator as new row so the data of each row comes in different rows

Now use the google docs create a doc from template module and you can map the field from text aggregator their

Sample Doc

Output Doc

I hope this helps
let me know if you need any assistance

[vendy]

Hello there @Charles_Henderson

Great to hear that you figured out the core of your troubles and managed to fix them with the assistance of @ThakurHemansh.

Also thank you very much for sharing the solution with us and keeping the community neat and organized.

Keep up the great job!