How to create google doc from google sheets

Question

Google Sheets

Good afternoon! I wanted to know if it is possible to automatically generate a document in Google Doc based on data from Google Spreadsheets?

Answer 1

Usually this is done like this:
1) Marks are made in the Google document, which are then replaced with data. For example
I, %NAME% , %BIRTHDAY % b.w. passport % PASSPORTINFO%
2) A table is created with data in the format
1 row = 1 output document
1 column = 1 replacement
3) A script is created that iterates over the data rows and creates replacements in the template
In Excel, by the way, you can also implement the algorithm the same

Answer 2

It's detailed here
https://youtu.be/Pt3REpKeA8g?list=PLEDdDho4QnGgn9q...