# Google Sheets to Google Docs Transfer
**URL:** https://community.make.com/t/google-sheets-to-google-docs-transfer/25735
**Category:** Beginner Questions
**Tags:** google-sheets
**Created:** [January 29, 2024, 12:01pm UTC](https://community.make.com/t/google-sheets-to-google-docs-transfer/25735 "2024-01-29T12:01:22Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Charles\_Henderson](https://community.make.com/u/Charles_Henderson)
#### Post date: [January 29, 2024, 12:01pm UTC](https://community.make.com/t/google-sheets-to-google-docs-transfer/25735/1 "2024-01-29T12:01:22Z")
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
---
### Author:  [@ThakurHemansh](https://community.make.com/u/ThakurHemansh)
#### Post date: [January 29, 2024, 12:22pm UTC](https://community.make.com/t/google-sheets-to-google-docs-transfer/25735/2 "2024-01-29T12:22:05Z")
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 -
1. Use the Google Docs “create a document from template” module.
1. Search for the template document and select it.
2. Map the values from a row of the sheet to the fields in the document.
3. For every row, a new document will be created.
Hope this helps.
---
### Author:  [@Charles\_Henderson](https://community.make.com/u/Charles_Henderson)
#### Post date: [January 29, 2024, 3:57pm UTC](https://community.make.com/t/google-sheets-to-google-docs-transfer/25735/3 "2024-01-29T15:57:16Z")
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?
---
### Author:  [@ThakurHemansh](https://community.make.com/u/ThakurHemansh)
#### Post date: [January 29, 2024, 4:06pm UTC](https://community.make.com/t/google-sheets-to-google-docs-transfer/25735/4 "2024-01-29T16:06:14Z")
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
---
### Author:  [@Charles\_Henderson](https://community.make.com/u/Charles_Henderson)
#### Post date: [January 29, 2024, 4:25pm UTC](https://community.make.com/t/google-sheets-to-google-docs-transfer/25735/5 "2024-01-29T16:25:44Z")
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.
---
### Author:  [@Charles\_Henderson](https://community.make.com/u/Charles_Henderson)
#### Post date: [January 29, 2024, 4:44pm UTC](https://community.make.com/t/google-sheets-to-google-docs-transfer/25735/6 "2024-01-29T16:44:19Z")
Saw my error. Should have used a Text Aggregator. Works now, but the formatting is off a little. Thanks for the help.
---
### Author:  [@ThakurHemansh](https://community.make.com/u/ThakurHemansh)
#### Post date: [January 29, 2024, 4:54pm UTC](https://community.make.com/t/google-sheets-to-google-docs-transfer/25735/7 "2024-01-29T16:54:54Z")
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
---
### Author:  [@vendy](https://community.make.com/u/vendy)
#### Post date: [January 30, 2024, 11:34am UTC](https://community.make.com/t/google-sheets-to-google-docs-transfer/25735/8 "2024-01-30T11:34:03Z")
Hello there @Charles_Henderson :blob_wave:
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! :party_blob:
---
### Author:  [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [February 12, 2024, 11:28pm UTC](https://community.make.com/t/google-sheets-to-google-docs-transfer/25735/9 "2024-02-12T23:28:25Z")